Sander Vesik wrote:
how do I get the value of a cell to be +INF / -INF? the obvious way doesn't work :(
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.
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? Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
