2016-06-25T07:16:38.437590147P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/7b660e1423554928350e1de2cd4cb7eb577a27ec 0 0 41364 11740 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 3 23 0 0 0 0 2 0 0 0 6 0 100 60 true false Sheet2 1241 0 100 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 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 rgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== false 0 Kč - Kč $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč € - € € - € € - € € - € - - € - € - € - - € - € - € : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - € - € . / € - € ⌀ $ - $ ( ) - $ $( ) $- ( ) - $ € - € ￥ - ￥ / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - / / / / : ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 IF Function Result TRUE Sheet Result Description 1 TRUE Simple IF formulas with local references and values Function Expected Correct FunctionString Comment TRUE TRUE 1 TRUE =IF(TRUE()) FALSE FALSE 0 TRUE =IF(FALSE()) 1 Bug 76294 4 No 4 4 TRUE =IF(EXACT(N3,"No"),M3,0) Bug 76294 #DIV/0! Bug 72691 1 1 1 TRUE {=IF(ISBLANK(M4),"",M4)} Bug 72691 Passed Passed TRUE =IF(F6>0,"Failed","foobar") Tdf#72969 foobar 1 1 TRUE =IF(J1,1,2) Tdf#88576 FALSE 0 TRUE =IF(J2,1) 2 2 TRUE =IF(J2,,2) 0 0 TRUE =IF(J1,,2) TRUE 1 TRUE =IF(J1,TRUE()) FALSE 0 TRUE =IF(J2,TRUE()) x x TRUE =IF(F13=1,TODAY(),"x") 2 x x TRUE =IF(F14=1,NOW(),"x") 2 x x TRUE =IF(F15=1,HOUR(1),"x") 2 x x TRUE =IF(F16=1,HOUR(NOW()),"x") 2 -1 -1 TRUE =IF("FOO"="FOO",-F17,F17) AOO#58902 1 -1 -1 TRUE =IF(2=1, 1, -1) AOO#52584 4 4 TRUE =IF(I19="F",H19,-H19) AOO#54771 4 Y 4 F 0 0 TRUE =IF(I20="F",H20,-H20) AOO#54771 5 N 0 F 1 1 TRUE =I26 AOO#90060 1 11 11 11 TRUE =J26 2 12 3 13 4 14 5 15 1 11 4 O5