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

2011/12/5 Pedro <pedlino@gmail.com>:
> 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)

Correct. About that conditional thing, I don't think it's possible,
since I already use it for other purposes (drawing lines to separate
groups of cells automatically). Well, it's probably possible, but I
would have to create a lot of styles to match every combination of
what I have now and visible/invisible contents, and I'm not sure three
different conditions will be enough. It seems more complicated than
using N() in any case, I think.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
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