From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- sc/qa/unit/data/functions/database/fods/dsum.fods | 3629 +++++++++++++++++++++ 1 file changed, 3629 insertions(+) create mode 100644 sc/qa/unit/data/functions/database/fods/dsum.fods (limited to 'sc/qa/unit/data/functions/database/fods/dsum.fods') 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 000000000..2e4f9404d --- /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 -- cgit v1.2.3