Re: [libreoffice-users] Sort problems

Hi :)
This sort of thing would work more easily in a database.  I take it that Calc is having the 
problems?  It might be possible to use Base to read the spreadsheet and then export to an external 
back-end that would really take care of the data and stop lines from being broken up in that way.  

However in Calc can you define a fixed area to be a database?  Is that something to do with 
pivot-tables or data-pilot or something?  

For the data-recovery aspect do you have a fairly recent version of your file on Usb-stick, or 
emailed to yourself or to someone else or backed-up on a local machine or somewhere on the network 
file-shares or saved to a Cloud while you were working on it from 2 places.  
Regards from 
Tom :)  






> ________________________________
> From: Carl Paulsen <carlpaulsen@comcast.net>
> To: "users@global.libreoffice.org" <users@global.libreoffice.org> 
> Sent: Tuesday, 14 May 2013, 18:47
> Subject: [libreoffice-users] Sort problems
>
>
> LO 4.0.3.3
>
> I've had some problems with sorting that may have cost me 6 hours of 
> work.  Wondering what's going on.
>
> Biggest problem is that when sorting and choosing to "expand selection" 
> it sometimes only expands to some of the columns of data.  Why would 
> this happen?  I noticed this after a while of working on a large data 
> file, and earlier sorts may have only sorted a portion of the sheet, 
> meaning I have to check and possibly re-create all of my work.
>
> Much less problematic, recently I'm sorting a sheet and it sorts not 
> only the column of data but also the columns themselves.  Since I'm 
> using vlookup a bunch, with static references (to work properly in my 
> case), this re-sorting will screw up the entire file.  I can't afford 
> the time to recreate the vlookups each time I sort.
>
> I didn't have latter this problem under 3.x.x
>
> Carl
> -- 
>
> Carl Paulsen
>
> 8 Hamilton Street
>
> Dover, NH 03820
>
> (603) 749-2310
>
>
> -- 
> 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