https://bugs.documentfoundation.org/show_bug.cgi?id=130745
Mike Kaganski <mikekagan...@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |er...@redhat.com --- Comment #6 from Mike Kaganski <mikekagan...@hotmail.com> --- (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.