Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: DO NOT REPLY [Bug 48703] New: sum spanning multiple worksheets
Message-ID: <bug-48703-47293@https.issues.apache.org/bugzilla/>
Auto-Submitted: auto-generated
Content-Type: text/plain; charset="UTF-8"
MIME-Version: 1.0
Date: Mon,  8 Feb 2010 11:05:37 -0800 (PST)

https://issues.apache.org/bugzilla/show_bug.cgi?id=48703

           Summary: sum spanning multiple worksheets
           Product: POI
           Version: 3.5-FINAL
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: thomas.lane.ctr@offutt.af.mil


I've discovered a problem with formulas spanning multiple sheets, specifically,
the sum operation.

I've got a workbook I need to build that contains 35 sheets.  I need to have a
sum operation that spans all the sheets.  I tried to use SUM(sheet1:sheet35!A1)
syntax, but setCellFormula throws an error with this syntax.  I have confirmed
that his syntax is valid for Excel, because I can enter it in manually

I am successfully able to use the SUM(sheet1!A1,sheet2!a1,...) syntax, but this
will not work for my problem, because SUM allows a maximum of 30 arguments.  I
could compute two sums, and then sum the results as a workaround, but for the
number of items I need to calculate, this can get really messy.

Is this syntax [SUM(sheet1:sheet35!A1)] going to be supported in a future
build, or is there a workaround to avoid the error being thrown?

Thanks,
Thomas Lane

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org