Re: Nested IF's in formulas

[av...@itellix.com]

>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 <sa...@whoissasha.com>:

> 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" <sa...@whoissasha.com> 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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 





---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org