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