Re: [libreoffice-users] treatment of blank cells

No I don't get zero I get a  or #VALUE! error message.

gs
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