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

Hi :)
Are the empty cells somehow defined as text-cells?  Do they contain a space or a ' mark or 
formatted to be text?
Regards from
Tom :)

--- On Sat, 3/12/11, Johnny Rosenberg <gurus.knugum@gmail.com> wrote:

From: Johnny Rosenberg <gurus.knugum@gmail.com>
Subject: [libreoffice-users] Stuck with 3.3 forever?
To: "LibreOffice Användare" <users@global.libreoffice.org>
Date: Saturday, 3 December, 2011, 17:10

I installed Ubuntu 11.10 from scratch today on my Eee-PC and found
that the installed version of LibreOffice was 3.4.4 (my old install
had 3.3.4, which I installed from the deb files at the LibreOffice
download page).
One of the differences I noticed between 3.4.4 and 3.3.4 is that 3.4.4
can't calculate with empty cells, which I find horrible and very
surprising.

For instance, I have this formula in one cell (E10), copied to a
couple of thousands of cells in the same column:
=IF(OR(DAY(A11)>DAY(A10);C10="");"";IF(OR(B10="Lunch";B10="Läkarbesök");E9;C10+E9))

Depending on the value in other cells, the result can be a time or an
empty string (""). In this case, E9 is an empty string, so E10 becomes
”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because
of this.

Seems like the developers decided that it shouldn't be possible to use
empty cells for calculation, and I just can't help myself wondering
why. This is a very common task in my case, and if an empty cell is
not defined as 0, it will mean that most of my formulas will be very
much longer and way more complicated than they need to be with 3.3.
That is, more complicated, harder to edit and very much slower. Is
this really the best way to go? Why is handling an empty cell as 0 in
calculations such a bad idea? Am I stuck with 3.3 like forever ow or
is this going to change any time soon?



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

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