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


Hi :)
I have quite a few machines on a really old version too but really should upgrade soon.  I 
downloaded the 4.0.4 but now might as well do the 4.0.5 instead.  

Regards from 

Tom :)  





________________________________
From: Gregory Smith - Oracle Sparc Verification <greg.a.smith@oracle.com>
To: Steve Edmonds <steve.edmonds@ptglobal.com> 
Cc: Virgil Arrington <cuyfalls@hotmail.com>; users@global.libreoffice.org 
Sent: Tuesday, 20 August 2013, 15:27
Subject: Re: [libreoffice-users] treatment of blank cells


Sorry, my version is 3.4.5.
On 08/20/13 04:02, Steve Edmonds wrote:
If I put 5,4,,,3,,2,1 in afile.csv and open it in LO3.6 I can then put 
the equation =b1*c1 in an empty cell and the result is 0.

Do you not get that. What version of LO.
steve
On 2013-08-20 15:07, greg.a.smith@oracle.com wrote:
So the cells are the result of opening a .csv file where the string 
has nothing between commas such as

5,4,,,3,,2,1
between the consecutive commas is nothing, so the cell should be made 
totally empty.

gs

On 8/19/2013 8:22 PM, Steve Edmonds wrote:

On 2013-08-20 13:02, Virgil Arrington wrote:
On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification 
wrote:
  I am disappointed that Libre Office does not treat blank cells as 
a zero in math calculations. I have a dozen spreadsheets from 
Excel and Open Office that take advantage of this fact.  Now I get 
errors with Libre Office. Going back and retrofitting n(cell 
reference) to achieve the translation is a ton of extra work.  Am 
I missing something.

gs



I'm not sure what you're missing, but my LO spreadsheets always 
treat blank cells as zeros. I'm not that well versed in 
spreadsheets, but I've never had the problem you describe.

Virgil 
I have just tried in LO 3.6 and a blank cell is treated as zero. A 
cell with text in it such as a space causes an error in 
calculations. Do you mean that Excel and Open Office treat white 
space characters as zero.
Steve






-- 
To unsubscribe e-mail to: users+unsubscribe@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



-- 
To unsubscribe e-mail to: users+unsubscribe@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.