2011/12/3 Pedro <[email protected]>: > > 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) >> > > There are at least two ways: add an extra IF to the following formula and > use ISTEXT to validate or replace SomethingNiceToPutHere by 0 (zero) and use > conditional formatting to hide the zeros (set the font to White or the cell > background color when the value is zero) > > If you liked the way it worked before you can use =N() as suggested by > Miguel Angel.
Seems like the N() function is the best solution in this case then. Using a test every time I want to use a cell that MIGHT be an empty string would make my formulas ridiculously long, and most of them are quite long already. Another solution would of course be to create a new cell formula with LibreOffice Basic, that takes care of everything, but I guess it would be rather slow, which I think would be noticeable in my case since I we are talking about thousands of rows here. The answer I was hoping for in this case, about if there was a way to make a cell look empty, was that there is maybe some function to use or something, something like EMPTYCELL(): =IF(Something;EMTYCELL();AnotherCell+AThirdCell) Which is not a good idea, because if I empty the cell, I guess its formula will be erased too… :P Well, never mind, I think I'll go with N() anyway now. Short and simple. 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
