Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.