2016-06-15T18:43:41.791000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/131e604073f89e6c1dd54be88b94b7befd881f2e 0 0 27714 9172 view1 1 32 0 0 0 0 2 0 0 0 0 0 100 60 true 2 9 0 0 0 0 2 0 0 0 0 0 100 60 true Sheet2 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 cs CZ 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 WEEKDAY Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple WEEKDAY formulas with local references and values Function Expected Correct FunctionString Comment 1 4 4 PRAVDA =WEEKDAY("2000-06-14") 2 3 3 PRAVDA =WEEKDAY("1996-07-24";2) 1 1 PRAVDA =WEEKDAY("2016-07-24";1) 7 7 PRAVDA =WEEKDAY("2016-07-24";2) 6 6 PRAVDA =WEEKDAY("2016-07-24";3) 6 6 PRAVDA =WEEKDAY(K9;3) Err:502 ERR PRAVDA =WEEKDAY(K9;0) Tdf#100396 Err:502 err PRAVDA =WEEKDAY(K9;) 24.07.16 10:19 1 1 PRAVDA =WEEKDAY(datum;1) Err:502 Err PRAVDA =WEEKDAY(datum;999999) Tdf#100396 Err:502 Err PRAVDA =WEEKDAY(K9;999999) Tdf#100396 #VALUE! Err PRAVDA =WEEKDAY(K10;K1:K2) TODO https://bugs.documentfoundation.org/show_bug.cgi?id=100396#c1 Also, Excel2010 added additional type parameters, see https://support.office.com/en-US/article/WEEKDAY-function-60E44483-2ED1-439F-8BD0-E404C190949Ahttps://lists.oasis-open.org/archives/office-comment/201606/msg00000.html 7 7 PRAVDA =WEEKDAY("2016-07-24";11) 6 6 PRAVDA =WEEKDAY("2016-07-24";12) 5 5 PRAVDA =WEEKDAY("2016-07-24";13) RETEST na dev verzi 18.6. 4 4 PRAVDA =WEEKDAY("2016-07-24";14) 3 3 PRAVDA =WEEKDAY("2016-07-24";15) 2 2 PRAVDA =WEEKDAY("2016-07-24";16) 1 1 PRAVDA =WEEKDAY("2016-07-24";17) 4