https://bugs.documentfoundation.org/show_bug.cgi?id=130745
--- Comment #7 from [email protected] <[email protected]> --- 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.
