Re: [libreoffice-users] Re: Stuck with 3.3 forever?

On 12/03/2011 12:50 PM, Johnny Rosenberg wrote:
> 2011/12/3 Pedro<pedlino@gmail.com>:
> > 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: users+help@global.libreoffice.org
> > 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
jslozier@gmail.com


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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