poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 51941] New: Formula evaluations fail when refering to multiple sheet in sum
Date Mon, 03 Oct 2011 17:17:48 GMT
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: dev@poi.apache.org
        ReportedBy: mikkel@westenholz.com
    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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message