https://issues.apache.org/bugzilla/show_bug.cgi?id=53729
--- Comment #3 from Thies Wellpott <[email protected]> --- Created attachment 29307 --> https://issues.apache.org/bugzilla/attachment.cgi?id=29307&action=edit Proposed bug fix I think the bug can be fixed by changing org.apache.poi.ss.formula.FormulaShifter to check for absolute references. The attached patch does exactly this (it bases on the poi trunk but the source file did not change since poi 3.8). I only did a quick check with my own test case, it works. I did NOT test the modifications to AreaRef. A POI expert for this stuff should have a closer look. Also TODO is a recalculation of the formula because the base data has changed (is shifted!). Current solution is to call workbook.setForceFormulaRecalculation(true); manually when you use shiftRows() and are not sure about absolute references. -- 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]
