https://bz.apache.org/bugzilla/show_bug.cgi?id=67442
Bug ID: 67442
Summary: Setting blank on cells of certain range of shared
formulas trhows XmlValueDisconnectedException
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 39042
--> https://bz.apache.org/bugzilla/attachment.cgi?id=39042&action=edit
The workbook contains a 2D range of shared formulas which is "interrupted"
with nested shared formulas and normal formula cells.
When iterating the attached workbook and setting each of its cell to blank the
XmlValueDisconnectedException is thrown. The workbook contains a 2D range of
shared formulas which is "interrupted" with nested shared formulas and normal
formula cells.
The issue is related to the
https://bz.apache.org/bugzilla/show_bug.cgi?id=65268 where the same problem was
happening. The fix provided there works reliably only for 1D ranges of shared
formulas.
The issue is in the XSSFSheet.onDeleteFormula method. While the method seems to
work for 1D ranges of shared formulas 2D ranges are more complex. If their
"master" shared formula is removed (e.g. by setting the cell to blank) a non
trivial algorithm is necessary to adjust the remaining shared formula cells.
--
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]
