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