On 12/03/2011 12:50 PM, Johnny Rosenberg wrote:
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!
Try in A1 no data/empty cell and in A2 =A1+1, you will get 1 in A2. You
are adding a text and number and the + operator is not used for
concatenation.
This has to do with operator overloading, are other, similar, operations
allowed when using '+'. Some may allow it and others may not,
restricting its use to mathematical operations only. LO uses the '&'
operator for concatenation.
If you use A1 = "" and A2 = A1 & 1 you get 1.
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
--
Jay Lozier
[email protected]
--
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
