enter a bug in bugzilla so i/we dont lose track of pending issues.
Sasha Borodin wrote:
Hello,
The formula document on the HSSF website instructed to report all occurrences of #VALUE! when attempting to programmatically assign a formula to a cell, so here goes:
IF(A1 > 5, "big number", "small number")
This formula works, and displays correctly when opened in Excel.
IF(A1 > 5, "big number", IF(A1 < 2, "really small number", "small number"))
This one, with a nested IF, does not work: -The cell displays #VALUE! -but if I type it in directly in Excel, the formula works -also, clicking in the formula bar of POI-generated formula, then hitting Enter, fixes the formula
Anyone have any experience with this? Any good workarounds? I thought about typing the complex formulas in Excel, in some "formula dictionary" cells hidden at the bottom of the document, then copying them programmatically to the needed cell.
However, I'm not sure what happens to formula cell references when cells are copied through POI. I know if I copied a cell in Excel, the references would be smartly adjusted...how about POI? I don't know if this is a feature of Excel itself, or how the formula cell stores cell references).
Any help is greatly appreciated. Thanks,
-Sasha Borodin
--------------------------------------------------------------------- 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]
