https://issues.apache.org/bugzilla/show_bug.cgi?id=51941
Bug #: 51941
Summary: Formula evaluations fail when refering to multiple
sheet in sum
Product: POI
Version: 3.7
Platform: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
XSSFFormulaEvaluator.evaluateAllFormulaCells(workBook) fails if the workbook
contains a formula of the following type:
=SUM(David:Anders!AL9)
or
SUM('David A:Anders p'!AL9)
This type of formulas are described as the second tip in the following link:
http://office.microsoft.com/en-us/excel-help/5-tips-for-working-with-multiple-worksheets-in-excel-HA001042919.aspx
The text is also inserted here:
Sum the value of a cell across multiple worksheets
Another common Excel task is to sum the value of a cell in multiple worksheets
and then display the result in another cell. For example, you may want to sum
the number of a particular product that customers have ordered over a period of
time, such as by quarterly periods. If worksheets are formatted in the same way
for each period, the total sales for the product always appears in the same
cell in each worksheet.
Finding the sum in this situation is simple. You can use a formula:
1.Start Excel. A new, blank workbook appears.
2.In cell B3 in Sheet1, type 20.
3.In cell B3 in both Sheet2 and Sheet3, type 30.
4.In cell A1 in Sheet1, type the following formula:
=SUM(Sheet1:Sheet3!B3)
5.Press ENTER. Notice that cell A1 displays 80, which is the total sum of the
cells in the three worksheets.
--
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]
