Hi Johnny, Johnny Rosenberg schrieb:
2011/6/4 Regina Henschel<[email protected]>:
[..]
In OOo this can be done by the function N. Unfortunately the spec makes it "implemention defined" what N does with text. In OOo N returns 0 for text, which I think is useful. In LO it returns #VALUE although the help saws it would return 0. So this behavior seems a bug to me in the N function. Otherwise I would have recommend to use N(C1)-N(B1) instead of C1-B1.
[..]
Someone would better file a bug report then, right?
It is already there https://bugs.freedesktop.org/show_bug.cgi?id=33705 Kind regards Regina -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
