2011/12/5 Pedro <[email protected]>: > > 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: [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
