[Techtalk] Re: Techtalk Digest, Vol 51, Issue 23

[Figaro]

Thank you..
I'll do that.
Well, yes 20k lines versus my paltry 3700- 5k (as of today) is 
moderately unimpressive. Still it represents a few months data mining , 
again unimpressive by your standards.
Additionally, in the asking one is rewarded with learning new ways to 
think........so,  elder dogs do learn new tricks!!
Thank you,
matthew



techtalk-request at linuxchix.org wrote:
> Send Techtalk mailing list submissions to
> 	techtalk at linuxchix.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://mailman.linuxchix.org/mailman/listinfo/techtalk
> or, via email, send a message with subject or body 'help' to
> 	techtalk-request at linuxchix.org
>
> You can reach the person managing the list at
> 	techtalk-owner at linuxchix.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Techtalk digest..."
>
>
> Today's Topics:
>
>    1. Re: Open Office Question (Mike)
>    2. mySql or saving files to disk, which is faster? (Mr. Hardy)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 25 May 2007 19:45:05 -0400
> From: Mike <kenziem at sympatico.ca>
> Subject: Re: [Techtalk] Open Office Question
> To: techtalk at linuxchix.org
> Message-ID: <200705251945.08041.kenziem at sympatico.ca>
> Content-Type: text/plain;  charset="iso-8859-1"
>
> On Wednesday 23 May 2007 6:09 pm, Figaro wrote:
>   
>> Hello all.
>> I have a big spreadsheet (3700 lines (about 14800 cells). I need to sort
>> the data in reference to contents (country name) of a row (eg: 3) to
>> generate a new listing.
>> Now the usual >data>sort>Argentina will sort everything nicely for
>> about 300 lines  the remainder is still sorted by first cell (alphabetic
>> name convention). I have tried moving to next line not sorted the issue
>> the >data>sort>... which again does something recognizable, however only
>> for the succeeding 300 lines, and not in respect to previous sorted
>> lines. So, I need help here. I am NOT a spreadsheet master, in fact
>> detest the things
>>     
>
> 3700 lines is not all that large, but given how slow OOCalc runs on my machine 
> it might take some time
>
> Have you selected ALL the rows you want to sort?  
>
> You could rearrange the data to put the sort field in the first column then 
> save it as a comma separated file (CSV)  and use
>
>  sort filename.csv > sortedfilename.csv  
>
> Then bring the files back into the spreadsheet.  I've used this method on 
> sheets that were 200,000  lines and needed to be sorted into several 
> workbooks
>
>