Bug 58869 - when use setCellFormula change the cells with shared fomulas
Summary: when use setCellFormula change the cells with shared fomulas
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.12-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2016-01-15 05:31 UTC by ki
Modified: 2016-02-12 07:36 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description ki 2016-01-15 05:31:10 UTC
<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)")
<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?
Comment 1 Javen O'Neal 2016-01-15 07:19:22 UTC
Related: bug 53207
Comment 2 Dominik Stadler 2016-02-12 07:36:01 UTC
Can you attach a sample document and possibly a unit-test which reproduces this? Then after a fix is done we can ensure it stays fixed in the future.