https://bz.apache.org/bugzilla/show_bug.cgi?id=66661
Bug ID: 66661
Summary: Issue with table formulas being modified by POI
Product: POI
Version: 5.2.3-FINAL
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
See https://lists.apache.org/thread/92vvvvwn25sjkbqo0rp8hlnkpb66lb84
reproduction code is in https://github.com/ManiacTwister/poi-table-bisect
A formula like `SUBTOTAL(109,Table1[Heading2])` can get overwritten by POI and
become `SUBTOTAL(109,Sheet0!B2:B6)`.
One way to avoid this is to call this API on XSSFWorkbook.
https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setCellFormulaValidation-boolean-
Setting it to false will stop POI rerendering your formulas.
It is suspected that https://github.com/apache/poi/pull/269 may be making this
cell formula rerendering worse for this scenario.
--
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]
