Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


2011/12/3 Tom Davies <tomdavies04@yahoo.co.uk>:
Hi :)
Are the empty cells somehow defined as text-cells?  Do they contain a space or a ' mark or 
formatted to be text?

Depends on the situation, but I found that entering ="" into a cell
causes different results from 3.3.4 vs 3.4.4.
So why do that? you might ask. Well, the formulas in a column looks
something like =IF(SomeCase;"";IF(AnotherCase;SomeResult;SomeResult+TheCellAbove)),
so here and there, there will be cells that are equal to ="", and in
some cases those cells will be used for calculation with the same
formula.


Kind regards

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


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

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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.