A correction/additional detail of my report: #VALUE! is only displayed if the outer IF branches to an inner IF. For example:
> IF(A1 > 5, "big number", IF(A1 < 2, "really small number", "small number")) #VALUE! is displayed if "A1 > 5" evaluates to false, and branches to the "else" argument, where there's a nested IF. If "A1 > 5" evaluates to true, the formula displays correctly, because there's no nested if in the "true" argument. #VALUE! is always displayed if both the true and false arguments contain nested IF's. I will try my hand at the bugzilla. Any workarounds (i.e. copying a pre-entered formula) are still welcome :) -Sasha Borodin On 1/29/04 12:16 PM, "Sasha Borodin" <[EMAIL PROTECTED]> 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]
