Bug 58869 - when use setCellFormula change the cells with shared fomulas
Summary: when use setCellFormula change the cells with shared fomulas
Status: RESOLVED CLOSED
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-15 05:31 UTC by ki
Modified: 2021-11-27 10:20 UTC (History)
0 users



Attachments

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
[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?
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.
Comment 3 PJ Fanning 2021-11-27 10:20:18 UTC
POI V5.1.0 has fixes for shared formulas. Reopen this if they do not help.
Comment 4 PJ Fanning 2021-11-27 10:20:34 UTC
POI V5.1.0 has fixes for shared formulas. Reopen this if they do not help.