Bug 33817 - Sorting issue from csv file
Summary: Sorting issue from csv file
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: Other macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-01 10:50 UTC by daniel
Modified: 2011-10-31 11:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description daniel 2011-02-01 10:50:11 UTC 
I imort a csv file which has a few columns. One of the columns is a date in the format dd.mm.yyyy but on import it is formatted as text. I sort the document based on date column hoping/expecting it be sorted chronologically but instead I get this

04.05.2010
04.06.2009
05.02.2010
05.06.2009
05.07.2010


I have been using openoffice for a few years now and its only with the latest release of openoffice and this release of libreoffice that I run into this.

I have tried changing the text to date format but that makes no difference. It only adds ' infront of text.

What is the problem here?
Comment 1 Kohei Yoshida 2011-02-01 10:57:24 UTC 
Try checking "Detect special numbers" in the CSV import options dialog.  That will likely detect those date strings and turn them into date numbers.
Comment 2 daniel 2011-02-01 11:27:15 UTC 
Thank you this worked.
Comment 3 Kohei Yoshida 2011-02-01 11:33:26 UTC 
Good to hear that.  Closing.
Comment 4 Paulo Cheadi Haddad Filho 2011-03-13 12:38:55 UTC 
Hey!

I checked "Detect special numbers" in the CSV import options dialog but it keeps sorting lexicographically.
Comment 5 Paulo Cheadi Haddad Filho 2011-03-13 12:45:47 UTC 
(In reply to comment #4)
> Hey!
> 
> I checked "Detect special numbers" in the CSV import options dialog but it
> keeps sorting lexicographically.

Sorry, I left some details behind.

I have

01/09/2010 12:35:06 AM
01/09/2010 7:43:34 PM
01/09/2010 7:44:35 PM
01/11/2009 5:50:28 PM

"Sort" command did this.

I know that a "workaround" is to set date format to YYYY/MM/DD, but I didn't want that. Besides, I guess it should be expected the correct time sorting but lexical one.

Still, are there any chances in locale settings affecting this?
Comment 6 Cor Nouws 2011-10-31 11:44:51 UTC 
Hi Paolo,

(In reply to comment #5)

> Still, are there any chances in locale settings affecting this?

I think it is better to ask on the user list to find out what can be done with these settings.
Kind regards,
Cor