[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added Status|REOPENED|RESOLVED Whiteboard|BSA |BSA target:4.2.5 Resolution|--- |WORKSFORME --- Comment #11 from Kohei Yoshida libreoff...@kohei.us --- I just re-tested this using 4.2.5 (on Windows), and the date values get imported as dates, and the sort works as expected. I didn't even have to change the column date type in the CSV dialog, but I did check the Detect special numbers option. I'm in US English locale, same as the initial reporter. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 Jean-Baptiste Faure jbf.fa...@sud-ouest.org changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |WORKSFORME CC||jbf.fa...@sud-ouest.org --- Comment #9 from Jean-Baptiste Faure jbf.fa...@sud-ouest.org --- Works as expected if you choose the right column type in csv import dialog. Why do you want that Calc thinks for you? Closing as WorksForMe. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 Tomaz Vajngerl qui...@gmail.com changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|WORKSFORME |--- --- Comment #10 from Tomaz Vajngerl qui...@gmail.com --- (In reply to comment #9) Works as expected if you choose the right column type in csv import dialog. Why do you want that Calc thinks for you? Because there are things like locale settings which know the date format I am using and should also use this date format by default at import. I should not need to set the column type unless the date is in another date format than expected. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 --- Comment #8 from Peter Beurle peter.beu...@bigpond.com.au --- This is now working for me in Windows on 4.1.2, should it be closed now? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 --- Comment #7 from yagolf yagonuch...@hotmail.com --- I can confirm this bug in LibreOffice 4.1.1.2 Build ID: 410m0(Build:2) on Linux Mint 13 64bit running the Gnome Shell. I've tried importing with different encodings (UTF-8, Western Europe (ISO-8859-2) and Western Europe (ASCII/US). I've also tried using different locales (though only English-US and English-UK, the latter being my default one), and 'detecting special characters', and still dates are not imported correctly no matter how you format the data (or without formatting it at all) Very annoying as it forces me to reboot into Windows and use Excel just to get this done properly -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 peter.beu...@bigpond.com.au changed: What|Removed |Added CC||peter.beu...@bigpond.com.au --- Comment #6 from peter.beu...@bigpond.com.au --- I am able to reproduce the date import problem in version 4.1.1, as per comment 4. It works correctly Windows 3.6.1 and 4.0.1 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 Tomaz Vajngerl qui...@gmail.com changed: What|Removed |Added CC||07ebb...@opayq.com --- Comment #5 from Tomaz Vajngerl qui...@gmail.com --- *** Bug 68265 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 --- Comment #1 from Atlanta Office Solutions john.bu...@atlantaofficesolutions.com --- I forgot to mention that if you attempt steps 1-4 and then try to format the column, it still does not sort. Only when the formatting is done on the initial import screen does it work. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 Eike Rathke er...@redhat.com changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #2 from Eike Rathke er...@redhat.com --- Seems that in your Windows environment the dates are imported as text and not interpreted as dates because the environment is not set to English (USA). Date recognition depends on the locale, or setting the column to an explicit Date(M/D/Y) type as you mentioned. Ensure that in the Text Import dialog the locale is set to one that matches the expected data, in this case for example English (USA). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 Eike Rathke er...@redhat.com changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 --- Comment #3 from Atlanta Office Solutions john.bu...@atlantaofficesolutions.com --- Language recognition was the first thing I looked in to. The Windows 7 machine is using 'Default - English (USA)' as the language. LibreOffice did seem to want to default to 'System' as the character set on the import screen. I changed this to Western Europe (Windows-1252/WinLatin1) to match the settings on the Windows XP machine. I see your point, but that does not negate the bug request. This operation works correctly on other Windows / Linux platforms and also works correctly with MS Office 2007 on the same Windows 7 machine. The quirk is in the date recognition abilities of LibreOffice. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68108] FORMATTING: LibreOffice Calc - Date Sorting Issue
https://bugs.freedesktop.org/show_bug.cgi?id=68108 Tomaz Vajngerl qui...@gmail.com changed: What|Removed |Added Status|CLOSED |REOPENED Resolution|NOTABUG |--- CC||qui...@gmail.com Ever confirmed|0 |1 --- Comment #4 from Tomaz Vajngerl qui...@gmail.com --- I played around with dates in CSV and for me standard never detected the date correctly as a date (only as text) no matter what locale or date format I chose in setting or system. It only detected it correctly if I manually changed the column from standard to the appropriate date format. I tried 4.0 or master on Linux and Windows 7. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs