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.
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.
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 ***