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

As I said before, getting the date into a spreadsheet as a date was the
problem.  Once there, I am able to format the data as required.

CSV was just an example. I get the data in just about any format (raw
(unformatted), comma delimited, tab delimited, xls, xlsx, doc, docx, txt,
pdf, etc. Even with the xls I sometimes get dates and numbers in text
format.

If all the sources would be willing to enter their data into a database,
then a database would be useful as the data would then be of a fixed layout
with a fixed structure.



--
View this message in context: 
http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4007127.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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