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.
Yours
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
|