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