2016-09-07T04:51:27.950112016P0D1LibreOffice/5.1.4.2$Linux_X86_64 LibreOffice_project/10m0$Build-2 0 0 24248 9872 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true 2 7 0 0 0 0 2 0 0 0 0 0 75 60 true Sheet2 1185 0 75 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 true true false 12632256 false Lexmark-E352dn cs CZ en US nl NL 3 1 true 1 true rQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA0wAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgBJbnB1dFNsb3Q6VHJheTEARHVwbGV4Ok5vbmUAABIAQ09NUEFUX0RVUExFWF9NT0RFCgBEVVBMRVhfT0ZG false 0 - ( ) - - - - - £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ - - / / / / - - - - - - - - - - - - - Kč - - - - : : : : Yes Yes No True True False On On Off ¥€ ( ) - $ ($ ) - - - - - - - - € - - - - $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - ( ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - % % % % % % % % % % - - - - - - - - - - - - - - - % % % % % % $ ( $ ) % % - % - - - £ - £ £ - £ % - % DM - DM DM - DM DM - DM DM - DM - - DM - DM - DM - - DM - DM - DM Ouch! - - Error detected! - Result=0 - No Errordetection / / / / - . . - - - - € - - - - $ $ - $ . . . . : : : . . : - - - - $ $ -$ $ -$ $ $ -$ $ -$ -$ $ -$ $- - - - -$ $ -$ $- - - - / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % . . : : : . . : - - - - - - - - % % / / / / $ - $ ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 ROWS Function Result TRUE Sheet Result Description 1 TRUE Simple ROWS formulas with local references and values Function Expected Correct FunctionString Comment 5 5 TRUE =ROW(B5) 10 10 TRUE =ROW(A10:B12) 1 1 TRUE =ROW(range1) Chyba:504 Chyba:504 TRUE =ROW({1,2,3;4,5,6}) 5 5 TRUE {=ROW(D5:D8)} 6 6 TRUE {=ROW(D5:D8)} 7 7 TRUE {=ROW(D5:D8)} 8 8 TRUE {=ROW(D5:D8)} 1 1 TRUE =ROW(A1:E1) 1 1 TRUE {=ROW(A1:E1)} 12 12 TRUE =ROW() $C$2 $C$2 TRUE =ADDRESS(ROW(C2:C10),3) 14 14 TRUE =CELL("ROW") 15 15 TRUE {=ROW()} 16 16 TRUE {=ROW()} 17 17 TRUE {=ROW()} 3 3 TRUE =ROW('file:///fake_path/filename'#$Sheet1.B3) 3 3 TRUE {=ROW('file:///fake_path/filename'#$Sheet1.B3:D8)} 4 4 TRUE {=ROW('file:///fake_path/filename'#$Sheet1.B3:D8)} 5 5 TRUE {=ROW('file:///fake_path/filename'#$Sheet1.B3:D8)} 6 6 TRUE {=ROW('file:///fake_path/filename'#$Sheet1.B3:D8)} 7 7 TRUE {=ROW('file:///fake_path/filename'#$Sheet1.B3:D8)} 8 8 TRUE {=ROW('file:///fake_path/filename'#$Sheet1.B3:D8)} 4