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]
