https://bugs.documentfoundation.org/show_bug.cgi?id=130745
--- Comment #8 from Mike Kaganski <mikekagan...@hotmail.com> --- (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.
