$ - $ ok ERR! 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 ??? (???) 10/05/2009, 16:16:50 Page 1 / 99 Reference operators tests Result TRUE Sheet Result Description 1 TRUE Test from AOO bug https://bz.apache.org/ooo/show_bug.cgi?id=32341 ODFF: OpCode 'ocUnion' to pass multiple ranges as one parameter 1 $D$5 2 16 4 xxx 32 8 64 #VALUE! #N/A ok 128 #VALUE! #N/A ok Note: #N/A in the Must column means that the specific semantic isn't supported and should generate an error.Some Is cells have comments attached as PostIt notes. Function Expected Correct FunctionString Comment 255 255 TRUE =SUM(B1:D5) 255 255 TRUE =SUM((C1:C5~B1:B5~D1:D5)) 255 255 TRUE {=SUM((C1:C5~B1:B5~D1:D5))} 254 254 TRUE =SUM((C1:C5~B2:B5~D1:D5)) 254 254 TRUE {=SUM((C1:C5~B2:B5~D1:D5))} 90 90 TRUE =SUM((B1:B4~D2:D5)!(B2:D2~B4:D4)) 103 103 TRUE =SUM(B1:B4~D2:D5!B2:D2~B4:D4) 103 103 TRUE =SUM(B1:B4~(D2:D5!B2:D2)~B4:D4) 95 95 TRUE =SUM(B1:B4~D2:D5!(B2:D2~B4:D4)) 127 127 TRUE =SUM(B1:B4~D2:D5!B2:(C2:D2~B4:C4):D4) 254 254 TRUE =SUM(((B1:B4~D2:D5)!(B2:D2~B4:D4)):D5) 254 254 TRUE =SUM(((B1:B4~D2:D5)!(B2:D2~B4:D4)):INDIRECT(E1)) 254 254 TRUE =SUM((B1:B4~D2:D5)!(B2:D2~B4:D4):D5) 254 254 TRUE =SUM((B1:B4~D2:D5)!(B2:D2~B4:D4):INDIRECT(E1)) 218 218 TRUE =SUM((B1:B4~D2:D5)!(B2:D2)~(B4:D5)) 218 218 TRUE =SUM((B1:B4~D2:D5)!(B2:D2)~(B4:D4:INDIRECT(E1))) 218 218 TRUE =SUM((B1:B4~D2:D5)!(B2:D2~B4:D5)) 218 218 TRUE =SUM((B1:B4~D2:D5)!(B2:D2~B4:D4:INDIRECT(E1))) 218 218 TRUE =SUM((B1:B4~D2:D5)!B2:D2~B4:D5) 218 218 TRUE =SUM((B1:B4~D2:D5)!B2:D2~B4:D4:INDIRECT(E1)) 231 231 TRUE =SUM(B1:B4~D2:D5!B2:D2~B4:D5) 231 231 TRUE =SUM(B1:B4~D2:D5!B2:D2~B4:D4:INDIRECT(E1)) 254 254 TRUE =SUM((B2:B3~D3:D4):D5) 254 254 TRUE =SUM((B2:B3~D3:D4):INDIRECT(E1)) 230 230 TRUE =SUM((B2:B3~(D3:D5))) 230 230 TRUE =SUM((B2:B3~(D3:D4:INDIRECT(E1)))) 230 230 TRUE =SUM((B2:B3~D3:D5)) 230 230 TRUE =SUM((B2:B3~D3:D4:INDIRECT(E1))) 64 64 TRUE =SUM(B4:D4!(D3:D5)) 64 64 TRUE =SUM(B4:D4!(D3:D4:INDIRECT(E1))) 64 64 TRUE =SUM(B4:D4!D3:D5) 64 64 TRUE =SUM(B4:D4!D3:D4:INDIRECT(E1)) 192 192 TRUE =SUM((B4:D4!D3:D4):D5) 192 192 TRUE =SUM((B4:D4!D3:D4):INDIRECT(E1)) TRUE TRUE TRUE =AND(B1:D5) TRUE TRUE TRUE =AND((C1:C5~B1:B5~D1:D5)) TRUE TRUE TRUE =OR(B1:D5) TRUE TRUE TRUE =OR((C1:C5~B1:B5~D1:D5)) TRUE TRUE TRUE =ISREF(B1:D5) TRUE TRUE TRUE =ISREF((C1:C5~B1:B5~D1:D5)) FALSE FALSE TRUE =ISNUMBER(B1:D5) FALSE FALSE TRUE =ISNUMBER((C1:C5~B1:B5~D1:D5)) FALSE FALSE TRUE =ISLOGICAL(B1:D5) FALSE FALSE TRUE =ISLOGICAL((C1:C5~B1:B5~D1:D5)) 1 1 TRUE =MIN(B1:D5) 1 1 TRUE =MIN((C1:C5~B1:B5~D1:D5)) 0 0 TRUE =MINA(B1:D5) 0 0 TRUE =MINA((C1:C5~B1:B5~D1:D5)) 128 128 TRUE =MAX(B1:D5) 128 128 TRUE =MAX((C1:C5~B1:B5~D1:D5)) 128 128 TRUE =MAXA(B1:D5) 128 128 TRUE =MAXA((C1:C5~B1:B5~D1:D5)) 8 8 TRUE =COUNT(B1:D5) 8 8 TRUE =COUNT((C1:C5~B1:B5~D1:D5)) 9 9 TRUE =COUNTA(B1:D5) 9 9 TRUE =COUNTA((C1:C5~B1:B5~D1:D5)) 44.27 44.27 TRUE =STDEV(B1:D5) 44.27 44.27 TRUE =STDEV((C1:C5~B1:B5~D1:D5)) 42.75 42.75 TRUE =STDEVA(B1:D5) 42.75 42.75 TRUE =STDEVA((C1:C5~B1:B5~D1:D5)) 6 6 TRUE =COUNTBLANK(B1:D5) 6 6 TRUE =COUNTBLANK((C1:C5~B1:B5~D1:D5)) 1 1 TRUE =COUNTIF(B1:D5,32) 1 1 TRUE =COUNTIF((C1:C5~B1:B5~D1:D5),32) 255 255 TRUE =SUMIF(B1:D5,"<>0") 255 255 TRUE =SUMIF((C1:C5~B1:B5~D1:D5),"<>0") 32 32 TRUE =SUMIF(B1:D5,32,B1:D5) Err:504 #N/A TRUE =SUMIF((C1:C5~B1:B5~D1:D5),32,B1:D5) 32 32 TRUE =SUMIF((C1:C5~B1:B5~D1:D5):D5,32,B1:D5) 32 32 TRUE =SUMIF((C1:C5~B1:B5~D1:D5),32) 519 519 TRUE =ERRORTYPE(B1:D5) 519 519 TRUE =ERRORTYPE((C1:C5~B1:B5~D1:D5)) $0.02454010904849900000 0.0245401090485 TRUE =NPV(42,B1:D5,B1:D5) $0.02 0.02 TRUE =NPV(42,(C1:C5~B1:B5~D1:D5),(C1:C5~B1:B5~D1:D5)) 0.74 0.74 TRUE =ZTEST(B1:D5,42) 0.74 0.74 TRUE =ZTEST((C1:C5~B1:B5~D1:D5),42) 1.6 1.6 TRUE =KURT(B1:D5,B1:D5) 1.6 1.6 TRUE =KURT((C1:C5~B1:B5~D1:D5),(C1:C5~B1:B5~D1:D5)) 4.02 4.02 TRUE =HARMEAN(B1:D5,B1:D5) 4.02 4.02 TRUE =HARMEAN((C1:C5~B1:B5~D1:D5),(C1:C5~B1:B5~D1:D5)) 11.31 11.31 TRUE =GEOMEAN(B1:D5,B1:D5) 11.31 11.31 TRUE =GEOMEAN((C1:C5~B1:B5~D1:D5),(C1:C5~B1:B5~D1:D5)) 1.61 1.61 TRUE =SKEW(B1:D5,B1:D5) 1.61 1.61 TRUE =SKEW((C1:C5~B1:B5~D1:D5),(C1:C5~B1:B5~D1:D5)) 3 3 TRUE =RANK(32,B1:D5) 3 3 TRUE =RANK(32,(C1:C5~B1:B5~D1:D5)) 32.09 32.09 TRUE =AVEDEV(B1:D5,B1:D5) 32.09 32.09 TRUE =AVEDEV((C1:C5~B1:B5~D1:D5),(C1:C5~B1:B5~D1:D5)) 1 1 TRUE =GCD(B1:D5,B1:D5) 1 1 TRUE =GCD((C1:C5~B1:B5~D1:D5),(C1:C5~B1:B5~D1:D5)) 128 128 TRUE =LCM(B1:D5,B1:D5) 128 128 TRUE =LCM((C1:C5~B1:B5~D1:D5),(C1:C5~B1:B5~D1:D5)) Err:502 #N/A TRUE =SUM(INDEX((C1:C5~B1:B5~D1:D5),0,0,0)) #REF! #N/A TRUE =SUM(INDEX((C1:C5~B1:B5~D1:D5),0,0,4)) 0 0 TRUE =SUM(C1:C5) 0 0 TRUE =SUM(INDEX((C1:C5~B1:B5~D1:D5),0,0,1)) 15 15 TRUE =SUM(B1:B5) 15 15 TRUE =SUM(INDEX((C1:C5~B1:B5~D1:D5),0,0,2)) 240 240 TRUE =SUM(D1:D5) 240 240 TRUE =SUM(INDEX((C1:C5~B1:B5~D1:D5),0,0,3)) 3 3 TRUE =AREAS((C1:C5~B1:B5~D1:D5)) 3 3 TRUE {=FREQUENCY((C1:C5~B1:B5~D1:D5),{4,16,64})} 2 2 TRUE {=FREQUENCY((C1:C5~B1:B5~D1:D5),{4,16,64})} 2 2 TRUE {=FREQUENCY((C1:C5~B1:B5~D1:D5),{4,16,64})} 1 1 TRUE {=FREQUENCY((C1:C5~B1:B5~D1:D5),{4,16,64})} 12 12 TRUE =MEDIAN((C1:C5~B1:B5~D1:D5)) 12 12 TRUE =PERCENTILE((C1:C5~B1:B5~D1:D5),0.5) 12 12 TRUE =QUARTILE((C1:C5~B1:B5~D1:D5),2) #VALUE! #N/A TRUE =MODE((C1:C5~B1:B5~D1:D5)) 16 16 TRUE =LARGE((C1:C5~B1:B5~D1:D5),4) 8 8 TRUE =SMALL((C1:C5~B1:B5~D1:D5),4) xxx 15 15 TRUE =TRIMMEAN((C1:C5~B1:B5~D1:D5),0.5) 1 2 0.7590000000 0.7580000000 =PERCENTRANK((C1:C5~B1:B5~D1:D5),42) Eike, winfried 4 8 16 32 64 128 0.7590000