"Johnny Rosenberg" <gurus.knu...@gmail.com> wrote in message
news:cado7t4d47+3comv6+rbhbloeb6wpilhf3isrfm0o5qmpkcx...@mail.gmail.com...
2011/12/3 Pedro <pedl...@gmail.com>:
Johnny Rosenberg wrote
I could agree with that, but it would have been nice if they thought
of that since 1.0 and not changing it on the way, breaking a whole lot
of spreadsheets…
I see your point. But this was wrong.
It's not a change of plans it's simply a correction. And not fixing it
would
break a lot of other spreadsheets ;)
Johnny Rosenberg wrote
Is there another way to make A2 look empty in
this case, making it useable for calculations? Something like the
following:
=IF(A1=6;SomethingNiceToPutHere;B1)
<snip>
What happens if you set A3 to be =((A2&"0")/10+27)
So, for example, if A2 is 30, A2&"0" is 300; divide by 10 gives 30 again and
then add the 27. But if A2 is "" (empty), A2&"0" should force a numeric zero
which stays the same when divided by 10.
--
Harold Fuchs
London, England
--
For unsubscribe instructions e-mail to: users+h...@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
