[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-dev
Subject:    [Bug 66661] New: Issue with table formulas being modified by POI
From:       bugzilla () apache ! org
Date:       2023-06-20 22:46:36
Message-ID: bug-66661-47293 () https ! bz ! apache ! org/bugzilla/
[Download RAW message or body]

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: fanningpj@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]