[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?
Related: bug 53207
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.
POI V5.1.0 has fixes for shared formulas. Reopen this if they do not help.