2016-08-02T18:25:37.357529091P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/389b08190092f9a9103b3ac098994ec83b2d0bfa 0 0 69019 15019 view1 2 8 0 0 0 0 2 0 0 0 0 0 80 60 true false 9 28 0 0 0 0 2 0 0 0 0 0 80 60 true false Sheet2 1241 0 80 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 fr FR ru RU true true 3 1 true 1 true qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 - $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ - - - - - - - - - - - - € - - - - : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off ( ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - - . / - $ - $ ( ) - $ $( ) $- ( ) - $ - . . WAHR WAHR FALSCH $ - $ - - руб. - руб. R R - R R - R R - R R - - - R R - R - - - R R - R - ĝ micron mm mm Pa / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - - - - - ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 MINVERSE Function Result TRUE Sheet Result Description 1 TRUE Simple MINVERSE formulas with local references and values Function Expected Correct FunctionString Comment Data 0.2 1 -0.9 1 2 3 1 Data 0.011363636363636 0.011363636363636 TRUE =MINVERSE(I2:L5) 1 3 8 5 0.35 10.8 4 4 5 6 1 4 -1 2 2 TRUE =MINVERSE({3,6,1;1,1,0;3,10,2}) 1 3 6 1 -3.15 5 7 8 9 1 2 0 -0.333333333333333 -0.333333333333333 TRUE =MINVERSE({3,6;1,1}) 1 0 Formula Description Results Err:502 Err:502 TRUE =MINVERSE({1,3,8,5;1,3,6,1}) 7 3 10 2 0 0.5 5.96685082872928 5.96685082872928 TRUE =MINVERSE(N1:O2) -1 2 #VALUE! #VALUE! TRUE =MINVERSE(N1:P3) -2 -2 TRUE =MINVERSE({1,2;3,4}) -2 -2 TRUE =MINVERSE({1,2,1;3,4,2;1,1,2}) Err:502 Err:502 TRUE =MINVERSE(R1:T3) Err:502 Err:502 TRUE =MINVERSE(V1:X3) 1 -0.00015625 0 0.22658062230748 0.226580622307481 TRUE =I18 0 1 -6.92520775623269E-06 -4949.88401723213 -4949.88401723212 TRUE =I19 1 -0.0001108033241 -1 0.0001108033241 -0.051669615021659 -0.051669615021659 TRUE =I20 -5.86486486486487E-12 -1.3466097676624E-15 3.42028985507246E-12 6.91584032545131E-16 -7461.09240912761 -7461.09240912761 TRUE =I21 0.625136818699551 0.62513681869955 TRUE =J18 4000.87563967713 4000.87563967712 TRUE =J19 1.05454490009909 1.05454490009909 TRUE =J20 0.22658062230748 0.625136818699551 0.417669536993637 -60657806939.4408 7876.28357430792 7876.28357430793 TRUE =J21 -4949.88401723213 4000.87563967713 2673.08503675928 -388209964412421 0.417669536993637 0.417669536993637 TRUE =K18 -0.051669615021659 1.05454490009909 0.058567811378701 1176190162.26062 2673.08503675928 2673.08503675928 TRUE =K19 -7461.09240912761 7876.28357430792 8457.19196308448 169841859430434 0.058567811378701 0.058567811378701 TRUE =K20 8457.19196308448 8457.19196308448 TRUE =K21 -60657806939.4408 -60657806939.4408 TRUE =L18 -388209964412421 -388209964412421 TRUE =L19 1176190162.2606200000 1176190162.2606200000 TRUE =L20 169841859430434 169841859430434 TRUE =L21 ! 0 0 TRUE =Z5 -1 -1 TRUE =Z6 0.5 0.5 TRUE =AA5 2 2 TRUE =AA6 Err:511 error TRUE =MINVERSE() 4 O5 yes 1 no 2 yes 3