https://bz.apache.org/bugzilla/show_bug.cgi?id=64768
Bug ID: 64768
Summary: Formula isn't removed when cell value is updated
Product: POI
Version: 4.1.2-FINAL
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
I have a formula in the cell, for example:
=10 + 1
But when I set a new cell value like:
cell.setCellValue("foo")
POI doesn't remove the formula from the cell and cell type is still
CellType.FORMULA. When I open the file in the Excel, cell value hasn't been
changed.
Previosly I used Cell#setCellType(CellType) before updating cell value and it
was working. But now, Cell#setCellType(CellType) is deprecated and I don't get
the desired result by just using Cell#setCellValue(...).
Is it a bug? If so, could you fix it?
--
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]
