https://bz.apache.org/bugzilla/show_bug.cgi?id=54524

--- Comment #4 from Javen ONeal <javenon...@gmail.com> ---
For the record, this fix makes POI consistent with Microsoft Office. Note that
other spreadsheets applications may have different behavior.

After sheet.shiftRows(3, 5, -1):

Microsoft Office 2013 behavior:
A3 -> formula=`=SUM(A2:A2)`, cachedValue=1

LibreOffice Calc 4.0.4.2 behavior (probably the same as OpenOffice)
A3 -> formula=`=SUM(A2:A3)`, cachedValue=Err:522 (circular reference)

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to