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