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 <[email protected]> >To: Steve Edmonds <[email protected]> >Cc: Virgil Arrington <[email protected]>; [email protected] >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, [email protected] 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: [email protected] >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: [email protected] 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
