2011/12/3 Pedro <[email protected]>: > > Johnny Rosenberg wrote >> >> Depending on the value in other cells, the result can be a time or an >> empty string (""). In this case, E9 is an empty string, so E10 becomes >> ”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because >> of this. >> > > Can you provide an example file? This used to be a problem but it is fixed > in 3.4.4 (at least under Windows)
I could, but it's not needed, I think. I just did this simple test in 3.3.4 and 3.4.4: Open LibreOffice Calc from scratch. A1: ="" A2: =A1+1 In LibreOffice 3.3.4 (Ubuntu 10.10), A2 displays: 1 In 3.4.4 (Ubuntu 11.10), OOO340m1 (Build:402), A2 displays: #VALUE! Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > -- > View this message in context: > http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557454.html > Sent from the Users mailing list archive at Nabble.com. > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
