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 carlpaul...@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+unsubscr...@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+unsubscr...@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