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 2008/09/24 14:41:07 UTC
DO NOT REPLY [Bug 45873] New: Formulas are not being recalculated
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
Summary: Formulas are not being recalculated
Product: POI
Version: 3.1
Platform: PC
OS/Version: Windows Server 2003
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
AssignedTo: dev@poi.apache.org
ReportedBy: merav.eshet@precise.com
Hello,
Using poi v.3.0 (poi-3.0-rc4-20070503.jar) I encountered a problem which looks
like bug #44233.
Formulas which are referenced to another sheet are not being recalculated when
the source sheet data is modified.
I viewed the change list and saw that it was fixed in Version 3.0.2-FINAL
(2008-02-04).
I tried using the latest version of POI 3.1-FINAL Released (2008-06-29) and
still encountered the same problem, so I think that the fix for this bug might
not be included in the new version.
Will you able to check it please?
A fix above v.3.1 will be appreciated.
Thanks,
Merav
--
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
DO NOT REPLY [Bug 45873] Formulas are not being recalculated
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
Merav E. <me...@precise.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |merav.eshet@precise.com
Status|RESOLVED |REOPENED
Resolution|WORKSFORME |
--- Comment #2 from Merav E. <me...@precise.com> 2008-10-02 05:36:31 PST ---
(In reply to comment #0)
> Hello,
> Using poi v.3.0 (poi-3.0-rc4-20070503.jar) I encountered a problem which looks
> like bug #44233.
> Formulas which are referenced to another sheet are not being recalculated when
> the source sheet data is modified.
> I viewed the change list and saw that it was fixed in Version 3.0.2-FINAL
> (2008-02-04).
> I tried using the latest version of POI 3.1-FINAL Released (2008-06-29) and
> still encountered the same problem, so I think that the fix for this bug might
> not be included in the new version.
> Will you able to check it please?
> A fix above v.3.1 will be appreciated.
> Thanks,
> Merav
(In reply to comment #1)
> See http://poi.apache.org/hssf/eval.html
Thanks for your quick response.
When I use old version of poi (I don’t know the exact version but it’s
older than 3.0.0 and its size is 605 kb), the problem doesn’t occur and all
formulas are recalculated properly, without using any of the
HSSFFormulaEvaluator methods (which were not exist then, anyway).
When I use v.3.0 and v.3.1 this problem occurs: Formulas are not recalculated
in a table list, although charts (I tried pie chart) are recalculated properly.
When I try implementing the HSSFFormulaEvaluator in my code it doesn’t solve
the problem.
Please let me know if you need our code examples.
--
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
DO NOT REPLY [Bug 45873] Formulas are not being recalculated
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
--- Comment #5 from Andrew Gillett <as...@gmail.com> 2009-07-07 18:55:36 PST ---
Created an attachment (id=23939)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23939)
Java test case
--
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
DO NOT REPLY [Bug 45873] Formulas are not being recalculated
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |WORKSFORME
--- Comment #1 from Nick Burch <ni...@torchbox.com> 2008-09-24 06:52:02 PST ---
See http://poi.apache.org/hssf/eval.html
--
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
DO NOT REPLY [Bug 45873] Formulas are not being recalculated
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |WORKSFORME
--- Comment #7 from Josh Micich <jo...@gildedtree.com> 2010-01-05 19:21:09 UTC ---
Your example seems to work OK with
poi-2.5.1-final-20040804, poi-3.1-FINAL-20080629, poi-3.2-FINAL,
poi-3.5-beta5-20090115, poi-3.5-FINAL-20090928, poi-3.6-20091214
But with poi-3.0-FINAL and poi-3.0.2-FINAL-20080204, POI fails to encode the
formula correctly (perhaps an old bug token operand class transformation). I'm
a little surprised that you reported 3.0-rc4-20070503 to work for you.
Perhaps your observations are specific to a particular Excel version. I use
Win Excel 2007. It might be the case that prior versions of Excel don't
auto-calculate a spreadsheet without being forced to. I don't recall if POI
has changed recently (with regard to the default value of the auto-calculate
flag). Try HSSFSheet.setForceFormulaRecalculation() to force Excel to
re-calculate all formulas on the current sheet upon opening. On the other
hand, you can use HSSFFormulaEvaluator and evaluateFormulaCell() to update the
cached formula results so that re-calculation by Excel is not relevant.
--
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
DO NOT REPLY [Bug 45873] Formulas are not being recalculated
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
jofferson adrias <je...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jeighfritz07@yahoo.com
--
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
DO NOT REPLY [Bug 45873] Formulas are not being recalculated
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
Duc Nguyen <du...@sds.com.vn> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |duc.nguyen@sds.com.vn
--
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
DO NOT REPLY [Bug 45873] Formulas are not being recalculated
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
Andrew Gillett <as...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #6 from Andrew Gillett <as...@gmail.com> 2009-07-07 19:01:12 PST ---
I've also encountered this problem recently. I have attached a test spreadsheet
that contains data and a column with formula cells. The attached java program
reads the spreadsheet and puts random numbers into the data cells.
If the java program is compiled and run with poi-2.5.1-final-20040804, the
formula cells and chart are updated. With later versions of poi (I've tried
3.0-rc4-20070503, 3.2-FINAL-20081019, and 3.5-beta6-20090622) the formula cells
retain their values from the original input file.
--
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
DO NOT REPLY [Bug 45873] Formulas are not being recalculated
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |NEEDINFO
--- Comment #3 from Josh Micich <jo...@gildedtree.com> 2008-11-05 20:03:00 PST ---
When you write "modified" and "recalculated", it is not clear whether POI or
Excel is the agent for either operation.
It will help a lot if you attach a sample spreadsheet and/or some sample code,
to show the exact steps that result in your observed problem.
--
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
DO NOT REPLY [Bug 45873] Formulas are not being recalculated
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45873
--- Comment #4 from Andrew Gillett <as...@gmail.com> 2009-07-07 18:55:03 PST ---
Created an attachment (id=23938)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23938)
Test spreadsheet
--
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