poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53729] Shift rows wrongly updates static reference
Date Thu, 30 Aug 2012 13:40:12 GMT

--- Comment #3 from Thies Wellpott <twapache@online.de> ---
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

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

View raw message