https://bz.apache.org/bugzilla/show_bug.cgi?id=58869
Bug ID: 58869
Summary: when use setCellFormula change the cells with shared
fomulas
Product: POI
Version: 3.12-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
[xl/worksheets/sheet1.xml]
<c r="A12" s="19"><f t="shared"
ref="A12:A75"si="45">SUM(BG12,BJ12)</f><v>0</v></c>
<c r="A13" s="19"><f t="shared" si="45"/>
after call Cell(A12).setCellFormul("SUM(B1,C1)")
[xl/worksheets/sheet1.xml]
<c r="A12" s="19"><f>SUM(B1,C1)</f><v>0</v></c>
<c r="A13" s="19"><f t="shared" si="45"/>
Then the Excel2010 could open the file by repairing or removing the unreadable
content.
Removed records: shared formula from /xl/worksheets/sheet1.xml part
Removed records: formula from /xl/calcChain.xml part (calculation properties)
so is there other way to change the cells with shared fomulas?
--
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]
