From f4cd26a42996d2f74dbbca5295389cb7f0a2a7c4 Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Sat, 7 Jan 2017 09:52:36 +0100 Subject: add AMORLINC testcase Change-Id: Id588afe3c447ce938f91c51e084685493ba83fd5 Reviewed-on: https://gerrit.libreoffice.org/32813 Tested-by: Jenkins Reviewed-by: Markus Mohrhard --- .../data/functions/financial/fods/amorlinc.fods | 1929 ++++++++++++++++++++ 1 file changed, 1929 insertions(+) create mode 100644 sc/qa/unit/data/functions/financial/fods/amorlinc.fods (limited to 'sc') diff --git a/sc/qa/unit/data/functions/financial/fods/amorlinc.fods b/sc/qa/unit/data/functions/financial/fods/amorlinc.fods new file mode 100644 index 000000000000..d9dbff1d53ca --- /dev/null +++ b/sc/qa/unit/data/functions/financial/fods/amorlinc.fods @@ -0,0 +1,1929 @@ + + + + 2017-01-07T09:50:28.299457032P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/92a1ad1f36b6d3cc13135a8c0805508933011577 + + + 0 + 0 + 61598 + 16333 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + false + + + 2 + 27 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 11 + 0 + 90 + 60 + true + false + + + Sheet2 + 1241 + 0 + 90 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + false + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + rgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + + + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + + + + - + + + + + + + + + + + + - + + + + + + + + + + + + + - + + + + + + + + + + + + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + + + / + + / + + + + + + + / + + / + + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + + - + + + + + + + + + - + + + + + + + + - + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + - + + + + + + + + + + + + + + + + - + + + + + + + + - Kč + + + + + + + + + + + + + + + + - + + + + + + + + - + + + + + + + + + + + + + + + + + + - + + + + + + + + - + + + + + + + + + + + + + : + + + + + : + + : + + + + + : + + + + + + + Yes + + + Yes + + + No + + + + + True + + + True + + + False + + + + + On + + + On + + + Off + + + + + ¥€ + + + + + + + + + ( + + + + + + ) + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + % + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + + + + + + + + + + + + + AMORLINC Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple AMORLINC formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + cost + + + 10000 + + + Data + + + Description + + + + + 2400 + + + 39679 + + + 39813 + + + 300 + + + 1 + + + 0.15 + + + 1 + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(J1,J2,J3,J4,J5,J6,J7) + + + + + purchase date + + + 03/01/2012 + + + 2400 + + + Cost + + + + 2401 + + + 39680 + + + 39814 + + + 301 + + + 2 + + + 0.16 + + + 2 + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.3,1) + + + + + first period + + + 12/31/2012 + + + 03/01/2012 + + + 39679 + + + Date purchased + + + + 2402 + + + 39681 + + + 39815 + + + 302 + + + 3 + + + 0.17 + + + 3 + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.3,1) + + + + + salvage + + + 1500 + + + 39813 + + + End of the first period + + + + + 2403 + + + 39682 + + + 39816 + + + 303 + + + 4 + + + 0.18 + + + 4 + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.3,0) + + + + period + + + 1 + + + 300 + + + Salvage value + + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.3,3) + + + + rate + + + 30.00% + + + 1 + + + Period + + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.3,4) + + + + basis + + + 1 + + + 0.15 + + + Depreciation rate + + + + + 360 + + + + + + 3,000.00 + + + 3000 + + + TRUE + + + =AMORLINC(J1,J2,J3,J4,J5,J6,) + + + + + 1 + + + Actual basis (see above) + + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(J1,J2,J3,J4,J5,J6) + + + + + + + + + 360 + + + 360 + + + TRUE + + + =AMORLINC(L2,L3,L4,L5,L6,L7,L8) + + + + basis + + + 0 + + + + + + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(K1,K2,K3,K4,K5,K6,K7) + + Note: The behavior of this function is implementation-defined in cases where purchaseDate = firstPeriodEndDate. + + + + 1 + + + + + + + Err:502 + + + error + + + TRUE + + + =AMORLINC(-10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.3,4) + + + + 2 + + + + + + Err:502 + + + error + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0-3,4) + + + + 3 + + + + + + + + Err:502 + + + error + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.3,-4) + + + + 4 + + + + + + Err:502 + + + error + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,-1.3,4) + + + + + + + + Err:502 + + + error + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),-1500,1,0.3,4) + + + Tdf#100528 + + + + + + + + + + Err:502 + + + error + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,-1,0.3,4) + + + Tdf#100528 + + + + + + + + 0 + + + 0 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,1.3,4) + + + Tdf#100528 + + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.3,2) + + + Basis 2 tdf#100499 + + + + + + 3000 + + + 3000 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1508,1,0.3,2) + + + + + + 1722.22222222222 + + + 1722.22222222222 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.8,2) + + + + + + 3416.66666666667 + + + 3416.66666666667 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.6,2) + + + + + + 4000 + + + 4000 + + + TRUE + + + =AMORLINC(10000,DATE(2012,3,1),DATE(2012,12,31),1500,1,0.4,2) + + + + + + Err:502 + + + Err:502 + + + TRUE + + + {=AMORLINC(P1:P4,Q1:Q4,R1:R4,S1:S4,T1:T4,U1:U4,V1:V4)} + + + + + + Err:502 + + + Err:502 + + + TRUE + + + {=AMORLINC(P1:P4,Q1:Q4,R1:R4,S1:S4,T1:T4,U1:U4,V1:V4)} + + + + + + Err:502 + + + Err:502 + + + TRUE + + + {=AMORLINC(P1:P4,Q1:Q4,R1:R4,S1:S4,T1:T4,U1:U4,V1:V4)} + + + + + + Err:502 + + + Err:502 + + + TRUE + + + {=AMORLINC(P1:P4,Q1:Q4,R1:R4,S1:S4,T1:T4,U1:U4,V1:V4)} + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + \ No newline at end of file -- cgit