Re: [tdf-discuss] Simple solution to avoid #VALUE required

Regina Henschel schrieb:

> I have just a look in the spec.

Thank you for information, good to know!

> Workaround exist some:

Currently I use a"SUM()-Workaround, but the problem is that some of the 
Workarounds might be "fixed away" in future?!

> (1) Write 0, and format the cell to not show the 0. Use the format code
> Standard;Standard;"" for example.
> (2) Use a function with range, for example sum(H2:H2) instead of a
> simple reference H2.
> (3) Use a case distinction IF(H2="";0;H2) instead of simple reference H2.
> You can hide (2) and (3), by defining a name for the expression.
> (4) In OOo you can use N(H2) instead of H2, not in LO.
>
> The problem is connected to function N and should be solved together
> with N in the source code.
>
> We should try to get a consensus how LO calculates with text. How are
> such decisions done? For OOo Oracle had decided, but here?

That's the main problem I see (also the "Fix" causes several thousands 
of "#VALUE" in my existing documents). Such decisions should be prepared 
by something similar to the OOo specifications (but less elaborated) in 
the Wiki. I will initiate a discussion in the next TSC call.

Kind regards

Rainer

--
Unsubscribe instructions: E-mail to discuss+help@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted