Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: [Bug 53729] Shift rows wrongly updates static reference
Date: Thu, 30 Aug 2012 13:40:12 +0000
Message-ID: <bug-53729-47293-gWMoUwByqy@https.issues.apache.org/bugzilla/>
In-Reply-To: <bug-53729-47293@https.issues.apache.org/bugzilla/>
References: <bug-53729-47293@https.issues.apache.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit
Auto-Submitted: auto-generated
MIME-Version: 1.0

https://issues.apache.org/bugzilla/show_bug.cgi?id=53729

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