Bug 21442 - values in referencing cells are not updated
Summary: values in referencing cells are not updated
Status: RESOLVED DUPLICATE of bug 17196
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-pre3
Hardware: PC All
: P3 normal with 4 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2003-07-09 18:44 UTC by Meike Reichle
Modified: 2005-03-20 17:06 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Meike Reichle 2003-07-09 18:44:51 UTC
When changing values in cells with POI the values in other cells that refer to
those (such as "=B5" or "=C7+D8" ...) are not updated automatically. It has to
be done by hand by clicking in every referencing cell.
Comment 1 Avik Sengupta 2003-07-10 14:29:23 UTC
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. 
Comment 2 Andy Oliver 2003-07-24 17:06:03 UTC
I think several of the bugs I marked for 2.0 are reincarnations of this bug...we
need to fix this

*** This bug has been marked as a duplicate of 17196 ***