[Libreoffice-bugs] [Bug 130745] FILEOPEN: Calc not honoring import text dialog column type for empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=130745 --- Comment #8 from Mike Kaganski --- (In reply to rscra...@gmail.com from comment #7) > There are many examples online of people asking how to avoid having Calc set > formatting to dates when opening a CSV, and the responses always say to use > this setting in this dialog. Here is an example: > https://ask.libreoffice.org/t/how-do-i-format-a-column-of-calendar-dates-in- > calc/55289. It appears, then, that preventing formatting a column as date is > the expected behavior of setting the type to text. It is completely wrong interpretation. It confuses *formatting* (visual representation of data in a cell in Calc, defined by applied format string) with *data type* (the internal data stored in a cell, which may be a formula, a number, a text). The import dialog defines how Calc converts CSV text in specific fields into its data (i.e., it affects the resulting *data type*); but formatting is orthogonal, and is only used to show *converted*, already recognized data (such as, when a date is recognized, and converted to a serial date - i.e., a number of days since epoch, - it is also *formatted* in the Calc cell as a date, to not show numbers like 44562 where user expects 2022-01-01). The cited question does not ask about "how to avoid having Calc set formatting to dates when opening a CSV". In addition to wanting something opposite, the main thing there - again - is not wanting any *formatting*, but wanting correct *data type import*, even though the user clearly also confuses the concepts. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130745] FILEOPEN: Calc not honoring import text dialog column type for empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=130745 --- Comment #7 from rscra...@gmail.com --- If type of data is column-specific, and format is matched to data type, then shouldn’t the entire column be given the same format? Regardless of the philosophy behind settings in the dialog, there is a clear usability problem: someone who loads in data from a CSV file and then tries to edit those data in Calc will sometimes end up with corrupted data. There are many examples online of people asking how to avoid having Calc set formatting to dates when opening a CSV, and the responses always say to use this setting in this dialog. Here is an example: https://ask.libreoffice.org/t/how-do-i-format-a-column-of-calendar-dates-in-calc/55289. It appears, then, that preventing formatting a column as date is the expected behavior of setting the type to text. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130745] FILEOPEN: Calc not honoring import text dialog column type for empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=130745 Mike Kaganski changed: What|Removed |Added CC||er...@redhat.com --- Comment #6 from Mike Kaganski --- (In reply to rscra...@gmail.com from comment #3) > The fact that the dialog says "column type" suggests that it is a bug. No. The dialog helps Calc to recognize the type of data in CSV, not format the sheet. So the dialog talks about type of *CSV* column (the data), not Calc column (the formatting). Compare e.g. the other "column format" value, which is Date (DMY). Marking a column that way absolutely doesn't mean that the column will be formatted to show day, month and year in that order. It only means that the original data format should be expected like that. Then Calc can recognize the dates, and after that, it will represent them as current locale requires (which may be e.g. YMD or MDY). And if the column marked as DMY will happen to have a plain number, it will not be displayed as corresponding serial date. I suppose that it would be harmful to implement such a proposal, since it would try to mix (and thus dilute, make less clear) the distinction between import data format and resulting sheet formatting. IMO->WF -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130745] FILEOPEN: Calc not honoring import text dialog column type for empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=130745 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||79045_79...@mail.ru, ||mikekagan...@hotmail.com Blocks||109239 --- Comment #5 from Roman Kuznetsov <79045_79...@mail.ru> --- Interesting. In Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: b438854a0b5148880e455cbeeff14d4e3d825711 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL Jumbo I got a general Numeric type for all imported cells. The Calc guide says us that "Text" in that case means Calc just imports the data from a CSV file as text but not as date or currency. And it's all. I don't see there that cells with data in Calc after import should have a text format. Mike, what do you think about this bug report? May be it's really an enhancement? Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109239 [Bug 109239] [META] CSV import and export dialog bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130745] FILEOPEN: Calc not honoring import text dialog column type for empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=130745 --- Comment #3 from rscra...@gmail.com --- The fact that the dialog says "column type" suggests that it is a bug. The behavior is unexpected and can lead to data loss for people who expect that they are setting a 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 130745] FILEOPEN: Calc not honoring import text dialog column type for empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=130745 --- Comment #2 from Oliver Brinzing --- Created attachment 157986 --> https://bugs.documentfoundation.org/attachment.cgi?id=157986=edit test csv import 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 130745] FILEOPEN: Calc not honoring import text dialog column type for empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=130745 Oliver Brinzing changed: What|Removed |Added OS|Windows (All) |All Version|6.3.4.2 release |Inherited From OOo CC||oliver.brinz...@gmx.de Hardware|x86-64 (AMD64) |All Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #1 from Oliver Brinzing --- (In reply to rscra...@gmail.com from comment #0) > Actual Results: > All cells with contents will be text type. All cells without contents will > be numeric type. confirming, but not sure if this can be seen as a bug or an enhancement request. Maybe an option, e.g: [ ] Format empty cells with choosen column type format could be added ? -- 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