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: dev@poi.apache.org Reporter: fannin...@yahoo.com 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: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org