Mailing-List: contact poi-dev-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <poi-dev@jakarta.apache.org>
From: bugzilla@apache.org
To: poi-dev@jakarta.apache.org
Subject: DO NOT REPLY [Bug 40034]  New:  - SUMIF does not work with cells from
 different sheet.
Message-ID: <bug-40034-7501@http.issues.apache.org/bugzilla/>
Date: Wed, 12 Jul 2006 23:59:30 +0000 (GMT)

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/