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