[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 --- Comment #15 from Jonny Grant --- Mike I wish opening a file with -MM-DD formatting would be retained when it is saved. Likewise for -MMM-DD I recall I always still see two digit year columns in exports unless I manually do stuff. Exporting years correctly and fully should be the default behaviour. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 --- Comment #14 from Mike Kaganski --- (In reply to Jean-Baptiste Faure from comment #5) > For example, its clear that the format of 2021-01-13 is -MM-DD, but for > 2021-01-12 you can't decide between -MM-DD and -DD-MM and there is > nothing in the CSV format that gives you a mean to decide. (In reply to Buovjaga from comment #8) > It is about loading as well. Like Jean-Baptiste said, you can't > automatically distinguish between -MM-DD and -DD-MM dates coming > from a CSV file Just wanted to mention, that unlike any other date layout, -XX-YY is the unambiguous one (-MM-DD), defined in ISO 8601; and no software would ever try to treat it another way. If someone would like to use -DD-MM, they would be on their own. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 --- Comment #13 from Mike Kaganski --- FTR: Typing file.csv in the MS Excel's Save As dialog (note how it's the *same* dialog that *actually allows* to save as CSV, unlike what comment 9 did!) having XLSX file type selected, I get a 'file.csv.xlsx' without warning. If I use double quotes to force the exact filename, and type "file.csv", I also got no warning, but I still get the XLSX with "wrong" extension. If I use the same procedure in Excel's Export dialog, I have similar results: no warnings, always get the file type selected in relevant dropdown, but when I use quoted filename, I get "csv" silently replaced with "pdf". In any case, the other major spreadsheet software vendor doesn't get convinced by Jonny Grant's "If I type "Untitled 1.csv" in the box, I expect it to save as CSV". -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 --- Comment #12 from Buovjaga --- (In reply to Jonny Grant from comment #11) > Hi Buovjaga > If I type "Untitled 1.csv" in the box, I expect it to save as CSV... As is > customary in all software. Feels like a bug. It should say "Error cannot > Export as CSV" right? I discussed this in the chat and one comment was "CSV as extension is not a file type, it's just three random characters that happen to coincide with something else". The thing is that dots are allowed in file names and it would be rather restrictive to error out on any "dot something" in the file name that doesn't match the currently selected export filter. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 --- Comment #11 from Jonny Grant --- Hi Buovjaga If I type "Untitled 1.csv" in the box, I expect it to save as CSV... As is customary in all software. Feels like a bug. It should say "Error cannot Export as CSV" right? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 --- Comment #10 from Buovjaga --- (In reply to Jonny Grant from comment #9) > That seems to work, some of the time > > If I do 'File'->'Export' it doesn't have that option. > > Another time I ended up with "Untitled 1.csv.html" > > I'm using 6.4.7.2 That's because you picked XHTML from File - Export. CSV files are saved from Save As. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 --- Comment #9 from Jonny Grant --- That seems to work, some of the time If I do 'File'->'Export' it doesn't have that option. Another time I ended up with "Untitled 1.csv.html" I'm using 6.4.7.2 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff ||ice.org Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #8 from Buovjaga --- (In reply to Jonny Grant from comment #6) > Hello > Thank you for your reply. > Politely I would say, maybe you have some misunderstanding - This bug is > about CSV export from Calc. It is not about loading CSV files. You can see > this in comment #1. It is about loading as well. Like Jean-Baptiste said, you can't automatically distinguish between -MM-DD and -DD-MM dates coming from a CSV file, so nothing in the export will guarantee a sensible import. "Save cell content as shown" is already in 6.4. You can access the filter options by ticking the box "Edit filter settings" in the file saving dialog before clicking Save. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 Jean-Baptiste Faure changed: What|Removed |Added Status|NEW |UNCONFIRMED Ever confirmed|1 |0 --- Comment #7 from Jean-Baptiste Faure --- Never confirmed -> back 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 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 Jonny Grant changed: What|Removed |Added Status|RESOLVED|NEW Ever confirmed|0 |1 Resolution|NOTABUG |--- --- Comment #6 from Jonny Grant --- Hello Thank you for your reply. Politely I would say, maybe you have some misunderstanding - This bug is about CSV export from Calc. It is not about loading CSV files. You can see this in comment #1. It's clearly inappropriate to export as a two digit year format. As a qualified software engineer it's astonishing to read your comments. It's vital this defect is fixed because it damages the quality of the dates when they are exported, so I am re-opening. Unfortunately Calc has many bugs, and none are fixed. If they can't be resolved, maybe it's time for users to migrate to a more modern spreadsheet. -- 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 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 Jean-Baptiste Faure changed: What|Removed |Added CC||jbfa...@libreoffice.org Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #5 from Jean-Baptiste Faure --- (In reply to Jonny Grant from comment #4) > [...] > Although, it's quite a manual process to require us to set a sensible format > before saving dates. This is basically a millennium bug still existing in > Calc. I disagree, it is up to the user to choose the date format suitable for his purpose. The year coded with 2 digits may be ambiguous or not, depending the meaning of the data. If your data is about genealogy using 2 digits for the year is a very bad idea. If your data are about your bank account, there is not ambiguity about a 2 digits year. I think there is another problem with your request. It is like if you wanted that the date value reveals its date format. That is not possible with CSV format. For example, its clear that the format of 2021-01-13 is -MM-DD, but for 2021-01-12 you can't decide between -MM-DD and -DD-MM and there is nothing in the CSV format that gives you a mean to decide. The only mean is to put yourself the date format information in the header of the date column. Calc can't do that work for you because it knows nothing about the meaning of the data. So for me there is no bug here and I close this bug report as Not-A-Bug. Please feel free to reopen if you disagree. 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 https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||109237 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109237 [Bug 109237] [META] CSV export bugs and enhancements -- 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 139414] Calc exports CSV dates as 11/10/09 Millennium Bug
https://bugs.documentfoundation.org/show_bug.cgi?id=139414 Jonny Grant changed: What|Removed |Added Summary|Calc exports CSV dates as |Calc exports CSV dates as |11/10/09|11/10/09 Millennium 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