2016-07-24T08:15:55.362000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/7b8832ff972a4e9f3e03fd7d96882b2a78c03b3e 0 0 103829 22189 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 1 6 0 0 0 0 2 0 0 0 0 0 75 60 true false Sheet2 1241 0 75 60 false true true true 12632256 true true true true true 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 de DE en US nl NL true true 3 1 true 1 true lgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== 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 € € - tan aa zł - zł - - Kč - Kč - Kč - - Kč - Kč - Kč / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 GEOMEAN Function Result TRUE Sheet Result Description 1 TRUE Simple GEOMEAN formulas with local references and values Function Expected Correct FunctionString Comment 0 0 0 TRUE =GEOMEAN(I1:I4) Check 5.3 0.1 5 9 0.221336383940064 0.221336383940064 TRUE =GEOMEAN(I2:I5) 0.2 6 10 0.330975091964687 0.330975091964687 TRUE =GEOMEAN(I3:I6) 0.3 7 11 0.435587717469286 0.435587717469286 TRUE =GEOMEAN(I4:I7) 0.4 8 12 0.538356327095529 0.538356327095529 TRUE =GEOMEAN(I5:I8) 0.5 -9 0.640217174588736 0.640217174588736 TRUE =GEOMEAN(I6:I9) 0.6 0.741558550213468 0.7415585502134680000 TRUE =GEOMEAN(I7:I10) 0.7 0.842573186122104 0.842573186122104 TRUE =GEOMEAN(I8:I11) 0.8 1.09544511501033 1.09544511501033 TRUE =GEOMEAN(I9:I12) 0.9 1.52439824446384 1.52439824446384 TRUE =GEOMEAN(I10:I13) 1 2.21336383940064 2.21336383940064 TRUE =GEOMEAN(I11:I14) 2 3.30975091964687 3.30975091964687 TRUE =GEOMEAN(I12:I15) 3 4.35587717469286 4.35587717469286 TRUE =GEOMEAN(I13:I16) 4 5.3835632709553 5.3835632709553 TRUE =GEOMEAN(I14:I17) 5 6.40217174588736 6.40217174588736 TRUE =GEOMEAN(I15:I18) 6 7.41558550213468 7.41558550213468 TRUE =GEOMEAN(I16:I19) 7 8.42573186122104 8.42573186122104 TRUE =GEOMEAN(I17:I20) 8 9.43368336574575 9.43368336574575 TRUE =GEOMEAN(I18:I21) 9 10.4400868170485 10.4400868170485 TRUE =GEOMEAN(I19:I22) 10 11.4453564012006 11.4453564012006 TRUE =GEOMEAN(I20:I23) 11 12.4497700444619 12.4497700444619 TRUE =GEOMEAN(I21:I24) 12 13.4535213809612 13.4535213809612 TRUE =GEOMEAN(I22:I25) 13 14.456749553126 14.456749553126 TRUE =GEOMEAN(I23:I26) 14 15.4595571715568 15.4595571715568 TRUE =GEOMEAN(I24:I27) 15 16.4620215944236 16.4620215944236 TRUE =GEOMEAN(I25:I28) 16 17.4642022620941 17.4642022620941 TRUE =GEOMEAN(I26:I29) 17 17.9814623967723 17.9814623967723 TRUE =GEOMEAN(I27:I30) 18 18.4932420089069 18.4932420089069 TRUE =GEOMEAN(I28:I31) 19 19 19 TRUE =GEOMEAN(I29:I32) #NUM! #NUM! TRUE =GEOMEAN(I30:I33) 41.7937736351392 41.7937736351392 TRUE =GEOMEAN(23,46,69) 1.19039218058502 1.19039218058502 TRUE {=GEOMEAN(I2:I5,J2:J5)} 1.19039218058502 1.19039218058502 TRUE =GEOMEAN(I2:J5) 6.40217174588736 6.40217174588736 TRUE =GEOMEAN({5,6,7,8}) 8.17552621209907 8.17552621209907 TRUE =GEOMEAN({5,6,7,8;9,10,11,12}) 8.17552621209907 8.17552621209907 TRUE =GEOMEAN(J2:K5) #NUM! #NUM! TRUE =GEOMEAN(J21:J25) at least 1 value must be given #NUM! #NUM! TRUE =GEOMEAN() at least 1 value must be given Err:502 Err:502 TRUE =GEOMEAN(J2:J6) negative values are not allowed