poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: DO NOT REPLY [Bug 48703] New: sum spanning multiple worksheets
Date Tue, 09 Feb 2010 07:46:45 GMT

I have no idea if this will work but an wondering if it could be a simple
matter of POI being slightly more pedantic than Excel. Have you tried
entering SUM(sheet1!A1:sheet35!A1) to see if that will work; it may simply
be that POI is expecting to see a sheet followed by a cell reference on both
sides of the colon operator. As I said, I cannot say that this will work but
it will be easy enough to test.


Mark B

Bugzilla from bugzilla@apache.org wrote:
> 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

View this message in context: http://old.nabble.com/DO-NOT-REPLY--Bug-48703--New%3A-sum-spanning-multiple-worksheets-tp27504665p27511510.html
Sent from the POI - Dev mailing list archive at Nabble.com.

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

View raw message