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 <[email protected]> >To: "[email protected]" <[email protected]> >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: [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
