Problem with XSSF TotalRows/Formulas starting poi version 5.2.0

[email protected] Tue, 20 Jun 2023 11:40:42 +0200
Newsgroups gmane.comp.jakarta.poi.user
Message-ID <[email protected]>
Hello,

i have a problem with the setTotalsRowFunction / setCellFormula method 
starting with poi version 5.2.0 and above. In previous versions 
including 5.1.0 everything works fine.

Excel complains about a broken worksheet and after repairing the 
totalsrow is inside the table. I compared the resulting xml files and 
noticed the following difference:

diff --color -ur works/xl/worksheets/sheet1.xml 
broken/xl/worksheets/sheet1.xml
--- works/xl/worksheets/sheet1.xml	2023-06-20 11:31:01.313017689 +0200
+++ broken/xl/worksheets/sheet1.xml	2023-06-20 11:30:57.709657562 +0200
@@ -81,10 +81,10 @@
          <v>4</v>
        </c>
        <c r="B6">
-        <f>SUBTOTAL(109,Table1[Heading2])</f>
+        <f>SUBTOTAL(109,Sheet0!B2:B6)</f>
        </c>
        <c r="C6">
-        <f>SUBTOTAL(109,Table1[Heading3])</f>
+        <f>SUBTOTAL(109,Sheet0!C2:C6)</f>
        </c>
        <c r="D6" t="s">
          <v>4</v>

For some reason poi >= 5.2.0 rewrites the cell formula from table 
columns to a normal range.


Under [1] i have pushed a simple test case to reproduce the issue - 
including the resulting xlsx and the extracted and formated xml files. 
(The test case is copied from this stackoverflow [2] question)

Does someone have an idea how to solve this?

[1] https://github.com/ManiacTwister/poi-table-bisect
[2] 
https://stackoverflow.com/questions/68783226/apache-poi-set-cell-format-that-include-the-result-of-table-total-row