2016-09-07T04:51:27.950112016P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/a8a7b7114d96b2013b00e9bc0ced81aad5495457 0 0 57929 83135 view1 2 8 0 0 0 0 2 0 0 0 0 0 60 60 true false 2 111 0 0 0 0 2 0 0 0 109 0 60 60 true false Sheet2 1241 0 60 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 cs CZ en US nl NL true true 3 1 true 1 true rQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA0wAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpMZXR0ZXIAABIAQ09NUEFUX0RVUExFWF9NT0RFCgBEVVBMRVhfT0ZG false 0 Kč - Kč ( ) - Kč - Kč Kč - Kč Kč - Kč Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - 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 / / / / € - € . . € - € € - € € - € € - € - - € - € - € - - € - € - € DM - DM DM - DM DM - DM DM - DM DM - DM - DM - - DM - DM - DM - - $ $ - $ . . . . : : : . . : - - - - $ $ -$ $ -$ $ $ -$ $ -$ -$ $ -$ $- - - - -$ $ -$ $- - - - / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) ( ) ( ) ( ) ( ) ( ) . . : : : . . : - - - - € - € € - € € - € € - € % % / / / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 MATCH Function Result TRUE Sheet Result Description 1 TRUE Simple MATCH formulas with local references and values Function Expected Correct FunctionString Comment A a 1 1 TRUE =MATCH("a",range1) #N/A #N/A TRUE =MATCH(F8,F5:M5,1) 1 1 TRUE =MATCH(F9,F5:M5,1) 1 1 TRUE =MATCH(F10,F5:M5,1) 2 4 8 B D H 3 3 TRUE =MATCH(F11,F5:M5,1) 3 3 TRUE =MATCH(F12,F5:M5,1) Lookup 3 3 TRUE =MATCH(F13,F5:M5,1) 1 3 3 TRUE =MATCH(F14,F5:M5,1) 2 4 4 TRUE =MATCH(F15,F5:M5,1) 3 4 4 TRUE =MATCH(F16,F5:M5,1) 4 #N/A #N/A TRUE =MATCH(F17,F5:M5,1) 5 6 6 TRUE =MATCH(F18,F5:M5,1) 6 6 6 TRUE =MATCH(F19,F5:M5,1) 7 7 7 TRUE =MATCH(F20,F5:M5,1) 8 7 7 TRUE =MATCH(F21,F5:M5,1) 9 7 7 TRUE =MATCH(F22,F5:M5,1) A 7 7 TRUE =MATCH(F23,F5:M5,1) B 8 8 TRUE =MATCH(F24,F5:M5,1) C 8 8 TRUE =MATCH(F25,F5:M5,1) D 1 1 TRUE =MATCH(F29,F29:F37,0) E 2 2 TRUE =MATCH(F30,F29:F37,0) F 3 3 TRUE =MATCH(F31,F29:F37,0) G 4 4 TRUE =MATCH(F32,F29:F37,0) H 5 5 TRUE =MATCH(F33,F29:F37,0) I 6 6 TRUE =MATCH(F34,F29:F37,0) 7 7 TRUE =MATCH(F35,F29:F37,0) 1 1 TRUE =MATCH(F36,F29:F37,0) Data MATCH MATCH_ARRAY Data MATCH MATCH_ARRAY 2 2 TRUE =MATCH(F37,F29:F37,0) lundi 1 1 1 TRUE {=MATCH(F29:F37,F29:F37,0)} mardi 2 2 2 TRUE {=MATCH(F29:F37,F29:F37,0)} mercredi 3 3 3 TRUE {=MATCH(F29:F37,F29:F37,0)} jeudi 4 4 4 TRUE {=MATCH(F29:F37,F29:F37,0)} vendredi 5 5 5 TRUE {=MATCH(F29:F37,F29:F37,0)} samedi 6 6 6 TRUE {=MATCH(F29:F37,F29:F37,0)} dimanche 7 7 7.000000 TRUE {=MATCH(F29:F37,F29:F37,0)} lundi 1 1 1 TRUE {=MATCH(F29:F37,F29:F37,0)} mardi 2 2 2 TRUE {=MATCH(F29:F37,F29:F37,0)} 1 1 TRUE =MATCH(J29,J29:J37,0) With Strings With numbers 2 2 TRUE =MATCH(J30,J29:J37,0) 3 3 TRUE =MATCH(J31,J29:J37,0) match_type 4 4 TRUE =MATCH(J32,J29:J37,0) Other test 0 1 5 5.000000 TRUE =MATCH(J33,J29:J37,0) A 6 6.000000 TRUE =MATCH(J34,J29:J37,0) B 7 7.000000 TRUE =MATCH(J35,J29:J37,0) C 1 1.000000 TRUE =MATCH(J36,J29:J37,0) 2 2.000000 TRUE =MATCH(J37,J29:J37,0) 1 1.000000 TRUE {=MATCH(J29:J37,J29:J37,0)} 2 2.000000 TRUE {=MATCH(J29:J37,J29:J37,0)} 3 3.000000 TRUE {=MATCH(J29:J37,J29:J37,0)} 4 4.000000 TRUE {=MATCH(J29:J37,J29:J37,0)} 5 5.000000 TRUE {=MATCH(J29:J37,J29:J37,0)} 6 6.000000 TRUE {=MATCH(J29:J37,J29:J37,0)} 7 7.000000 TRUE {=MATCH(J29:J37,J29:J37,0)} 1 1.000000 TRUE {=MATCH(J29:J37,J29:J37,0)} 2 2.000000 TRUE {=MATCH(J29:J37,J29:J37,0)} 1 1.000000 TRUE {=MATCH(F43:F45,F43:F45,0)} 2 2.000000 TRUE {=MATCH(F43:F45,F43:F45,0)} 3 3.000000 TRUE {=MATCH(F43:F45,F43:F45,0)} 1 1.000000 TRUE {=MATCH(F43:F45,F43:F45,1)} 2 2.000000 TRUE {=MATCH(F43:F45,F43:F45,1)} 3 3.000000 TRUE {=MATCH(F43:F45,F43:F45,1)} 1 1.000000 TRUE {=MATCH({"A";"B";"C"},{"A";"B";"C"},0)} 2 2.000000 TRUE {=MATCH({"A";"B";"C"},{"A";"B";"C"},0)} 3 3.000000 TRUE {=MATCH({"A";"B";"C"},{"A";"B";"C"},0)} 1 1.000000 TRUE {=MATCH(F43:F45,{"A";"B";"C"},0)} 2 2.000000 TRUE {=MATCH(F43:F45,{"A";"B";"C"},0)} 3 3.000000 TRUE {=MATCH(F43:F45,{"A";"B";"C"},0)} 1 1.000000 TRUE {=MATCH({"A";"B";"C"},F43:F45,0)} 2 2.000000 TRUE {=MATCH({"A";"B";"C"},F43:F45,0)} 3 3.000000 TRUE {=MATCH({"A";"B";"C"},F43:F45,0)} test2 test2 test1 1 1.000000 TRUE {=MATCH(F43:F45,F43:F45,0)} test2 2 2.000000 TRUE {=MATCH(F43:F45,F43:F45,0)} test3 3 3.000000 TRUE {=MATCH(F43:F45,F43:F45,0)} 2 2.000000 TRUE =MATCH(H71,J71:J73,0) #N/A #N/A TRUE =MATCH(G76,A1:A5) 2 2.000000 TRUE =MATCH(0,G77:G79,0) #N/A 3 3.000000 TRUE =MATCH(1,G77:G79,0) 0 #N/A #N/A TRUE =MATCH(5,G77:G79,0) 1 #N/A #N/A TRUE =MATCH(I100,G95:G98) 1 1.000000 TRUE =MATCH(I101,G95:G98) 1 1.000000 TRUE =MATCH(I102,G95:G98) 842020700000001 2 2.000000 TRUE =MATCH(I103,G95:G98) 842020700000002 2 2.000000 TRUE =MATCH(I104,G95:G98) 842020700000003 #N/A #N/A TRUE =MATCH(I105,G95:G98) 842020700000004 3 3.000000 TRUE =MATCH(I106,G95:G98) 842020700000005 3 3.000000 TRUE =MATCH(I107,G95:G98) 4 4.000000 TRUE =MATCH(I108,G95:G98) 4 4.000000 TRUE =MATCH(I109,G95:G98) 1 AOO#103291 #N/A #N/A TRUE =MATCH(I100,J95:M95) 1 1 1.000000 TRUE =MATCH(I101,J95:M95) 1 1 1.000000 TRUE =MATCH(I102,J95:M95) 2 2 2.000000 TRUE =MATCH(I103,J95:M95) 3 2 2.000000 TRUE =MATCH(I104,J95:M95) #N/A #N/A TRUE =MATCH(I105,J95:M95) 1 one 1 3 b d 3 3.000000 TRUE =MATCH(I106,J95:M95) 3 two one two three four 3 3.000000 TRUE =MATCH(I107,J95:M95) b three 4 4.000000 TRUE =MATCH(I108,J95:M95) d four 4 4.000000 TRUE =MATCH(I109,J95:M95) query value 1 1.000000 TRUE =MATCH(H112,I112:I121,-1) 0 1 1.000000 TRUE =MATCH(H113,I112:I121,-1) 1 2 2.000000 TRUE =MATCH(H114,I112:I121,-1) 2 2 2.000000 TRUE =MATCH(H115,I112:I121,-1) 3 3 3.000000 TRUE =MATCH(H116,I112:I121,-1) 4 3 3.000000 TRUE =MATCH(H117,I112:I121,-1) a 4 4.000000 TRUE =MATCH(H118,I112:I121,-1) b 4 4 TRUE =MATCH(H119,I112:I121,-1) c 5 5 TRUE =MATCH(H120,I112:I121,-1) d 5 5.000000 TRUE =MATCH(H121,I112:I121,-1) e 6 6.000000 TRUE =MATCH(1,O125:O130,0) 2 2.000000 TRUE =MATCH(1,FREQUENCY(I126,H129:M129),0) 2 2.000000 TRUE =MATCH("r.d",H133:H134,0) 10 3 3.000000 TRUE =MATCH("C",H138:H149,0) 9 8 3 3.000000 TRUE =MATCH("C",I138:I149,0) 8 6 9 9.000000 TRUE =MATCH("C",J138:J149,0) 7 4 9 9.000000 TRUE =MATCH("C",K138:K149,0) 6 2 5 0 4 -2 3 -4 2 -6 1 -8 1 0 #N/A 2 Tdf#54255 22 0 0 0 30 25 20 15 10 5 0 1 2 3 4 5 6 1 0 blue red A B A B C A X D A E B F C B X G A B A H B I C J A C A K B C B L C X 4