That did indeed work, I just imagined it wouldn't as ctrl+shift+F9 in excel didn't.
On 11 May 2012 12:38, Yegor Kozlov <[email protected]> wrote: > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
