From 33f5bc54aaa7fe7aa9335726e30f9c349155e04d Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Thu, 1 Dec 2016 18:28:34 +0100 Subject: sc test functions - move database functions to the new directory Change-Id: Ief5121967b12692c60a4b462617d91786e901b9e Reviewed-on: https://gerrit.libreoffice.org/31504 Tested-by: Jenkins Reviewed-by: Markus Mohrhard --- .../data/functions/database/fods/daverage.fods | 1543 +++++++++ .../unit/data/functions/database/fods/dcount.fods | 2943 ++++++++++++++++ .../unit/data/functions/database/fods/dcounta.fods | 1494 ++++++++ sc/qa/unit/data/functions/database/fods/dget.fods | 1633 +++++++++ .../data/functions/database/fods/dproduct.fods | 1515 ++++++++ .../unit/data/functions/database/fods/dstdev.fods | 1457 ++++++++ .../unit/data/functions/database/fods/dstdevp.fods | 1357 ++++++++ sc/qa/unit/data/functions/database/fods/dsum.fods | 3629 ++++++++++++++++++++ sc/qa/unit/data/functions/database/fods/dvar.fods | 1686 +++++++++ sc/qa/unit/data/functions/database/fods/dvarp.fods | 1663 +++++++++ sc/qa/unit/data/functions/fods/daverage.fods | 1543 --------- sc/qa/unit/data/functions/fods/dcount.fods | 2943 ---------------- sc/qa/unit/data/functions/fods/dcounta.fods | 1494 -------- sc/qa/unit/data/functions/fods/dget.fods | 1633 --------- sc/qa/unit/data/functions/fods/dproduct.fods | 1515 -------- sc/qa/unit/data/functions/fods/dstdev.fods | 1457 -------- sc/qa/unit/data/functions/fods/dstdevp.fods | 1357 -------- sc/qa/unit/data/functions/fods/dsum.fods | 3629 -------------------- sc/qa/unit/data/functions/fods/dvar.fods | 1686 --------- sc/qa/unit/data/functions/fods/dvarp.fods | 1663 --------- 20 files changed, 18920 insertions(+), 18920 deletions(-) create mode 100644 sc/qa/unit/data/functions/database/fods/daverage.fods create mode 100644 sc/qa/unit/data/functions/database/fods/dcount.fods create mode 100644 sc/qa/unit/data/functions/database/fods/dcounta.fods create mode 100644 sc/qa/unit/data/functions/database/fods/dget.fods create mode 100644 sc/qa/unit/data/functions/database/fods/dproduct.fods create mode 100644 sc/qa/unit/data/functions/database/fods/dstdev.fods create mode 100644 sc/qa/unit/data/functions/database/fods/dstdevp.fods create mode 100644 sc/qa/unit/data/functions/database/fods/dsum.fods create mode 100644 sc/qa/unit/data/functions/database/fods/dvar.fods create mode 100644 sc/qa/unit/data/functions/database/fods/dvarp.fods delete mode 100644 sc/qa/unit/data/functions/fods/daverage.fods delete mode 100644 sc/qa/unit/data/functions/fods/dcount.fods delete mode 100644 sc/qa/unit/data/functions/fods/dcounta.fods delete mode 100644 sc/qa/unit/data/functions/fods/dget.fods delete mode 100644 sc/qa/unit/data/functions/fods/dproduct.fods delete mode 100644 sc/qa/unit/data/functions/fods/dstdev.fods delete mode 100644 sc/qa/unit/data/functions/fods/dstdevp.fods delete mode 100644 sc/qa/unit/data/functions/fods/dsum.fods delete mode 100644 sc/qa/unit/data/functions/fods/dvar.fods delete mode 100644 sc/qa/unit/data/functions/fods/dvarp.fods (limited to 'sc/qa') diff --git a/sc/qa/unit/data/functions/database/fods/daverage.fods b/sc/qa/unit/data/functions/database/fods/daverage.fods new file mode 100644 index 000000000000..9c37f977eea4 --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/daverage.fods @@ -0,0 +1,1543 @@ + + + + 2016-05-17T13:18:24.223000000P0D1LibreOffice/5.1.1.3$Windows_x86 LibreOffice_project/89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d + + + 0 + 0 + 31628 + 27629 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 3 + 7 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1168 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + true + true + true + true + 12632256 + true + false + true + 3 + true + false + false + 1270 + 1270 + 1 + 1 + true + true + true + PDF-XChange 4.0 + +AX+/1BERi1YQ2hhbmdlIDQuMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUERGLVhDaGFuZ2UgNC4wAAAAAAAAAAAAAAAAAAAAAAAWAAEAGgUAAAAAAAAEAAhSAAAEdAAAM1ROVwYAUABEAEYALQBYAEMAaABhAG4AZwBlACAANAAuADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAATcADgEEwwBAAEACQCaCzQIZAABAAAALAECAAEALAEAAAAAQQA0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAAAADQIAACaCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAERDWFAEAAAAAQAAAAAAAAA0CAAAmgsAAAAAAAAsAQAAZAAAAAEAAABDAHUAcgByAGUAbgB0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQwA6AFwAcABvAHIAdABhAGIAbABlAFwAUABvAHIAdABhAGIAbABlAEEAcABwAHMAXABMAGkAYgByAGUATwBmAGYAaQBjAGUAUABvAHIAdABhAGIAbABlAFwAQQBwAHAAXABsAGkAYgByAGUAbwBmAGYAaQBjAGUAXABwAHIAbwBnAHIAYQBtAFwAcwBvAGYAZgBpAGMAZQAuAGIAaQBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIAQ09NUEFUX0RVUExFWF9NT0RFDgBEVVBMRVhfVU5LTk9XTg== + + + en + US + + + + + + 0 + false + true + true + false + false + false + 7 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + DAVERAGE Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DAVERAGE formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 39 + + + 39 + + + PRAVDA + + DAVERAGE(J1:N10;"Weight";J44:N45) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + + + 44,25 + + + 44,25 + + + PRAVDA + + DAVERAGE(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + + 37,5 + + + 37,5 + + + PRAVDA + + DAVERAGE(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + + 39,4 + + + 39,4 + + + PRAVDA + + DAVERAGE(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + + + 37,5 + + + 37,5 + + + PRAVDA + + DAVERAGE(J1:N10;"Weight";J56:N57) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + + 42 + + + 42 + + + PRAVDA + + + DAVERAGE(database;"Weight";criteria) + + + AOO bug #118060 + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + + + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + + + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + + + + Irene + + + 2 + + + 8 + + + 1000 + + + 42 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 9 + + + + + + + + + 10 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 2 + + + >7 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + >=E + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + Frank + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 10 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 7 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 8 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + [E-F].* + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + Age + + + + + + + >0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/database/fods/dcount.fods b/sc/qa/unit/data/functions/database/fods/dcount.fods new file mode 100644 index 000000000000..392bc86d017d --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/dcount.fods @@ -0,0 +1,2943 @@ + + + + 2016-05-24T15:26:03.868062761P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/369ca1d72bc877c6ccce991c92ae1a246956ca57 + + + 0 + 0 + 46734 + 29633 + + + view1 + + + 1 + 13 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + + + 22 + 9 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + + + Sheet2 + 1241 + 0 + 90 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + cs + CZ + + + + + + en + US + + + + + + es + ES + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + $ + + + + + ($ + + ) + + + + $ + + + + + + ($ + + ) + + + + $ + + + + + ($ + + ) + + + + $ + + + + + + ($ + + ) + + + + + + + - + + + + + + + + + - + + + + + + + + - + + + + + + + + + - + + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + $ + + + + + + $ + + ( + + ) + + + $ + + - + + + + + + + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + + + $ + + + + + + $ + + ( + + ) + + + $ + + - + + + + + + + + + + + + + : + + + + + : + + : + + + + + : + + + + + + + + + € + + + + - + + + € + + + + £ + + + + £ + + + + -£ + + + + + £ + + + + + -£ + + + + + £ + + + + £ + + + + -£ + + + + + £ + + + + + -£ + + + + + + + + + - + + + + + - + + + + + + + + + + £ + + + + + -£ + + + + + £- + + + + + + + + + + + + + + - + + + + + - + + + + + + + + + + + + £ + + + + + -£ + + + + + £- + + + + + + + + + + + + + + + $ + + + + + $( + + ) + + + $- + + + + + + + + + + + + + + ( + + ) + + + - + + + + + + + + + + $ + + + + + $( + + ) + + + $- + + + + + + + + + + + + + + + + ( + + ) + + + - + + + + + + + + + + + + + + + £ + + + + + % + + + + + + £ + + + + + , + + + + , + + + + £ + + + + + + + Yes + + + Yes + + + No + + + + + True + + + True + + + False + + + + + On + + + On + + + Off + + + + + € + + + + + + + ( + € + + + ) + + + + € + + + + + + + + £ + + + + + (£ + + ) + + + + + + + + % + + + + + + + + + + - + + - + + + + + - + + + + + - + + + + + : + + + + + + + : + + : + + + + + + + / + + / + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DCOUNT Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DCOUNT formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + data1 + + + data2 + + + AOO #65221 + + + + pet + + + name + + + AOO #84168 + + + + + 1 + + + 1 + + + PRAVDA + + DCOUNT(J1:N10;"Age";J23:N24) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + 1 + + + + dog + + + fido + + + + + + 3 + + + 3 + + + PRAVDA + + DCOUNT(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + 2 + + + + cat + + + meow + + + + + + 4 + + + 4 + + + PRAVDA + + DCOUNT(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + + + 4 + + + + dog + + + rower + + + + + + 2 + + + 2 + + + PRAVDA + + DCOUNT(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + 0 + + + 8 + + + + + + 3 + + + 3 + + + PRAVDA + + DCOUNT(J1:N11;"Weight";J56:N57) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + + + 16 + + + + pet + + + name + + + + + + 2 + + + 2 + + + PRAVDA + + DCOUNT(database;"Weight";criteria) + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + 0 + + + 32 + + + + dog + + + + + + 3 + + + 3 + + + PRAVDA + + DCOUNT(J1:N11;"Age";J38:N39) + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + 0 + + + 64 + + + + + + 3 + + + 3 + + + PRAVDA + + + DCOUNT(J1:N11;N(COLUMN(A1:B1))+2;J38:N39) + + + AOO #114293 + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + 2 + + + should return 0 + + + + + + 3 + + + 3 + + + PRAVDA + + DCOUNT(J1:N11;COLUMN(A1)+2;J38:N39) + + + + Irene + + + 2 + + + 13 + + + 1000 + + + 42 + + + The 0 in DCOUNT and DCOUNTA is thesame as a missing argument, and Excel for a missing argument in DCOUNTand DCOUNTA just returns the number of records that match criteria, notdistinguishing between numeric and other for DCOUNT. This is differentfrom the behavior if an actual field was specified where for DCOUNT onlynumeric content is counted. + + + + + + 3 + + + 3 + + + PRAVDA + + DCOUNT(J1:N11;K8+2;J38:N39) + + + + IAndyBetty + + + 6 + + + 15 + + + 10000 + + + 55 + + + + + + 3 + + + 3 + + + PRAVDA + + DCOUNT($Q$1:$R$8;"data2";$Q$14:$Q$15) + + + Criterion is reference to empty cell + + + + + + 3 + + + 3 + + + PRAVDA + + DCOUNT($Q$1:$R$8;"data2";$S$14:$S$15) + + + Criterion is 0 + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + criteria + + + + + + + 3 + + + 3 + + + PRAVDA + + DCOUNT($Q$1:$R$8;"data2";$U$14:$U$15) + + + Criterion is literal 0 + + + + 10 + + + + data1 + + + + + + 4 + + + 4 + + + PRAVDA + + DCOUNT($Q$1:$R$8;"data2";$X$14:$X$15) + + + + + 11 + + + + 0 + + + + + + 0 + + + + + + 0 + + + <> + + + = + + + <>0 + + + + + + 1 + + + 1 + + + PRAVDA + + AOO109200 : DCOUNT(Data;"Y";B12:B13) + + + AOO #109200 + + + + Criterion is reference to empty cell + + + Criterion is empty string + + + Criterion is 0 + + + Criterion is empty string + + + Criterion is literal 0 + + + + + + 1 + + + 1 + + + PRAVDA + + AOO109200 : DCOUNT(Data;"Y";C12:C13) + + + AOO #109200 + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 1 + + + 1 + + + PRAVDA + + DCOUNT(J1:N10;0;J23:N24) + + + For the DatabaseField parameter you can enter a cell to specify the column, or enter the number 0 for the entire database. + + + + 2 + + + >12 + + + + + + 0 + + + 0 + + + PRAVDA + + + DCOUNT(W1:X4;2;W6:X7) + + + only text + + + + 3 + + + + + + 1 + + + 1 + + + PRAVDA + + DCOUNT(J1:N10;;J23:N24) + + Tdf#70806; Yes, ODFFdoesn't allow it, but Excel in this case defaults the missing argumentto 1, which we also do for interop. + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + >=I + + + + + + + + + 1 + + + #Error + + + NEPRAVDA + + + + Tdf#70806 + + + + Email to Eike,Winfried + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + + + Frank + + + + + + + + + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + + + + + 1 + + + + + + + + + + + + + 2 + + + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 10 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 7 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 8 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + [E,I].* + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + Age + + + + + + + + >12 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + AOO 109200 + + + + + + + + + + Data + + + + + + + X + + + Y + + + Z + + + + + + + 1 + + + 1000000 + + + + + + + + 10 + + + 2 + + + 10000000 + + + + + + + 100 + + + 10000 + + + 100000000 + + + + + + + + + + X + + + + + + 10 + + + 10 + + + 10 + + + + + + + + 1 + + + 1 + + + + + + + + + + + + + + 4 + + + + + + + + + Interest Rate + + + Bal Now + + + + + 0 + + + 1 + + + + + 0.0225 + + + 2 + + + + + 0.017 + + + 3 + + + + + 0.053 + + + 4 + + + + + 0.0401 + + + 5 + + + + + 0.0362 + + + 6 + + + + + 0.065 + + + 7 + + + + + 0.02 + + + 8 + + + + + 0.031 + + + 9 + + + + + 0.012 + + + 10 + + + + + 0.021 + + + 11 + + + + + 0.05 + + + 12 + + + + + 0 + + + 13 + + + + + 0.01 + + + 14 + + + + + 0 + + + 15 + + + + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/database/fods/dcounta.fods b/sc/qa/unit/data/functions/database/fods/dcounta.fods new file mode 100644 index 000000000000..1080e2cf64a5 --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/dcounta.fods @@ -0,0 +1,1494 @@ + + + + 2016-05-20T15:18:22.829709022P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/eb7593daa4bac21bd68182c8bbbd3ee3bd7b64dd + + + 0 + 0 + 31628 + 27629 + + + view1 + + + 2 + 17 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 2 + 11 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet1 + 1241 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + DCOUNTA Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DCOUNTA formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 2 + + + 2 + + + PRAVDA + + DCOUNTA(J1:N10;"Weight";J44:N45) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + + + 4 + + + 4 + + + PRAVDA + + DCOUNTA(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + + 2 + + + 2 + + + PRAVDA + + DCOUNTA(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + + 5 + + + 5 + + + PRAVDA + + DCOUNTA(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + + + 2 + + + 2 + + + PRAVDA + + DCOUNTA(J1:N10;"Weight";J56:N57) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + + 9 + + + 9 + + + PRAVDA + + + DCOUNTA(database;"Weight";criteria) + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + + + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + + + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + + + + Irene + + + 2 + + + 8 + + + 1000 + + + 42 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 9 + + + + + + + + + 10 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 2 + + + >7 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + >=E + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + Frank + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 10 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 7 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 8 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + [E-F].* + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + Age + + + + + + + >0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/database/fods/dget.fods b/sc/qa/unit/data/functions/database/fods/dget.fods new file mode 100644 index 000000000000..7e26ae4979b9 --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/dget.fods @@ -0,0 +1,1633 @@ + + + + 2016-05-21T07:20:18.280767228P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/eb7593daa4bac21bd68182c8bbbd3ee3bd7b64dd + + + 0 + 0 + 31628 + 27643 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 4 + 9 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet1 + 939 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + DGET Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DGET formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 7 + + + 7 + + + PRAVDA + + DGET(J1:N10;"Age";J23:N24) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + + + 48 + + + 48 + + + PRAVDA + + DGET(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + + 42 + + + 42 + + + PRAVDA + + DGET(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + + 42 + + + 42 + + + PRAVDA + + DGET(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + + + 33 + + + 33 + + + PRAVDA + + DGET(J1:N10;"Weight";J56:N57) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + + 42 + + + 42 + + + PRAVDA + + + DGET(database;"Weight";criteria) + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + + + AndyBetty + + + AndyBetty + + + PRAVDA + + DGET(J1:N11;1;J38:N39) + + + Bug #49052 + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + + + + + + TODO AOO #102750 ext references + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + + + + Irene + + + 2 + + + 13 + + + 1000 + + + 42 + + + + + + + + + AndyBetty + + + 6 + + + 15 + + + 10000 + + + 55 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 14 + + + + + + + + + 11 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 2 + + + >12 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + >=I + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + Frank + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 6 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 10 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 7 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 8 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + [E].* + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + Age + + + + + + + >12 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/database/fods/dproduct.fods b/sc/qa/unit/data/functions/database/fods/dproduct.fods new file mode 100644 index 000000000000..7a41f7175f6a --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/dproduct.fods @@ -0,0 +1,1515 @@ + + + + 2016-05-22T07:55:22.797656367P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/eb7593daa4bac21bd68182c8bbbd3ee3bd7b64dd + + + 0 + 0 + 22009 + 4261 + + + view1 + + + 2 + 17 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 4 + 4 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1241 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + DPRODUCT Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DPRODUCT formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + 1512 + + + 1512 + + + PRAVDA + + DPRODUCT(J1:N10;"Weight";J44:N45) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + + 3769920 + + + 3769920 + + + PRAVDA + + DPRODUCT(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + 1386 + + + 1386 + + + PRAVDA + + DPRODUCT(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + 92207808 + + + 92207808 + + + PRAVDA + + DPRODUCT(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + + 1386 + + + 1386 + + + PRAVDA + + DPRODUCT(J1:N10;"Weight";J56:N57) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + + + Irene + + + 2 + + + 8 + + + 1000 + + + 42 + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 9 + + + + + + + + + 10 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 2 + + + >7 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + >=E + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + Frank + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 10 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 7 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 8 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + [E-F].* + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/database/fods/dstdev.fods b/sc/qa/unit/data/functions/database/fods/dstdev.fods new file mode 100644 index 000000000000..a5c04acb186b --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/dstdev.fods @@ -0,0 +1,1457 @@ + + + + 2016-05-19T20:41:43.049324634P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/eb7593daa4bac21bd68182c8bbbd3ee3bd7b64dd + + + 0 + 0 + 27162 + 25809 + + + view1 + + + 3 + 17 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 4 + 4 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1241 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + DSTDEV Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DSTDEV formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + 4,24264068711929 + + + 4,24264068711929 + + + PRAVDA + + DSTDEV(J1:N10;"Weight";J44:N45) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + + 4,78713553878169 + + + 4,78713553878169 + + + PRAVDA + + DSTDEVPJ1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + 6,36396103067893 + + + 6,36396103067893 + + + PRAVDA + + DSTDEV(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + 4,6690470119715 + + + 4,6690470119715 + + + PRAVDA + + DSTDEV(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + + 6,36396103067893 + + + 6,36396103067893 + + + PRAVDA + + + DSTDEV(J1:N10;"Weight";J56:N57) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + + + Irene + + + 2 + + + 8 + + + 1000 + + + 42 + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 9 + + + + + + + + + 10 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 2 + + + >7 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + >=E + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + Frank + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 10 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 7 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 8 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + [E-F].* + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/database/fods/dstdevp.fods b/sc/qa/unit/data/functions/database/fods/dstdevp.fods new file mode 100644 index 000000000000..bfc321a5c3d8 --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/dstdevp.fods @@ -0,0 +1,1357 @@ + + + + 2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/369ca1d72bc877c6ccce991c92ae1a246956ca57 + + + 0 + 0 + 22009 + 4261 + + + view1 + + + 3 + 16 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 9 + 5 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet1 + 1241 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + DSTDEVP Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DSTDEVP formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + 3 + + + 3 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J44:N45) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + + 4,14578098794425 + + + 4,14578098794425 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + 4,5 + + + 4,5 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + 4,17612260356422 + + + 4,17612260356422 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + + 0 + + + 0 + + + PRAVDA + + DSTDEVP(J1:N10;"Weight";J23:N24) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + 4,5 + + + 4,5 + + + PRAVDA + + + DSTDEVP(J1:N10;"Weight";J56:N57) + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + + + Irene + + + 2 + + + 8 + + + 1000 + + + 42 + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 9 + + + + + + + + + 10 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 2 + + + >7 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + >=E + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + Frank + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 10 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 7 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 8 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + [E-F].* + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/database/fods/dsum.fods b/sc/qa/unit/data/functions/database/fods/dsum.fods new file mode 100644 index 000000000000..2e4f9404da65 --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/dsum.fods @@ -0,0 +1,3629 @@ + + + + 2016-05-24T18:20:55.605253990P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/369ca1d72bc877c6ccce991c92ae1a246956ca57 + + + 0 + 0 + 44476 + 29296 + + + view1 + + + 2 + 26 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + + + 2 + 14 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + + + 4 + 20 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + + + 3 + 19 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + + + Sheet1 + 1241 + 0 + 90 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + cs + CZ + + + + + + en + US + + + + + + es + ES + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + $ + + + + + ($ + + ) + + + + $ + + + + + + ($ + + ) + + + + $ + + + + + ($ + + ) + + + + $ + + + + + + ($ + + ) + + + + + + + - + + + + + + + + + - + + + + + + + + - + + + + + + + + + - + + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + $ + + + + + + $ + + ( + + ) + + + $ + + - + + + + + + + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + + + $ + + + + + + $ + + ( + + ) + + + $ + + - + + + + + + + + + + + + + : + + + + + : + + : + + + + + : + + + + + + + + + € + + + + - + + + € + + + + £ + + + + £ + + + + -£ + + + + + £ + + + + + -£ + + + + + £ + + + + £ + + + + -£ + + + + + £ + + + + + -£ + + + + + + + + + - + + + + + - + + + + + + + + + + £ + + + + + -£ + + + + + £- + + + + + + + + + + + + + + - + + + + + - + + + + + + + + + + + + £ + + + + + -£ + + + + + £- + + + + + + + + + + + + + + + $ + + + + + $( + + ) + + + $- + + + + + + + + + + + + + + ( + + ) + + + - + + + + + + + + + + $ + + + + + $( + + ) + + + $- + + + + + + + + + + + + + + + + ( + + ) + + + - + + + + + + + + + + + + + + + £ + + + + + % + + + + + + £ + + + + + , + + + + , + + + + £ + + + + + + + Yes + + + Yes + + + No + + + + + True + + + True + + + False + + + + + On + + + On + + + Off + + + + + € + + + + + + + ( + € + + + ) + + + + € + + + + + + + + £ + + + + + (£ + + ) + + + + + + + + % + + + + + + + + + + - + + - + + + + + - + + + + + - + + + + + : + + + + + + + : + + : + + + + + + + / + + / + + + + : + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + % + + + + . + + . + + + + + . + + . + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DSUM Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DSUM formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + data1 + + + data2 + + + AOO #65221 + + + + + + 7 + + + 7 + + + PRAVDA + + DSUM(J1:N10;"Age";J23:N24) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + 1 + + + + + + 141 + + + 141 + + + PRAVDA + + DSUM(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + 2 + + + + + + 177 + + + 177 + + + PRAVDA + + DSUM(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + + + 4 + + + + + + 97 + + + 97 + + + PRAVDA + + DSUM(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + 0 + + + 8 + + + + + + 75 + + + 75 + + + PRAVDA + + DSUM(J1:N10;"Weight";J56:N57) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + + + 16 + + + + + + 97 + + + 97 + + + PRAVDA + + DSUM(database;"Weight";criteria) + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + 0 + + + 32 + + + + + + 28 + + + 28 + + + PRAVDA + + DSUM(J1:N11;"Age";J38:N39) + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + 0 + + + 64 + + + + + + 28 + + + 28 + + + PRAVDA + + + DSUM(J1:N11;N(COLUMN(A1:B1))+2;J38:N39) + + + AOO #114293 + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + 28 + + + 28 + + + PRAVDA + + DSUM(J1:N11;COLUMN(A1)+2;J38:N39) + + + + Irene + + + 2 + + + 13 + + + 1000 + + + 42 + + + + + + 28 + + + 28 + + + PRAVDA + + DSUM(J1:N11;K8+2;J38:N39) + + + + IAndyBetty + + + 6 + + + 15 + + + 10000 + + + 55 + + + + + + 104 + + + 104 + + + PRAVDA + + DSUM($Q$1:$R$8;"data2";$Q$14:$Q$15) + + + Criterion is reference to empty cell + + + + + + 104 + + + 104 + + + PRAVDA + + DSUM($Q$1:$R$8;"data2";$S$14:$S$15) + + + Criterion is 0 + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + criteria + + + + + + + 104 + + + 104 + + + PRAVDA + + DSUM($Q$1:$R$8;"data2";$U$14:$U$15) + + + Criterion is literal 0 + + + + 10 + + + + data1 + + + + + 23 + + + 23 + + + PRAVDA + + DSUM($Q$1:$R$8;"data2";$X$14:$X$15) + + + + + 11 + + + + 0 + + + + + + 0 + + + + + + 0 + + + <> + + + = + + + <>0 + + + + + 2 + + + 2 + + + PRAVDA + + AOO109200 : DSUM(Data;"Y";B12:B13) + + + AOO #109200 + + + + Criterion is reference to empty cell + + + Criterion is empty string + + + Criterion is 0 + + + Criterion is empty string + + + Criterion is literal 0 + + + + + + 2 + + + 2 + + + PRAVDA + + AOO109200 : DSUM(Data;"Y";C12:C13) + + + AOO #109200 + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + #VALUE! + + + #VALUE! + + + PRAVDA + + DSUM(J1:N10;0;J23:N24) + + + Bug #33910 + + + + 2 + + + >12 + + + + + + £120,00 + + + £120,00 + + + PRAVDA + + + Interest.B20 + + + BUG 72949 + + + + 3 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + >=I + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + + + Frank + + + + 127 + + + 20 + + + NEPRAVDA + + DSUM($Q$1:$R$8;"data2";$R$14:$R$15) + + + + The situation is completely wrecked, already Excel in itself isn't consistent in how it handles empty cell vs empty string when comparing D*() functions with how it is handled for the '=' or '<>' comparison operators. So yes, it is a bug, but even after 10 years I don't know how to correctly solve it other than mimicking te broken Excel behavior. + + + + + + + + 127 + + + 20 + + + NEPRAVDA + + DSUM($Q$1:$R$8;"data2";$T$14:$T$15) + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + 105 + + + 125 + + + NEPRAVDA + + + + + + + + + 1 + + + + 22 + + + 2 + + + NEPRAVDA + + + + + + + + + 2 + + + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 10 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 7 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 8 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + [E,I].* + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + Age + + + + + + + + >12 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + AOO 109200 + + + + + + + + + + Data + + + + + + + X + + + Y + + + Z + + + + + + + 1 + + + 1000000 + + + + + + + + 10 + + + 2 + + + 10000000 + + + + + + + 100 + + + 10000 + + + 100000000 + + + + + + + + + + X + + + + + + 10 + + + 10 + + + 10 + + + + + + + + 2 + + + 2 + + + + + + + + + + + + + + + + Values in Interest Rate ranges - come from AC Cashflow data + + + + BUG 72949 + + + + + + + + + + Rate + + + Balance + + + Yearly Interest + + + + Interest Rate + + + + + + 0,0% + + + £29,00 + + + £0,00 + + + + 0 + + + + Interest Rate + + + + + + 0,5% + + + £0,00 + + + £0,00 + + + + >0 + + + <=0,005 + + + Interest Rate + + + + + + 1,0% + + + £14,00 + + + £0,07 + + + + >,005 + + + <=0,01 + + + Interest Rate + + + + + + 1,5% + + + £10,00 + + + £0,10 + + + + >0,01 + + + <=0,015 + + + Interest Rate + + + + + + 2,0% + + + £11,00 + + + £0,17 + + + + Interest Rate + + + + + >0,015 + + + <=0,02 + + + + + + 2,5% + + + £13,00 + + + £0,26 + + + + >0,02 + + + <=0,025 + + + Interest Rate + + + + + + 3,0% + + + £0,00 + + + £0,00 + + + + >0,025 + + + <=0,03 + + + Interest Rate + + + + + + 3,5% + + + £9,00 + + + £0,27 + + + + >0,03 + + + <=0,035 + + + Interest Rate + + + + + + 4,0% + + + £6,00 + + + £0,21 + + + + >0,035 + + + <=0,04 + + + Interest Rate + + + + + + 4,5% + + + £5,00 + + + £0,20 + + + + Interest Rate + + + + >0,04 + + + <=0,045 + + + + + + 5,0% + + + £12,00 + + + £0,54 + + + + >0,045 + + + <=0,05 + + + Interest Rate + + + + + + 5,5% + + + £4,00 + + + £0,20 + + + + >0,05 + + + <=0,055 + + + Interest Rate + + + + + + 6,0% + + + £0,00 + + + £0,00 + + + + >0,055 + + + <=0,06 + + + Interest Rate + + + + + + 6,5% + + + £7,00 + + + £0,42 + + + + >0,06 + + + <=0,065 + + + Interest Rate + + + + + + 7,0% + + + £0,00 + + + £0,00 + + + + Interest Rate + + + + >0,065 + + + <=0,07 + + + + + + 100,0% + + + £0,00 + + + £0,00 + + + + >0,07 + + + <=1 + + + + + + + £120,00 + + + £2,44 + + + + + + + + + Average Interest + + + + 2,03% + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Interest Rate + + + Bal Now + + + + BUG 72949 + + + + + + + 0,00% + + + £1 + + + + + + + + 2,25% + + + £2 + + + + + + + + 1,70% + + + £3 + + + + + + + + 5,30% + + + £4 + + + + + + + + 4,01% + + + £5 + + + + + + + + + 3,62% + + + £6 + + + + + + + + + 6,50% + + + £7 + + + + + + + + + 2,00% + + + £8 + + + + + + + + + 3,10% + + + £9 + + + + + + + + 1,20% + + + £10 + + + + + + + + 2,10% + + + £11 + + + + + + + + 5,00% + + + £12 + + + + + + + + 0,00% + + + £13 + + + + + + + + 1,00% + + + £14 + + + + + + + + 0,00% + + + £15 + + + + + + + + + Total + + + 120 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + Interest Rate + + + Bal Now + + + + + 0 + + + 1 + + + + + 0.0225 + + + 2 + + + + + 0.017 + + + 3 + + + + + 0.053 + + + 4 + + + + + 0.0401 + + + 5 + + + + + 0.0362 + + + 6 + + + + + 0.065 + + + 7 + + + + + 0.02 + + + 8 + + + + + 0.031 + + + 9 + + + + + 0.012 + + + 10 + + + + + 0.021 + + + 11 + + + + + 0.05 + + + 12 + + + + + 0 + + + 13 + + + + + 0.01 + + + 14 + + + + + 0 + + + 15 + + + + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/database/fods/dvar.fods b/sc/qa/unit/data/functions/database/fods/dvar.fods new file mode 100644 index 000000000000..045e2679f0f3 --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/dvar.fods @@ -0,0 +1,1686 @@ + + + + 2016-05-25T18:29:18.162371849P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/369ca1d72bc877c6ccce991c92ae1a246956ca57 + + + 0 + 0 + 31628 + 27643 + + + view1 + + + 2 + 11 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 1 + 2 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet1 + 1241 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DVAR Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DVAR formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 0,5 + + + 0,5 + + + PRAVDA + + DVAR(J1:N10;"Age";J23:N25) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + + + 21 + + + 21 + + + PRAVDA + + DVAR(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + + 22,9166666666667 + + + 22,9166666666667 + + + PRAVDA + + DVAR(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + + 84,5 + + + 84,5 + + + PRAVDA + + DVAR(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + + + 40,5 + + + 40,5 + + + PRAVDA + + DVAR(J1:N10;"Weight";J56:N57) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + + 84,5 + + + 84,5 + + + PRAVDA + + DVAR(database;"Weight";criteria) + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + + + 0,333333333333333 + + + 0,333333333333333 + + + PRAVDA + + DVAR(J1:N11;"Age";J38:N39) + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + + + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + + + + Irene + + + 2 + + + 13 + + + 1000 + + + 42 + + + + + + + + + IAndyBetty + + + 6 + + + 15 + + + 10000 + + + 55 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 10 + + + + + + + + + + 11 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 2 + + + >12 + + + + + + + + + + 3 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + >=I + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + Frank + + + + + + + + + Eva + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 10 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 7 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 8 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + [E,I].* + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + Age + + + + + + + >12 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/database/fods/dvarp.fods b/sc/qa/unit/data/functions/database/fods/dvarp.fods new file mode 100644 index 000000000000..1c5cf14a320f --- /dev/null +++ b/sc/qa/unit/data/functions/database/fods/dvarp.fods @@ -0,0 +1,1663 @@ + + + + 2016-05-25T19:29:29.074996401P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 + + + 0 + 0 + 31628 + 27643 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 3 + 21 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet1 + 1241 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + en + US + + + + + + true + true + 3 + 1 + true + 1 + true + jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + $ + + + + + - + $ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00.00.0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + DVARP Function + + + + + + + + + Result + + + PRAVDA + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + PRAVDA + + + Simple DVARP formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + 0 + + + 0 + + + PRAVDA + + DVARP(J1:N10;"Age";J23:N24) + + + + Andy + + + 3 + + + 9 + + + 150 + + + 40 + + + + + + 14 + + + 14 + + + PRAVDA + + DVARP(J1:N10;"Weight";J13:N15) + + + + Betty + + + 4 + + + 10 + + + 1000 + + + 42 + + + + + + 17,1875 + + + 17,1875 + + + PRAVDA + + DVARP(J1:N10;"Weight";J17:N18) + + + + Clara + + + 3 + + + 10 + + + 300 + + + 51 + + + + + + 42,25 + + + 42,25 + + + PRAVDA + + DVARP(J1:N10;"Weight";J20:N21) + + + + Daniel + + + 5 + + + 11 + + + 1200 + + + 48 + + + + + + 20,25 + + + 20,25 + + + PRAVDA + + DVARP(J1:N10;"Weight";J56:N57) + + + + Eva + + + 2 + + + 8 + + + 650 + + + 33 + + + + + + 42,25 + + + 42,25 + + + PRAVDA + + DVARP(database;"Weight";criteria) + + + + Frank + + + 2 + + + 7 + + + 300 + + + 42 + + + + + + 0,222222222222222 + + + 0,222222222222222 + + + PRAVDA + + DVARP(J1:N11;"Age";J38:N39) + + + + Greta + + + 1 + + + 7 + + + 200 + + + 36 + + + + + + + + + Harry + + + 3 + + + 9 + + + 1200 + + + 44 + + + + + + + + + Irene + + + 2 + + + 13 + + + 1000 + + + 42 + + + + + + + + + IAndyBetty + + + 6 + + + 15 + + + 10000 + + + 55 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 10 + + + + + + + + + + 11 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + 2 + + + >12 + + + + + + + + + + 3 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + >=I + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + Frank + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + 4 + + + + + + + + + 5 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 1 + + + + + + + + + 2 + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 3 + + + + + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + + + 10 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 7 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 8 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 2 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + 9 + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + + + + + [E,I].* + + + + + + + + + + Name + + + Grade + + + Age + + + Distance to School + + + Weight + + + Age + + + + + + + >12 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/daverage.fods b/sc/qa/unit/data/functions/fods/daverage.fods deleted file mode 100644 index 9c37f977eea4..000000000000 --- a/sc/qa/unit/data/functions/fods/daverage.fods +++ /dev/null @@ -1,1543 +0,0 @@ - - - - 2016-05-17T13:18:24.223000000P0D1LibreOffice/5.1.1.3$Windows_x86 LibreOffice_project/89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d - - - 0 - 0 - 31628 - 27629 - - - view1 - - - 2 - 8 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - 3 - 7 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - Sheet2 - 1168 - 0 - 100 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - true - true - true - true - 12632256 - true - false - true - 3 - true - false - false - 1270 - 1270 - 1 - 1 - true - true - true - PDF-XChange 4.0 - +AX+/1BERi1YQ2hhbmdlIDQuMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUERGLVhDaGFuZ2UgNC4wAAAAAAAAAAAAAAAAAAAAAAAWAAEAGgUAAAAAAAAEAAhSAAAEdAAAM1ROVwYAUABEAEYALQBYAEMAaABhAG4AZwBlACAANAAuADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAATcADgEEwwBAAEACQCaCzQIZAABAAAALAECAAEALAEAAAAAQQA0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAAAADQIAACaCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAERDWFAEAAAAAQAAAAAAAAA0CAAAmgsAAAAAAAAsAQAAZAAAAAEAAABDAHUAcgByAGUAbgB0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQwA6AFwAcABvAHIAdABhAGIAbABlAFwAUABvAHIAdABhAGIAbABlAEEAcABwAHMAXABMAGkAYgByAGUATwBmAGYAaQBjAGUAUABvAHIAdABhAGIAbABlAFwAQQBwAHAAXABsAGkAYgByAGUAbwBmAGYAaQBjAGUAXABwAHIAbwBnAHIAYQBtAFwAcwBvAGYAZgBpAGMAZQAuAGIAaQBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIAQ09NUEFUX0RVUExFWF9NT0RFDgBEVVBMRVhfVU5LTk9XTg== - - - en - US - - - - - - 0 - false - true - true - false - false - false - 7 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - DAVERAGE Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DAVERAGE formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 39 - - - 39 - - - PRAVDA - - DAVERAGE(J1:N10;"Weight";J44:N45) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - - - 44,25 - - - 44,25 - - - PRAVDA - - DAVERAGE(J1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - - 37,5 - - - 37,5 - - - PRAVDA - - DAVERAGE(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - - 39,4 - - - 39,4 - - - PRAVDA - - DAVERAGE(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - - - 37,5 - - - 37,5 - - - PRAVDA - - DAVERAGE(J1:N10;"Weight";J56:N57) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - - 42 - - - 42 - - - PRAVDA - - - DAVERAGE(database;"Weight";criteria) - - - AOO bug #118060 - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - - - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - - - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - - - - - - Irene - - - 2 - - - 8 - - - 1000 - - - 42 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 9 - - - - - - - - - 10 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 2 - - - >7 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - >=E - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - Frank - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 10 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 7 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 8 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - [E-F].* - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - Age - - - - - - - >0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 - - - - - - - - - - \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/dcount.fods b/sc/qa/unit/data/functions/fods/dcount.fods deleted file mode 100644 index 392bc86d017d..000000000000 --- a/sc/qa/unit/data/functions/fods/dcount.fods +++ /dev/null @@ -1,2943 +0,0 @@ - - - - 2016-05-24T15:26:03.868062761P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/369ca1d72bc877c6ccce991c92ae1a246956ca57 - - - 0 - 0 - 46734 - 29633 - - - view1 - - - 1 - 13 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 90 - 60 - true - - - 2 - 8 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 90 - 60 - true - - - 22 - 9 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 90 - 60 - true - - - Sheet2 - 1241 - 0 - 90 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - 7 - false - false - true - true - false - false - false - 1270 - 1270 - true - true - true - true - true - false - 12632256 - false - Lexmark-E352dn - - - cs - CZ - - - - - - en - US - - - - - - es - ES - - - - - - true - true - 3 - 1 - true - 1 - true - jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== - false - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - - - - - ($ - - ) - - - - $ - - - - - - ($ - - ) - - - - $ - - - - - ($ - - ) - - - - $ - - - - - - ($ - - ) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ( - - ) - - - - - - - - - - - - - - - - $ - - - - - - $ - - ( - - ) - - - $ - - - - - - - - - - - - - - - - - - - - - ( - - ) - - - - - - - - - - - - - - - - - - $ - - - - - - $ - - ( - - ) - - - $ - - - - - - - - - - - - - - - - : - - - - - : - - : - - - - - : - - - - - - - - - € - - - - - - - - € - - - - £ - - - - £ - - - - -£ - - - - - £ - - - - - -£ - - - - - £ - - - - £ - - - - -£ - - - - - £ - - - - - -£ - - - - - - - - - - - - - - - - - - - - - - - - - - £ - - - - - -£ - - - - - £- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - £ - - - - - -£ - - - - - £- - - - - - - - - - - - - - - - $ - - - - - $( - - ) - - - $- - - - - - - - - - - - - - - ( - - ) - - - - - - - - - - - - - - $ - - - - - $( - - ) - - - $- - - - - - - - - - - - - - - - - ( - - ) - - - - - - - - - - - - - - - - - - - £ - - - - - % - - - - - - £ - - - - - , - - - - , - - - - £ - - - - - - - Yes - - - Yes - - - No - - - - - True - - - True - - - False - - - - - On - - - On - - - Off - - - - - € - - - - - - - ( - € - - - ) - - - - € - - - - - - - - £ - - - - - (£ - - ) - - - - - - - - % - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - : - - - - - - - : - - : - - - - - - - / - - / - - - - : - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - . - - . - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - - DCOUNT Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DCOUNT formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - data1 - - - data2 - - - AOO #65221 - - - - pet - - - name - - - AOO #84168 - - - - - 1 - - - 1 - - - PRAVDA - - DCOUNT(J1:N10;"Age";J23:N24) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - 1 - - - - dog - - - fido - - - - - - 3 - - - 3 - - - PRAVDA - - DCOUNT(J1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - 2 - - - - cat - - - meow - - - - - - 4 - - - 4 - - - PRAVDA - - DCOUNT(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - - - 4 - - - - dog - - - rower - - - - - - 2 - - - 2 - - - PRAVDA - - DCOUNT(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - 0 - - - 8 - - - - - - 3 - - - 3 - - - PRAVDA - - DCOUNT(J1:N11;"Weight";J56:N57) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - - - 16 - - - - pet - - - name - - - - - - 2 - - - 2 - - - PRAVDA - - DCOUNT(database;"Weight";criteria) - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - 0 - - - 32 - - - - dog - - - - - - 3 - - - 3 - - - PRAVDA - - DCOUNT(J1:N11;"Age";J38:N39) - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - 0 - - - 64 - - - - - - 3 - - - 3 - - - PRAVDA - - - DCOUNT(J1:N11;N(COLUMN(A1:B1))+2;J38:N39) - - - AOO #114293 - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - 2 - - - should return 0 - - - - - - 3 - - - 3 - - - PRAVDA - - DCOUNT(J1:N11;COLUMN(A1)+2;J38:N39) - - - - Irene - - - 2 - - - 13 - - - 1000 - - - 42 - - - The 0 in DCOUNT and DCOUNTA is thesame as a missing argument, and Excel for a missing argument in DCOUNTand DCOUNTA just returns the number of records that match criteria, notdistinguishing between numeric and other for DCOUNT. This is differentfrom the behavior if an actual field was specified where for DCOUNT onlynumeric content is counted. - - - - - - 3 - - - 3 - - - PRAVDA - - DCOUNT(J1:N11;K8+2;J38:N39) - - - - IAndyBetty - - - 6 - - - 15 - - - 10000 - - - 55 - - - - - - 3 - - - 3 - - - PRAVDA - - DCOUNT($Q$1:$R$8;"data2";$Q$14:$Q$15) - - - Criterion is reference to empty cell - - - - - - 3 - - - 3 - - - PRAVDA - - DCOUNT($Q$1:$R$8;"data2";$S$14:$S$15) - - - Criterion is 0 - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - criteria - - - - - - - 3 - - - 3 - - - PRAVDA - - DCOUNT($Q$1:$R$8;"data2";$U$14:$U$15) - - - Criterion is literal 0 - - - - 10 - - - - data1 - - - - - - 4 - - - 4 - - - PRAVDA - - DCOUNT($Q$1:$R$8;"data2";$X$14:$X$15) - - - - - 11 - - - - 0 - - - - - - 0 - - - - - - 0 - - - <> - - - = - - - <>0 - - - - - - 1 - - - 1 - - - PRAVDA - - AOO109200 : DCOUNT(Data;"Y";B12:B13) - - - AOO #109200 - - - - Criterion is reference to empty cell - - - Criterion is empty string - - - Criterion is 0 - - - Criterion is empty string - - - Criterion is literal 0 - - - - - - 1 - - - 1 - - - PRAVDA - - AOO109200 : DCOUNT(Data;"Y";C12:C13) - - - AOO #109200 - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 1 - - - 1 - - - PRAVDA - - DCOUNT(J1:N10;0;J23:N24) - - - For the DatabaseField parameter you can enter a cell to specify the column, or enter the number 0 for the entire database. - - - - 2 - - - >12 - - - - - - 0 - - - 0 - - - PRAVDA - - - DCOUNT(W1:X4;2;W6:X7) - - - only text - - - - 3 - - - - - - 1 - - - 1 - - - PRAVDA - - DCOUNT(J1:N10;;J23:N24) - - Tdf#70806; Yes, ODFFdoesn't allow it, but Excel in this case defaults the missing argumentto 1, which we also do for interop. - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - >=I - - - - - - - - - 1 - - - #Error - - - NEPRAVDA - - - - Tdf#70806 - - - - Email to Eike,Winfried - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - - - Frank - - - - - - - - - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - - - - - 1 - - - - - - - - - - - - - 2 - - - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 10 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 7 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 8 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - [E,I].* - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - Age - - - - - - - - >12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - AOO 109200 - - - - - - - - - - Data - - - - - - - X - - - Y - - - Z - - - - - - - 1 - - - 1000000 - - - - - - - - 10 - - - 2 - - - 10000000 - - - - - - - 100 - - - 10000 - - - 100000000 - - - - - - - - - - X - - - - - - 10 - - - 10 - - - 10 - - - - - - - - 1 - - - 1 - - - - - - - - - - - - - - 4 - - - - - - - - - Interest Rate - - - Bal Now - - - - - 0 - - - 1 - - - - - 0.0225 - - - 2 - - - - - 0.017 - - - 3 - - - - - 0.053 - - - 4 - - - - - 0.0401 - - - 5 - - - - - 0.0362 - - - 6 - - - - - 0.065 - - - 7 - - - - - 0.02 - - - 8 - - - - - 0.031 - - - 9 - - - - - 0.012 - - - 10 - - - - - 0.021 - - - 11 - - - - - 0.05 - - - 12 - - - - - 0 - - - 13 - - - - - 0.01 - - - 14 - - - - - 0 - - - 15 - - - - - - - - - - - - - - \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/dcounta.fods b/sc/qa/unit/data/functions/fods/dcounta.fods deleted file mode 100644 index 1080e2cf64a5..000000000000 --- a/sc/qa/unit/data/functions/fods/dcounta.fods +++ /dev/null @@ -1,1494 +0,0 @@ - - - - 2016-05-20T15:18:22.829709022P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/eb7593daa4bac21bd68182c8bbbd3ee3bd7b64dd - - - 0 - 0 - 31628 - 27629 - - - view1 - - - 2 - 17 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - 2 - 11 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - Sheet1 - 1241 - 0 - 100 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - 7 - false - false - true - true - false - false - false - 1270 - 1270 - true - true - true - true - true - false - 12632256 - false - Lexmark-E352dn - - - en - US - - - - - - true - true - 3 - 1 - true - 1 - true - qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= - false - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - DCOUNTA Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DCOUNTA formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 2 - - - 2 - - - PRAVDA - - DCOUNTA(J1:N10;"Weight";J44:N45) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - - - 4 - - - 4 - - - PRAVDA - - DCOUNTA(J1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - - 2 - - - 2 - - - PRAVDA - - DCOUNTA(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - - 5 - - - 5 - - - PRAVDA - - DCOUNTA(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - - - 2 - - - 2 - - - PRAVDA - - DCOUNTA(J1:N10;"Weight";J56:N57) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - - 9 - - - 9 - - - PRAVDA - - - DCOUNTA(database;"Weight";criteria) - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - - - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - - - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - - - - - - Irene - - - 2 - - - 8 - - - 1000 - - - 42 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 9 - - - - - - - - - 10 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 2 - - - >7 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - >=E - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - Frank - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 10 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 7 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 8 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - [E-F].* - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - Age - - - - - - - >0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 - - - - - - - - - - \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/dget.fods b/sc/qa/unit/data/functions/fods/dget.fods deleted file mode 100644 index 7e26ae4979b9..000000000000 --- a/sc/qa/unit/data/functions/fods/dget.fods +++ /dev/null @@ -1,1633 +0,0 @@ - - - - 2016-05-21T07:20:18.280767228P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/eb7593daa4bac21bd68182c8bbbd3ee3bd7b64dd - - - 0 - 0 - 31628 - 27643 - - - view1 - - - 2 - 8 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - 4 - 9 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - Sheet1 - 939 - 0 - 100 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - 7 - false - false - true - true - false - false - false - 1270 - 1270 - true - true - true - true - true - false - 12632256 - false - Lexmark-E352dn - - - en - US - - - - - - true - true - 3 - 1 - true - 1 - true - qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= - false - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - DGET Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DGET formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 7 - - - 7 - - - PRAVDA - - DGET(J1:N10;"Age";J23:N24) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - - - 48 - - - 48 - - - PRAVDA - - DGET(J1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - - 42 - - - 42 - - - PRAVDA - - DGET(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - - 42 - - - 42 - - - PRAVDA - - DGET(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - - - 33 - - - 33 - - - PRAVDA - - DGET(J1:N10;"Weight";J56:N57) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - - 42 - - - 42 - - - PRAVDA - - - DGET(database;"Weight";criteria) - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - - - AndyBetty - - - AndyBetty - - - PRAVDA - - DGET(J1:N11;1;J38:N39) - - - Bug #49052 - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - - - - - - TODO AOO #102750 ext references - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - - - - - - Irene - - - 2 - - - 13 - - - 1000 - - - 42 - - - - - - - - - AndyBetty - - - 6 - - - 15 - - - 10000 - - - 55 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 14 - - - - - - - - - 11 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 2 - - - >12 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - >=I - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - Frank - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 6 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 10 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 7 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 8 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - [E].* - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - Age - - - - - - - >12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 - - - - - - - - - - \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/dproduct.fods b/sc/qa/unit/data/functions/fods/dproduct.fods deleted file mode 100644 index 7a41f7175f6a..000000000000 --- a/sc/qa/unit/data/functions/fods/dproduct.fods +++ /dev/null @@ -1,1515 +0,0 @@ - - - - 2016-05-22T07:55:22.797656367P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/eb7593daa4bac21bd68182c8bbbd3ee3bd7b64dd - - - 0 - 0 - 22009 - 4261 - - - view1 - - - 2 - 17 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - 4 - 4 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - Sheet2 - 1241 - 0 - 100 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - 7 - false - false - true - true - false - false - false - 1270 - 1270 - true - true - true - true - true - false - 12632256 - false - Lexmark-E352dn - - - en - US - - - - - - true - true - 3 - 1 - true - 1 - true - qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= - false - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - DPRODUCT Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DPRODUCT formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - 1512 - - - 1512 - - - PRAVDA - - DPRODUCT(J1:N10;"Weight";J44:N45) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - - 3769920 - - - 3769920 - - - PRAVDA - - DPRODUCT(J1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - 1386 - - - 1386 - - - PRAVDA - - DPRODUCT(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - 92207808 - - - 92207808 - - - PRAVDA - - DPRODUCT(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - - 1386 - - - 1386 - - - PRAVDA - - DPRODUCT(J1:N10;"Weight";J56:N57) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - - - - - Irene - - - 2 - - - 8 - - - 1000 - - - 42 - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 9 - - - - - - - - - 10 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 2 - - - >7 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - >=E - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - Frank - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 10 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 7 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 8 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - [E-F].* - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 - - - - - - - \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/dstdev.fods b/sc/qa/unit/data/functions/fods/dstdev.fods deleted file mode 100644 index a5c04acb186b..000000000000 --- a/sc/qa/unit/data/functions/fods/dstdev.fods +++ /dev/null @@ -1,1457 +0,0 @@ - - - - 2016-05-19T20:41:43.049324634P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/eb7593daa4bac21bd68182c8bbbd3ee3bd7b64dd - - - 0 - 0 - 27162 - 25809 - - - view1 - - - 3 - 17 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - 4 - 4 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - Sheet2 - 1241 - 0 - 100 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - 7 - false - false - true - true - false - false - false - 1270 - 1270 - true - true - true - true - true - false - 12632256 - false - Lexmark-E352dn - - - en - US - - - - - - true - true - 3 - 1 - true - 1 - true - jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== - false - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - DSTDEV Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DSTDEV formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - 4,24264068711929 - - - 4,24264068711929 - - - PRAVDA - - DSTDEV(J1:N10;"Weight";J44:N45) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - - 4,78713553878169 - - - 4,78713553878169 - - - PRAVDA - - DSTDEVPJ1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - 6,36396103067893 - - - 6,36396103067893 - - - PRAVDA - - DSTDEV(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - 4,6690470119715 - - - 4,6690470119715 - - - PRAVDA - - DSTDEV(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - - 6,36396103067893 - - - 6,36396103067893 - - - PRAVDA - - - DSTDEV(J1:N10;"Weight";J56:N57) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - - - - - Irene - - - 2 - - - 8 - - - 1000 - - - 42 - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 9 - - - - - - - - - 10 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 2 - - - >7 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - >=E - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - Frank - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 10 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 7 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 8 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - [E-F].* - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 - - - - - - - \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/dstdevp.fods b/sc/qa/unit/data/functions/fods/dstdevp.fods deleted file mode 100644 index bfc321a5c3d8..000000000000 --- a/sc/qa/unit/data/functions/fods/dstdevp.fods +++ /dev/null @@ -1,1357 +0,0 @@ - - - - 2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/369ca1d72bc877c6ccce991c92ae1a246956ca57 - - - 0 - 0 - 22009 - 4261 - - - view1 - - - 3 - 16 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - 9 - 5 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - Sheet1 - 1241 - 0 - 100 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - 7 - false - false - true - true - false - false - false - 1270 - 1270 - true - true - true - true - true - false - 12632256 - false - Lexmark-E352dn - - - en - US - - - - - - true - true - 3 - 1 - true - 1 - true - qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= - false - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - DSTDEVP Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DSTDEVP formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - 3 - - - 3 - - - PRAVDA - - DSTDEVP(J1:N10;"Weight";J44:N45) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - - 4,14578098794425 - - - 4,14578098794425 - - - PRAVDA - - DSTDEVP(J1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - 4,5 - - - 4,5 - - - PRAVDA - - DSTDEVP(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - 4,17612260356422 - - - 4,17612260356422 - - - PRAVDA - - DSTDEVP(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - - 0 - - - 0 - - - PRAVDA - - DSTDEVP(J1:N10;"Weight";J23:N24) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - 4,5 - - - 4,5 - - - PRAVDA - - - DSTDEVP(J1:N10;"Weight";J56:N57) - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - - - - - Irene - - - 2 - - - 8 - - - 1000 - - - 42 - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 9 - - - - - - - - - 10 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 2 - - - >7 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - >=E - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - Frank - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 10 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 7 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 8 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - [E-F].* - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 - - - - - - - \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/dsum.fods b/sc/qa/unit/data/functions/fods/dsum.fods deleted file mode 100644 index 2e4f9404da65..000000000000 --- a/sc/qa/unit/data/functions/fods/dsum.fods +++ /dev/null @@ -1,3629 +0,0 @@ - - - - 2016-05-24T18:20:55.605253990P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/369ca1d72bc877c6ccce991c92ae1a246956ca57 - - - 0 - 0 - 44476 - 29296 - - - view1 - - - 2 - 26 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 90 - 60 - true - - - 2 - 14 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 90 - 60 - true - - - 4 - 20 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 90 - 60 - true - - - 2 - 8 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 90 - 60 - true - - - 3 - 19 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 90 - 60 - true - - - Sheet1 - 1241 - 0 - 90 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - 7 - false - false - true - true - false - false - false - 1270 - 1270 - true - true - true - true - true - false - 12632256 - false - Lexmark-E352dn - - - cs - CZ - - - - - - en - US - - - - - - es - ES - - - - - - true - true - 3 - 1 - true - 1 - true - jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== - false - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $ - - - - - ($ - - ) - - - - $ - - - - - - ($ - - ) - - - - $ - - - - - ($ - - ) - - - - $ - - - - - - ($ - - ) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ( - - ) - - - - - - - - - - - - - - - - $ - - - - - - $ - - ( - - ) - - - $ - - - - - - - - - - - - - - - - - - - - - ( - - ) - - - - - - - - - - - - - - - - - - $ - - - - - - $ - - ( - - ) - - - $ - - - - - - - - - - - - - - - - : - - - - - : - - : - - - - - : - - - - - - - - - € - - - - - - - - € - - - - £ - - - - £ - - - - -£ - - - - - £ - - - - - -£ - - - - - £ - - - - £ - - - - -£ - - - - - £ - - - - - -£ - - - - - - - - - - - - - - - - - - - - - - - - - - £ - - - - - -£ - - - - - £- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - £ - - - - - -£ - - - - - £- - - - - - - - - - - - - - - - $ - - - - - $( - - ) - - - $- - - - - - - - - - - - - - - ( - - ) - - - - - - - - - - - - - - $ - - - - - $( - - ) - - - $- - - - - - - - - - - - - - - - - ( - - ) - - - - - - - - - - - - - - - - - - - £ - - - - - % - - - - - - £ - - - - - , - - - - , - - - - £ - - - - - - - Yes - - - Yes - - - No - - - - - True - - - True - - - False - - - - - On - - - On - - - Off - - - - - € - - - - - - - ( - € - - - ) - - - - € - - - - - - - - £ - - - - - (£ - - ) - - - - - - - - % - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - : - - - - - - - : - - : - - - - - - - / - - / - - - - : - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - % - - - - . - - . - - - - - . - - . - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - - DSUM Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DSUM formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - data1 - - - data2 - - - AOO #65221 - - - - - - 7 - - - 7 - - - PRAVDA - - DSUM(J1:N10;"Age";J23:N24) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - 1 - - - - - - 141 - - - 141 - - - PRAVDA - - DSUM(J1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - 2 - - - - - - 177 - - - 177 - - - PRAVDA - - DSUM(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - - - 4 - - - - - - 97 - - - 97 - - - PRAVDA - - DSUM(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - 0 - - - 8 - - - - - - 75 - - - 75 - - - PRAVDA - - DSUM(J1:N10;"Weight";J56:N57) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - - - 16 - - - - - - 97 - - - 97 - - - PRAVDA - - DSUM(database;"Weight";criteria) - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - 0 - - - 32 - - - - - - 28 - - - 28 - - - PRAVDA - - DSUM(J1:N11;"Age";J38:N39) - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - 0 - - - 64 - - - - - - 28 - - - 28 - - - PRAVDA - - - DSUM(J1:N11;N(COLUMN(A1:B1))+2;J38:N39) - - - AOO #114293 - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - - - 28 - - - 28 - - - PRAVDA - - DSUM(J1:N11;COLUMN(A1)+2;J38:N39) - - - - Irene - - - 2 - - - 13 - - - 1000 - - - 42 - - - - - - 28 - - - 28 - - - PRAVDA - - DSUM(J1:N11;K8+2;J38:N39) - - - - IAndyBetty - - - 6 - - - 15 - - - 10000 - - - 55 - - - - - - 104 - - - 104 - - - PRAVDA - - DSUM($Q$1:$R$8;"data2";$Q$14:$Q$15) - - - Criterion is reference to empty cell - - - - - - 104 - - - 104 - - - PRAVDA - - DSUM($Q$1:$R$8;"data2";$S$14:$S$15) - - - Criterion is 0 - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - criteria - - - - - - - 104 - - - 104 - - - PRAVDA - - DSUM($Q$1:$R$8;"data2";$U$14:$U$15) - - - Criterion is literal 0 - - - - 10 - - - - data1 - - - - - 23 - - - 23 - - - PRAVDA - - DSUM($Q$1:$R$8;"data2";$X$14:$X$15) - - - - - 11 - - - - 0 - - - - - - 0 - - - - - - 0 - - - <> - - - = - - - <>0 - - - - - 2 - - - 2 - - - PRAVDA - - AOO109200 : DSUM(Data;"Y";B12:B13) - - - AOO #109200 - - - - Criterion is reference to empty cell - - - Criterion is empty string - - - Criterion is 0 - - - Criterion is empty string - - - Criterion is literal 0 - - - - - - 2 - - - 2 - - - PRAVDA - - AOO109200 : DSUM(Data;"Y";C12:C13) - - - AOO #109200 - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - #VALUE! - - - #VALUE! - - - PRAVDA - - DSUM(J1:N10;0;J23:N24) - - - Bug #33910 - - - - 2 - - - >12 - - - - - - £120,00 - - - £120,00 - - - PRAVDA - - - Interest.B20 - - - BUG 72949 - - - - 3 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - >=I - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - - - Frank - - - - 127 - - - 20 - - - NEPRAVDA - - DSUM($Q$1:$R$8;"data2";$R$14:$R$15) - - - - The situation is completely wrecked, already Excel in itself isn't consistent in how it handles empty cell vs empty string when comparing D*() functions with how it is handled for the '=' or '<>' comparison operators. So yes, it is a bug, but even after 10 years I don't know how to correctly solve it other than mimicking te broken Excel behavior. - - - - - - - - 127 - - - 20 - - - NEPRAVDA - - DSUM($Q$1:$R$8;"data2";$T$14:$T$15) - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - 105 - - - 125 - - - NEPRAVDA - - - - - - - - - 1 - - - - 22 - - - 2 - - - NEPRAVDA - - - - - - - - - 2 - - - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 10 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 7 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 8 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - [E,I].* - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - Age - - - - - - - - >12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - AOO 109200 - - - - - - - - - - Data - - - - - - - X - - - Y - - - Z - - - - - - - 1 - - - 1000000 - - - - - - - - 10 - - - 2 - - - 10000000 - - - - - - - 100 - - - 10000 - - - 100000000 - - - - - - - - - - X - - - - - - 10 - - - 10 - - - 10 - - - - - - - - 2 - - - 2 - - - - - - - - - - - - - - - - Values in Interest Rate ranges - come from AC Cashflow data - - - - BUG 72949 - - - - - - - - - - Rate - - - Balance - - - Yearly Interest - - - - Interest Rate - - - - - - 0,0% - - - £29,00 - - - £0,00 - - - - 0 - - - - Interest Rate - - - - - - 0,5% - - - £0,00 - - - £0,00 - - - - >0 - - - <=0,005 - - - Interest Rate - - - - - - 1,0% - - - £14,00 - - - £0,07 - - - - >,005 - - - <=0,01 - - - Interest Rate - - - - - - 1,5% - - - £10,00 - - - £0,10 - - - - >0,01 - - - <=0,015 - - - Interest Rate - - - - - - 2,0% - - - £11,00 - - - £0,17 - - - - Interest Rate - - - - - >0,015 - - - <=0,02 - - - - - - 2,5% - - - £13,00 - - - £0,26 - - - - >0,02 - - - <=0,025 - - - Interest Rate - - - - - - 3,0% - - - £0,00 - - - £0,00 - - - - >0,025 - - - <=0,03 - - - Interest Rate - - - - - - 3,5% - - - £9,00 - - - £0,27 - - - - >0,03 - - - <=0,035 - - - Interest Rate - - - - - - 4,0% - - - £6,00 - - - £0,21 - - - - >0,035 - - - <=0,04 - - - Interest Rate - - - - - - 4,5% - - - £5,00 - - - £0,20 - - - - Interest Rate - - - - >0,04 - - - <=0,045 - - - - - - 5,0% - - - £12,00 - - - £0,54 - - - - >0,045 - - - <=0,05 - - - Interest Rate - - - - - - 5,5% - - - £4,00 - - - £0,20 - - - - >0,05 - - - <=0,055 - - - Interest Rate - - - - - - 6,0% - - - £0,00 - - - £0,00 - - - - >0,055 - - - <=0,06 - - - Interest Rate - - - - - - 6,5% - - - £7,00 - - - £0,42 - - - - >0,06 - - - <=0,065 - - - Interest Rate - - - - - - 7,0% - - - £0,00 - - - £0,00 - - - - Interest Rate - - - - >0,065 - - - <=0,07 - - - - - - 100,0% - - - £0,00 - - - £0,00 - - - - >0,07 - - - <=1 - - - - - - - £120,00 - - - £2,44 - - - - - - - - - Average Interest - - - - 2,03% - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Interest Rate - - - Bal Now - - - - BUG 72949 - - - - - - - 0,00% - - - £1 - - - - - - - - 2,25% - - - £2 - - - - - - - - 1,70% - - - £3 - - - - - - - - 5,30% - - - £4 - - - - - - - - 4,01% - - - £5 - - - - - - - - - 3,62% - - - £6 - - - - - - - - - 6,50% - - - £7 - - - - - - - - - 2,00% - - - £8 - - - - - - - - - 3,10% - - - £9 - - - - - - - - 1,20% - - - £10 - - - - - - - - 2,10% - - - £11 - - - - - - - - 5,00% - - - £12 - - - - - - - - 0,00% - - - £13 - - - - - - - - 1,00% - - - £14 - - - - - - - - 0,00% - - - £15 - - - - - - - - - Total - - - 120 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 - - - - - - - - - Interest Rate - - - Bal Now - - - - - 0 - - - 1 - - - - - 0.0225 - - - 2 - - - - - 0.017 - - - 3 - - - - - 0.053 - - - 4 - - - - - 0.0401 - - - 5 - - - - - 0.0362 - - - 6 - - - - - 0.065 - - - 7 - - - - - 0.02 - - - 8 - - - - - 0.031 - - - 9 - - - - - 0.012 - - - 10 - - - - - 0.021 - - - 11 - - - - - 0.05 - - - 12 - - - - - 0 - - - 13 - - - - - 0.01 - - - 14 - - - - - 0 - - - 15 - - - - - - - - - - - - - - \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/dvar.fods b/sc/qa/unit/data/functions/fods/dvar.fods deleted file mode 100644 index 045e2679f0f3..000000000000 --- a/sc/qa/unit/data/functions/fods/dvar.fods +++ /dev/null @@ -1,1686 +0,0 @@ - - - - 2016-05-25T18:29:18.162371849P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/369ca1d72bc877c6ccce991c92ae1a246956ca57 - - - 0 - 0 - 31628 - 27643 - - - view1 - - - 2 - 11 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - 1 - 2 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - Sheet1 - 1241 - 0 - 100 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - 7 - false - false - true - true - false - false - false - 1270 - 1270 - true - true - true - true - true - false - 12632256 - false - Lexmark-E352dn - - - en - US - - - - - - true - true - 3 - 1 - true - 1 - true - jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== - false - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - - DVAR Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DVAR formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 0,5 - - - 0,5 - - - PRAVDA - - DVAR(J1:N10;"Age";J23:N25) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - - - 21 - - - 21 - - - PRAVDA - - DVAR(J1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - - 22,9166666666667 - - - 22,9166666666667 - - - PRAVDA - - DVAR(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - - 84,5 - - - 84,5 - - - PRAVDA - - DVAR(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - - - 40,5 - - - 40,5 - - - PRAVDA - - DVAR(J1:N10;"Weight";J56:N57) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - - 84,5 - - - 84,5 - - - PRAVDA - - DVAR(database;"Weight";criteria) - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - - - 0,333333333333333 - - - 0,333333333333333 - - - PRAVDA - - DVAR(J1:N11;"Age";J38:N39) - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - - - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - - - - - - Irene - - - 2 - - - 13 - - - 1000 - - - 42 - - - - - - - - - IAndyBetty - - - 6 - - - 15 - - - 10000 - - - 55 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 10 - - - - - - - - - - 11 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 2 - - - >12 - - - - - - - - - - 3 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - >=I - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - Frank - - - - - - - - - Eva - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 10 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 7 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 8 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - [E,I].* - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - Age - - - - - - - >12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 - - - - - - - - - - \ No newline at end of file diff --git a/sc/qa/unit/data/functions/fods/dvarp.fods b/sc/qa/unit/data/functions/fods/dvarp.fods deleted file mode 100644 index 1c5cf14a320f..000000000000 --- a/sc/qa/unit/data/functions/fods/dvarp.fods +++ /dev/null @@ -1,1663 +0,0 @@ - - - - 2016-05-25T19:29:29.074996401P0D1LibreOfficeDev/5.2.0.0.alpha1$Linux_X86_64 LibreOffice_project/fa9416906e615f5f19ad8524176d2ed693662769 - - - 0 - 0 - 31628 - 27643 - - - view1 - - - 2 - 8 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - 3 - 21 - 0 - 0 - 0 - 0 - 2 - 0 - 0 - 0 - 0 - 0 - 100 - 60 - true - - - Sheet1 - 1241 - 0 - 100 - 60 - false - true - true - true - 12632256 - true - true - true - true - false - false - false - 1270 - 1270 - 1 - 1 - true - - - - - 7 - false - false - true - true - false - false - false - 1270 - 1270 - true - true - true - true - true - false - 12632256 - false - Lexmark-E352dn - - - en - US - - - - - - true - true - 3 - 1 - true - 1 - true - jQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAswAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg== - false - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Kč - - - - - - - - Kč - - - - £ - - - - - - £ - - - - - £ - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - £ - - - - - - - £ - - - - - - - - - ( - - ) - - - - - - - - ( - - ) - - - - £ - - - - - - - £ - - - - - - £ - - - - - - - £ - - - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - - - Kč - - - - - - - - Kč - - - - $ - - - - - - - $ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ??? - - - - Page 1 - - - - - - - ??? (???) - - - 00.00.0000, 00:00:00 - - - - - Page 1 / 99 - - - - - - - - - - - - - - - DVARP Function - - - - - - - - - Result - - - PRAVDA - - - - - - - - - Sheet - - - Result - - - Description - - - - - 1 - - - PRAVDA - - - Simple DVARP formulas with local references and values - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Function - - - Expected - - - Correct - - - FunctionString - - - Comment - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - 0 - - - 0 - - - PRAVDA - - DVARP(J1:N10;"Age";J23:N24) - - - - Andy - - - 3 - - - 9 - - - 150 - - - 40 - - - - - - 14 - - - 14 - - - PRAVDA - - DVARP(J1:N10;"Weight";J13:N15) - - - - Betty - - - 4 - - - 10 - - - 1000 - - - 42 - - - - - - 17,1875 - - - 17,1875 - - - PRAVDA - - DVARP(J1:N10;"Weight";J17:N18) - - - - Clara - - - 3 - - - 10 - - - 300 - - - 51 - - - - - - 42,25 - - - 42,25 - - - PRAVDA - - DVARP(J1:N10;"Weight";J20:N21) - - - - Daniel - - - 5 - - - 11 - - - 1200 - - - 48 - - - - - - 20,25 - - - 20,25 - - - PRAVDA - - DVARP(J1:N10;"Weight";J56:N57) - - - - Eva - - - 2 - - - 8 - - - 650 - - - 33 - - - - - - 42,25 - - - 42,25 - - - PRAVDA - - DVARP(database;"Weight";criteria) - - - - Frank - - - 2 - - - 7 - - - 300 - - - 42 - - - - - - 0,222222222222222 - - - 0,222222222222222 - - - PRAVDA - - DVARP(J1:N11;"Age";J38:N39) - - - - Greta - - - 1 - - - 7 - - - 200 - - - 36 - - - - - - - - - Harry - - - 3 - - - 9 - - - 1200 - - - 44 - - - - - - - - - Irene - - - 2 - - - 13 - - - 1000 - - - 42 - - - - - - - - - IAndyBetty - - - 6 - - - 15 - - - 10000 - - - 55 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 10 - - - - - - - - - - 11 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - 2 - - - >12 - - - - - - - - - - 3 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - >=I - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - Frank - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - 4 - - - - - - - - - 5 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 1 - - - - - - - - - 2 - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 3 - - - - - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - - - 10 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 7 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 8 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 2 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - 9 - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - - - - - [E,I].* - - - - - - - - - - Name - - - Grade - - - Age - - - Distance to School - - - Weight - - - Age - - - - - - - >12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4 - - - - - - - - - - \ No newline at end of file -- cgit