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 2003/07/10 16:29:24 UTC

DO NOT REPLY [Bug 21442] - values in referencing cells are not updated

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21442>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21442

values in referencing cells are not updated





------- Additional Comments From lists@aviksengupta.com  2003-07-10 14:29 -------
Workaround proposed by Max Nam (thanks Max!) on the dev list
> I've achieved that using excel itself - by embedding a macro that
> recalculates a given sheet on open, ie:
> 
> Private Sub Workbook_Open()
> 
>   Sheet1.Calculate
> 
> End Sub
> 
> this works fine with poi > 1.9

Useful while this bug is still to be fixed.