--- Niklas Nebel <[EMAIL PROTECTED]> wrote:
> Sander Vesik wrote:
> >>Infinity isn't supposed to be in a cell. An infinite result from a
> >>formula is considered an error, and the error message (Err:503) is
> >>shown. Issue 47724 exists to distinguish between different errors, but
> >>it would still be an error flag, not infinity value.
> >
> > So I can't do it directly and even writing a function add-in function like
> plusinf()
>
> Right. The add-in function's result would be recognized as an error.
>
ok, then the only reasonable way for me is probably a combination of converting
formulas to java/c++ and using IF() in more ad-hoc calculations.
> >>That said, you can "sneak in" infinity through API calls that expect a
> >>value, but it's certainly not recommended - don't rely on any further
> >>operations on such a cell to still work.
> >>
> >>What are you trying to achieve?
> >
> > A cell having a value x such that 1/x would be zero - and in the process
> > save me
> > having to write complex formulas with large number of IF()-s.
>
> I see. 1/x would even (happen to) work once you have infinity in a cell,
> because it's the results that are checked, not the input values. But
> even a simple reference, like =A1 for example, would show an error,
> seeing infinity as an indication that the "calculation" could not be
> carried out.
>
> To change this, lots of places would have to be modified (and, in the
> first place, have a definition how to react on infinity values).
>
For definition, I think the one reasonable way would be to follow IEEE-754,
but this would need negative zero and open another can of worms. Could also
cause
some compatibility problems.
> Niklas
>
Sander
.sigless
___________________________________________________________
How much free photo storage do you get? Store your holiday
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
