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.knu...@gmail.com> wrote: From: Johnny Rosenberg <gurus.knu...@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+h...@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+h...@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