Call workbook.setForceFormulaRecalculation(true) and Excel will perform a full recalculation when the workbook is opened.
Yegor On Fri, May 11, 2012 at 12:25 PM, Timo Mikkolainen <[email protected]> wrote: > Hi, > I'm using SXSSF to create spreadsheets with some simple formulas that > just copy the value from another cell (e.g. > =IF(ISBLANK(Source!A1),"",Source!A1) ). Problem is as follows: > - SXSSF doesn't evaluate the formulas (there's no evaluator for SXSSF) > - Excel doesn't evaluate them on document load (they work fine if I > update the formula or the source cell's value) > - Setting an empty String with setCellValue(String value) removes the > formula from the cell > - setCellValue(double value) works fine, but there's no way to pass an > empty value > - Not setting a value for the cells makes them default to a value of > '0.0', I'd need them to be empty when the source cells are empty > > So is there any way to set an empty cached formula result for the > cells or make excel evaluate the formulas (short of refreshing the > cells with VBA)? > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
