2011/6/4 Regina Henschel <rb.hensc...@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+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@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