2016-06-25T07:16:38.437590147P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/54f2a4184d1296814e64cfeab1d06ae90d002357 0 0 30908 13546 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 1 26 0 0 0 0 2 0 0 0 0 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 qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 Kč - Kč $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč € - € € - € € - € € - € - - € - € - € - - € - € - € : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - € - € . / € - € ⌀ $ - $ ( ) - $ $( ) $- ( ) - $ € - € . . WAHR WAHR FALSCH € € - / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - : : : - ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 FLOOR.XCL Function Result TRUE Sheet Result Description 1 TRUE Simple FLOOR.XCL formulas with local references and values Function Expected Correct FunctionString Comment -10 -10 TRUE =FLOOR.XCL(-11,-2) 2 2 TRUE =FLOOR.XCL(2.5, 1) 25 -2 -2 TRUE =FLOOR.XCL(-2.5, -2) -4 -4 TRUE =FLOOR.XCL(-2.5, 2) 1.5 1.5 TRUE =FLOOR.XCL(1.5, 0.1) 0.23 0.23 TRUE =FLOOR.XCL(0.234, 0.01) Err:511 error TRUE =FLOOR.XCL(J$10) 23 23 TRUE =FLOOR.XCL(J$10,$L10) Err:502 error TRUE =FLOOR.XCL(J$10,$L11) 23.5 -23.5 1 Err:504 error TRUE =FLOOR.XCL(J$10,$L10,0) 0 Err:504 error TRUE =FLOOR.XCL(J$10,$L11,0) -1 Err:504 error TRUE =FLOOR.XCL(J$10,$L10,1) Err:504 error TRUE =FLOOR.XCL(J$10,$L11,1) Err:511 error TRUE =FLOOR.XCL(K$10) Err:502 error TRUE =FLOOR.XCL(K$10,$L11) -23 -23 TRUE =FLOOR.XCL(K$10,$L12) -24 -24 TRUE =FLOOR.XCL(K$10,$L10) Err:502 error TRUE =FLOOR.XCL(J$10,$L12) 20 20 TRUE =FLOOR.XCL(24.3,5) Err:511 error TRUE =FLOOR.XCL(6.7) -10 -10 TRUE =FLOOR.XCL(-8.1,2) Err:511 error TRUE =FLOOR.XCL(4.3) Err:511 error TRUE =FLOOR.XCL(-4.3) 4 4 TRUE =FLOOR.XCL(4.3,2) Err:502 error TRUE =FLOOR.XCL(4.3,-2) -6 -6 TRUE =FLOOR.XCL(-4.3,2) -4 -4 TRUE =FLOOR.XCL(-4.3,-2) not in help Additional FLOOR.XCL and CEILING.XCL functions were introduced that expect only two parameters and both parameters have to be specified. When importing Microsoft Excel documents, their old FLOOR and CEILING functions are imported as FLOOR.XCL and CEILING.XCL 4 O5