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: [email protected]
ReportedBy: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
