[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 Xisco Faulí changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED CC||xiscofa...@libreoffice.org --- Comment #19 from Xisco Faulí --- (In reply to c319chris from comment #17) > To put it into words, all you have to do is check "Detect special numbers" > when importing — nothing else — and it works OK. Glad you found a solution. Closing as RESOLVED NOTABUG -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #18 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #17 from c319ch...@aol.com --- To put it into words, all you have to do is check "Detect special numbers" when importing — nothing else — and it works OK. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #16 from elmau --- You can see my file in video: https://bug-attachments.documentfoundation.org/attachment.cgi?id=158754 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #15 from c319ch...@aol.com --- All works will if the dates are typed in manually rather than imported. Please describe in words the proper way to import the .csv file rather than making us figure it out from a screen shot. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #14 from m.a.riosv --- Created attachment 158804 --> https://bugs.documentfoundation.org/attachment.cgi?id=158804=edit Screenshot about how to impor properly With the screenshot another configuration of the import window, that works fine. Sorry but I can't find a bug here, only needs to set up adecuactly the import configuration. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #13 from c319ch...@aol.com --- Follow these steps: File -> New -> Spreadsheet to make new destination spreadsheet. Double click on .csv file to open it. Click "OK" on text import window. Copy and paste cells into new spreadsheet, including "Date" column. Select column A. Click on Format -> cells. Note that column is formatted as "Number". Select "Date" and choose any date format. Program inserts apostrophes ahead of all date values. See formula bar to see this as the apostrophe is not visible in cells. Cells have now been reformatted as text due to leading apostrophe ahead of date value. Selecting "Format -> Cells", the cells are formatted as "Date" but are actually text due to apostrophe as first character. As text the dates cannot be correctly sorted. Note also that selected date format is not applied when cell values are converted to text. Selecting "Friday, December 31, 1999" has no effect. Cells are retaining original date format. Remember, cells were originally formatted as "Number", not "Text". Reformatting cells as "Number" does not remove apostrophes, leaving cells as Text. Apostrophes must be removed manually, cell by cell. The crux of the problem is that cells are being reformatted as text, not date. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #12 from elmau --- Look my GIF file, I recorded process. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #11 from c319ch...@aol.com --- << 1) Open your file XLS << 2) Import your file CSV << 3) Copy and paste from CSV to XLS That's exactly what I've been doing. I tested it before filing this bug report. I will try it again to make sure, but there is something wrong that is causing the dates in the xls I attached to be sorted incorrectly. Even though you can't reproduce it it is definitely a problem for me. Look at the years. I flagged the mis-sorted rows in the xls file I attached. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #10 from elmau --- Created attachment 158754 --> https://bugs.documentfoundation.org/attachment.cgi?id=158754=edit Test for this bug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #9 from elmau --- I try... 1) Open your file XLS 2) Import your file CSV 3) Copy and paste from CSV to XLS Work fine, please, verify your process for import CSV. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #8 from c319ch...@aol.com --- The .csv file is opened with Libre Office and is copied/pasted into the .xls file, also using Libre Office. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #7 from m.a.riosv --- Because are not properly imported, have been the import done with LibreOffice? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #6 from c319ch...@aol.com --- Created attachment 158732 --> https://bugs.documentfoundation.org/attachment.cgi?id=158732=edit DateBug.xls file Attached .xls file shows mis-sorted dates. Dates were copied from a .csv file and pasted into the .xls file. You can see the dates are not properly sorted. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 --- Comment #5 from m.a.riosv --- Using English USA language for import it's fine for me, I don't need select the date column type. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #4 from elmau --- Created attachment 158725 --> https://bugs.documentfoundation.org/attachment.cgi?id=158725=edit Tes csv bug File CSV is import correctly. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #3 from elmau --- I can't reproduce bug. Version: 6.4.1.2 Build ID: 4d224e95b98b138af42a64d84056446d09082932 CPU threads: 8; OS: Linux 5.5; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #2 from c319ch...@aol.com --- Created attachment 158724 --> https://bugs.documentfoundation.org/attachment.cgi?id=158724=edit Sample .csv file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131377] Not Sorting Dates Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=131377 --- Comment #1 from elmau --- Please, attach file CSV for test. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs