DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=40034>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40034 Summary: SUMIF does not work with cells from different sheet. Product: POI Version: 2.5 Platform: Other OS/Version: other Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: poi-dev@jakarta.apache.org ReportedBy: [EMAIL PROTECTED] 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 -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
