Re: [libreoffice-users] treatment of blank cells

Hi :)
If you need to put 0s in between commas then it might be possible without even opening the file, 
and might be fairly easy to apply to a shed load of files all very quickly after each other.  

In Gnu&Linux i suspect something like 

cp file-name.csv | grep(?) (replace ",," with ",0," > file-name-0s.csv

although as you can see i'm not sure grep is right or what would follow it.  

Stars instead of parts of the file-name would act as wild-cards meaning it would act on all such 
files that kinda match.  

I'm more of a point&click user so the command line is usually a bit 
of a mystery but i think it might be perfect for doing that sort of 
thing very quickly.  
Regards from 
Tom :)  







> ________________________________
> From: "greg.a.smith@oracle.com" <greg.a.smith@oracle.com>
> To: Steve Edmonds <steve.edmonds@ptglobal.com> 
> Cc: Virgil Arrington <cuyfalls@hotmail.com>; users@global.libreoffice.org 
> Sent: Tuesday, 20 August 2013, 4:07
> Subject: 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
-- 
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