Re: [libreoffice-users] treatment of blank cells

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