https://issues.apache.org/bugzilla/show_bug.cgi?id=53729
Priority: P2
Bug ID: 53729
Assignee: [email protected]
Summary: Shift rows wrongly updates static reference
Severity: normal
Classification: Unclassified
Reporter: [email protected]
Hardware: PC
Status: NEW
Version: 3.8
Component: XSSF
Product: POI
In my xlsx file I have a value at M17, many formulas uses it for counting.
This value is referenced as $M$17 with two dollar signs (to avoid auto
modification if generated cells).
When I am trying to shift rows up, calling sheet.shiftRows(18, 100, -3);
All formulas references in shifting rows were updated correctly, but $M$17 was
replaced with #REF! sign. I think it is a defect, cause it should be still
$M$17.
Seems like POI doesn't know about $ sign and updates reference to M17 to M14,
which leads to error.
--
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]
