poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 51710] getCellFormula() returns incorrect result
Date Tue, 23 Aug 2011 19:13:47 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=51710

Antti Koskimäki <antti.koskimaki@joinex.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #2 from Antti Koskimäki <antti.koskimaki@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message