https://bz.apache.org/bugzilla/show_bug.cgi?id=65829

            Bug ID: 65829
           Summary: formula cell overprints when updating dependent cells
           Product: POI
           Version: 5.2.0-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: leroy.erw...@gmail.com
  Target Milestone: ---

Created attachment 38172
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=38172&action=edit
cells overprints

Hi,

I use apache poi tu generate an xlsx file.
When I open this file with Excel, a strange behaviour appears.

I have a cell containing a formula.
The formula references others cells in the same sheet.

When I update these other cells, the formula updates itself, but overprints the
new value on the previous.

If I change sheet or scroll in order to not see anymire the cell and then
returns, the cell display correctly.

If I copy paste the sheet in a new Excel file, the problem disappears.

So I think there is a bug in the generated file from Apache POI.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to