>Any workarounds (i.e. copying a > pre-entered formula) are still welcome :)
POI will not "smartly" change a reference on copying .. it doesnt have *all* the features of excel :) It just reads the files Quoting Sasha Borodin <[EMAIL PROTECTED]>: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
