poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54509] New: Cells in shifting rows are not used in column-referencing formulas.
Date Thu, 31 Jan 2013 10:33:29 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=54509

            Bug ID: 54509
           Summary: Cells in shifting rows are not used in
                    column-referencing formulas.
           Product: POI
           Version: 3.9
          Hardware: PC
                OS: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: sylvain.delafoy@gmail.com
    Classification: Unclassified

Created attachment 29910
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=29910&action=edit
maven projet with an input file and a sample main method.

When shifting rows in an HSSFSheet, formulas such as "=sum(C[1])" do not use
new cells' values.

You need to open the resulting file in excel and edit (F2) the cell in order
for the formula to use the cell's value.

Sample file and code in the attachment.

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