[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

Am 10.09.2012 19:40, Andreas Säger wrote:
> Base is our database component. It is very, very underdeveloped,
> nevertheless underestimated. Even the worst database tool does a better
> database job than the best spreadsheet can do.

Since nobody ever uses Base for plain text databases, here is another 
approach without Base and without macro programming:
1) Prepare a sheet template and format entire columns to your liking, 
according to the incoming fields.
2) Open the text file in a text editor.
3) Copy all.
4) Open a new spreadsheet from the prepared template, paste and fill out 
the text import dialog (US English, special numbers, delimiter).



--
For unsubscribe instructions e-mail to: users+help@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