Bug 40034

Summary: SUMIF does not work with cells from different sheet.
Product: POI Reporter: Iain Brown <iain.brown>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 2.5-FINAL   
Target Milestone: ---   
Hardware: Other   
OS: other   

Description Iain Brown 2006-07-12 23:59:30 UTC
We are using the HSSF Api's from RPGLE on the system i5 (AS400), and the SUMIF
formula does not work when it references cells on another sheet:
We create a sheet "Detail", containing data, and then create a sheet "Summary"
with formulas such as "SUMIF(Detail!$A2:$A6,$A2,Detail!$E2:$E6)". The cell value
is zero when spreadsheet is first openened, and only becomes correctly populated
when F2 is pressed on the cell, and then enter. (F9 has no effect).

Note: The SUMIF function works fine on the "Detail" sheet when refering to a
range of cells on the same sheet, so it must be the combination of the SUMIF
function, and the sheet reference
Comment 1 Josh Micich 2008-05-08 23:27:06 UTC
Probably due to a bug with token operand classes fixed in bug 44675.