You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/01/15 06:31:10 UTC
[Bug 58869] New: when use setCellFormula change the cells with
shared fomulas
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: dev@poi.apache.org
Reporter: tersitain@gmail.com
[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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 58869] when use setCellFormula change the cells with shared
fomulas
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58869
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 58869] when use setCellFormula change the cells with shared fomulas
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58869
PJ Fanning <fa...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |CLOSED
--- Comment #4 from PJ Fanning <fa...@yahoo.com> ---
POI V5.1.0 has fixes for shared formulas. Reopen this if they do not help.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 58869] when use setCellFormula change the cells with shared fomulas
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58869
--- Comment #3 from PJ Fanning <fa...@yahoo.com> ---
POI V5.1.0 has fixes for shared formulas. Reopen this if they do not help.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 58869] when use setCellFormula change the cells with shared
fomulas
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58869
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from Javen O'Neal <on...@apache.org> ---
Related: bug 53207
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org