2016-05-17T13:18:24.223000000P0D1LibreOffice/5.1.1.3$Windows_x86 LibreOffice_project/89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d 0 0 31628 27629 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true 3 7 0 0 0 0 2 0 0 0 0 0 100 60 true Sheet2 1168 0 100 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true true true true true 12632256 true false true 3 true false false 1270 1270 1 1 true true true PDF-XChange 4.0 +AX+/1BERi1YQ2hhbmdlIDQuMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUERGLVhDaGFuZ2UgNC4wAAAAAAAAAAAAAAAAAAAAAAAWAAEAGgUAAAAAAAAEAAhSAAAEdAAAM1ROVwYAUABEAEYALQBYAEMAaABhAG4AZwBlACAANAAuADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAATcADgEEwwBAAEACQCaCzQIZAABAAAALAECAAEALAEAAAAAQQA0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAAAADQIAACaCwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAERDWFAEAAAAAQAAAAAAAAA0CAAAmgsAAAAAAAAsAQAAZAAAAAEAAABDAHUAcgByAGUAbgB0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQwA6AFwAcABvAHIAdABhAGIAbABlAFwAUABvAHIAdABhAGIAbABlAEEAcABwAHMAXABMAGkAYgByAGUATwBmAGYAaQBjAGUAUABvAHIAdABhAGIAbABlAFwAQQBwAHAAXABsAGkAYgByAGUAbwBmAGYAaQBjAGUAXABwAHIAbwBnAHIAYQBtAFwAcwBvAGYAZgBpAGMAZQAuAGIAaQBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIAQ09NUEFUX0RVUExFWF9NT0RFDgBEVVBMRVhfVU5LTk9XTg== en US 0 false true true false false false 7 Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč $ - $ ??? Page 1 ??? (???) 00.00.0000, 00:00:00 Page 1 / 99 DAVERAGE Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple DAVERAGE formulas with local references and values Function Expected Correct FunctionString Comment Name Grade Age Distance to School Weight 39 39 PRAVDA DAVERAGE(J1:N10;"Weight";J44:N45) Andy 3 9 150 40 44,25 44,25 PRAVDA DAVERAGE(J1:N10;"Weight";J13:N15) Betty 4 10 1000 42 37,5 37,5 PRAVDA DAVERAGE(J1:N10;"Weight";J17:N18) Clara 3 10 300 51 39,4 39,4 PRAVDA DAVERAGE(J1:N10;"Weight";J20:N21) Daniel 5 11 1200 48 37,5 37,5 PRAVDA DAVERAGE(J1:N10;"Weight";J56:N57) Eva 2 8 650 33 42 42 PRAVDA DAVERAGE(database;"Weight";criteria) AOO bug #118060 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].* Name Grade Age Distance to School Weight Age >0 4