https://issues.apache.org/bugzilla/show_bug.cgi?id=51710
Antti Koskimäki <antti.koskim...@joinex.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #2 from Antti Koskimäki <antti.koskim...@joinex.com> 2011-08-23
19:13:47 UTC ---
You ment this discussion ?
http://apache-poi.1045710.n5.nabble.com/Excel-formula-oddness-td4680643.html
Yes, this seems to relate to the same issue. First of all, as far as I can
recall, I created the example file with simple routine; first made one formula
with "semi-static" references, then copied it from left to right for a total
row, then copy for row, paste for area downwards. So the use case is "shared
formula" case.
I looked into sheet1.xml, and there is this weird syntax in the exact cell
where the problem starts to show, E60. Until that, the row 60 is OK with si="2"
but ref-field in E60 is weird no matter how you think, and then for every cell
with si="3" POI returns incorrect formula.
---8<---------
<row r="60" spans="1:13">
<c r="A60" s="1">
<v>58</v>
</c>
<c r="B60">
<f t="shared" si="2"/>
<v>580</v>
</c>
<c r="C60">
<f t="shared" si="2"/>
<v>580</v>
</c>
<c r="D60">
<f t="shared" si="2"/>
<v>580</v>
</c>
<c r="E60">
<f t="shared" ref="C60:M83" si="3">$A60*E$2</f>
<v>580</v>
</c>
<c r="F60">
<f t="shared" si="3"/>
<v>580</v>
</c>
<c r="G60">
<f t="shared" si="3"/>
<v>580</v>
</c>
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
