No I don't get zero I get a or #VALUE! error message.
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.
On 2013-08-20 15:07, firstname.lastname@example.org wrote:
So the cells are the result of opening a .csv file where the string
has nothing between commas such as
between the consecutive commas is nothing, so the cell should be made
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
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.
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.
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.
To unsubscribe e-mail to: email@example.com
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
- [libreoffice-users] Re: treatment of blank cells (continued)
Impressum (Legal Info)
: 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