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