Re: [libreoffice-users] treatment of blank cells

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