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

Harold Fuchs-4 wrote
> 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.

The point here is that =A2&"0" is considered text (you can check with
ISTEXT), so you shouldn't even be able to divide it!

There is a lack of consistency in the classification of cell contents (which
is not exclusive of LO)

In any case the OP wanted a blank cell not a zero (unless he hid it using
Conditional Formatting as I suggested in a previous email)

--
View this message in context: 
http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3561959.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