Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

2011/6/4 Regina Henschel <rb.henschel@t-online.de>:
> Hi "prholland",
>
> prholland schrieb:
> > The following screenshot is taken from a spreadsheet that previously
> > showed
> > "00:00" in LibreOffice 3.3.2, where LibreOffice 3.4.0 is now showing
> > "#VALUE!" (NB: all the cells are formatted as Time values, and the "text"
> > cells contain "-"):
> >
> > http://nabble.documentfoundation.org/file/n3023141/%23VALUE-screenshot.png
>
> The ODF spec has some rules for converting text to numbers. Those conversion
> is different whether the text occurs in a simple calculation with operator
> or the text occurs in a range in function SUM or similar. As LO claims to
> follow ODF spec, it has to respect this.
>
> In future you have to respect, that + - * / ^ will not work on text. You
> have to ensure, that the operands are numbers.
>
> 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.
>
> I notice, that Tom has already found the solution, to enter 0 and format it
> to show - .
>
> Kind regards
> Regina

Someone would better file a bug report then, right?


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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