Hi, thanks for the detailed report!
A quick "git bisect" with your code points at the following change: https://svn.apache.org/viewvc?view=revision&revision=1894695 Maybe Fanning PJ still remembers some details about the change and if we can revert parts of it to restore this functionality. Thanks... Dominik. On Tue, Jun 20, 2023 at 11:40 AM <maniactwister....@s7t.de> wrote: > 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 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > >
