DO NOT REPLY [Bug 40034] New: - SUMIF does not work with cells from different sheet.

[bu...@apache.org]

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: iain.brown@nlg.co.nz


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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/