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

2011/12/3 Pedro <pedlino@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)
>
> 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: 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