[Libreoffice-bugs] [Bug 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #18 from Mike Kaganski --- (In reply to tes from comment #13) > CSV *IS* plain text! Nothing else. Use XML, DBF or something else if you want > formated columns. This is bullshit. 1. If you treat CSV as plain text and nothing else, then please *DON'T* use spreadsheet software to work with it. 2. If you can give such bold advises as to "Use thos or that if you want formated columns", then please be so kind to force different external bodies (like banks and governments) that user doen't have much influence to stop offering numeric tabular data in CSVs. -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 Mike Kaganski changed: What|Removed |Added Resolution|--- |WONTFIX Status|REOPENED|RESOLVED --- Comment #17 from Mike Kaganski --- I close this as WONTFIX, because I have described the reason behind the default behavior. We *won't* change the default in a way that will harm more people than those who would benefit. -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #16 from Mike Kaganski --- Please use "Format quoted field as text" checkbox to treat quoted values as text. See https://help.libreoffice.org/latest/en-US/text/shared/00/0208.html#hd_id314847422. (In reply to tes from comment #10) > > ...Without treating unquoted numbers as numbers, > > you would simply have *all* data from CSV as text - because, well, initially > > that's all text. > > In my opinion the best default setting. The best *default* setting is the one that works best for most cases for non-techy majority of users. Fir them, opening a CSV and being unable to sum values would be unexpected. Given the wast variety of in-the-wild CSV flavors, with huge inconsistencies and nuances, we provide defaults targeted at that group, and versatile dialog with telling labels. People who can read RFCs are expected to be able to guess the meaning of "Format quoted field as text". -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #15 from t...@backlog.de --- (In reply to Oliver Brinzing from comment #14) > Created attachment 145769 [details] > screenshot comparing excel 2016 and lo 6.1.3.1 csv import > > attached screenshot shows result for excel and lo csv import. > > to make excel import csv data, i had to replace comma , with semicolon ; Dear Oliver, very nice. Additionally MS decided ; is better than ,. Bullshit on top. The MS behavior seems to be the same compared to LO. Both systems changes content automatically on loading where they don't have to do. -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #14 from Oliver Brinzing --- Created attachment 145769 --> https://bugs.documentfoundation.org/attachment.cgi?id=145769=edit screenshot comparing excel 2016 and lo 6.1.3.1 csv import attached screenshot shows result for excel and lo csv import. to make excel import csv data, i had to replace comma , with semicolon ; -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 t...@backlog.de changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|NOTABUG |--- --- Comment #13 from t...@backlog.de --- Never change data *automatic* on importing by a glance in the crystal. CSV *IS* plain text! Nothing else. Use XML, DBF or something else if you want formated columns. -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #12 from t...@backlog.de --- (In reply to BogdanB from comment #11) > Created attachment 145764 [details] > Video showing how can the import can be made keeping all text > > In this video you can see that Libre Office offer you the chance to keep the > second column as text. > > Please see the video. > > So this is not a bug. Dear Bogdan, thanks for your effort, creating the video. I already knew this "solution". I'm speaking about the default handling. The other way around is a shoe out of it. In my opinion the "default" has to be *text*. *NO* automatic interpreting/formating of data to import. -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 BogdanB changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 BogdanB changed: What|Removed |Added CC||bogdan...@gmail.com --- Comment #11 from BogdanB --- Created attachment 145764 --> https://bugs.documentfoundation.org/attachment.cgi?id=145764=edit Video showing how can the import can be made keeping all text In this video you can see that Libre Office offer you the chance to keep the second column as text. Please see the video. So this is not a 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #10 from t...@backlog.de --- (In reply to Mike Kaganski from comment #3) > (In reply to tes from comment #2) > > 1) > > Sry, the imported values *are* quoted. > > This is what should have been stated from the start; please provide a sample > to test; and also mention which settings are active in the CSV import > dialog. Mention your version information (as per Help->About LibreOffice). > Your initial description haven't mention that, and values in examples were > unquoted. Sry for my inaccuracy. > ...Without treating unquoted numbers as numbers, > you would simply have *all* data from CSV as text - because, well, initially > that's all text. In my opinion the best default setting. thank you for your attention -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #9 from t...@backlog.de --- Created attachment 145759 --> https://bugs.documentfoundation.org/attachment.cgi?id=145759=edit ImportDlg -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #8 from t...@backlog.de --- Created attachment 145758 --> https://bugs.documentfoundation.org/attachment.cgi?id=145758=edit Versioninfo -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #7 from t...@backlog.de --- Created attachment 145757 --> https://bugs.documentfoundation.org/attachment.cgi?id=145757=edit example3 -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #6 from t...@backlog.de --- Created attachment 145756 --> https://bugs.documentfoundation.org/attachment.cgi?id=145756=edit example2 -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 t...@backlog.de changed: What|Removed |Added Attachment #145754|0 |1 is obsolete|| --- Comment #5 from t...@backlog.de --- Created attachment 145755 --> https://bugs.documentfoundation.org/attachment.cgi?id=145755=edit example1 -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 --- Comment #4 from t...@backlog.de --- Created attachment 145754 --> https://bugs.documentfoundation.org/attachment.cgi?id=145754=edit examples and sysinfo -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 Mike Kaganski changed: What|Removed |Added Status|REOPENED|NEEDINFO --- Comment #3 from Mike Kaganski --- (In reply to tes from comment #2) > 1) > Sry, the imported values *are* quoted. This is what should have been stated from the start; please provide a sample to test; and also mention which settings are active in the CSV import dialog. Mention your version information (as per Help->About LibreOffice). Your initial description haven't mention that, and values in examples were unquoted. Provided that information, we could try to understand if that is wrong behavior, but I don't get your following question: > 2) > Who invented your default behavior? Well - *if* you argue with me on the grounds that I declared it correct to convert *quoted text* looking like numbers - then you are arguing with what has never been declared here. If, however, you tell me that you have doubts in logic behind converting *unquoted* numbers to numbers - then I simply fail to understand your logic. Without treating unquoted numbers as numbers, you would simply have *all* data from CSV as text - because, well, initially that's all text. RFC 4180 does not specify any treatment of data inside the records, it only tells about syntax. -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 t...@backlog.de changed: What|Removed |Added Ever confirmed|0 |1 Resolution|NOTABUG |--- Status|RESOLVED|REOPENED --- Comment #2 from t...@backlog.de --- 1) Sry, the imported values *are* quoted. 2) Who invented your default behavior? 3) In my opinion importing should never change values by default ("0054320" -> 54320) 4) see also RFC 4180 -- 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 120630] Importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=120630 Mike Kaganski changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #1 from Mike Kaganski --- This is not a bug. CSV is a plain-text format for data interchange. If some value in it may be interpreted as number, and not quoted, then *by default* it should be treated as number, which happens here. It doesn't matter if previous line contained a text in that position: that night be a table header, or some intermediate summary. If you need to have some column treated as text, just right-click the relevant column title *at CSV import dialog*, and select "Text". Closing NOTABUG. Please feel free to reopen if you disagree; if so, then please describe your reasons. -- 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