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/10/02 14:36:32 UTC
DO NOT REPLY [Bug 45873] Formulas are not being recalculated

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