https://bz.apache.org/ooo/show_bug.cgi?id=125636
Andreas Säger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Andreas Säger <[email protected]> --- (In reply to mroe from comment #2) > Have a look at issue 124654. > > *** This issue has been marked as a duplicate of issue 124654 *** This feature request has nothing to do with issue 124654 which was about the global locale and the number format locale to override the global one. IMHO, this request results from popular misconceptions about csv. The text import locale serves another purpose and it can not be overridden. It provides an interpretation schema for incoming text. 1. CSV is not a spreadsheet format. It is completely unrelated to spreadsheets even though many millions of users never load csv into any type of application other than spreadsheets. Valid csv is entirely about database exchange (record sets with equal number of fields of distinct types). 2. CSV must not make _any_ assumptions about formatting attributes. There are no number formats, date formats, text colors, row borders, fonts, font sizes or anything like that in a plain text file. In an ideal world all csv date/times would be ISO-date/times and all numbers would be decimals with digits, a minus sign for negative numbers and one decimal point where needed, but with no thousands-separators, currency symbols nor decimal separators other than point. Calc interpretes the incoming text snippets in the given context of the import locale set in the import dialog and then dumps the resulting numbers (and text) into a brand new unformatted spreadsheet which is not even derived from your default template. The only "formatting" that takes place is the formatting of number format "General" which displays all special numbers (dates, times, percent, currencies, booleans) in one particular number format, otherwise dates would be displayed as integers (what they actually are once they landed in a sheet). Number format "General" provides one number format for each subtype. I think, it is perfectly OK to not interprete any formatting attributes from incoming text. This automagic formatting would be extremely difficult to implement for many thousands of possible number formats. Furthermore, the uniform number format indicates clearly that the incoming text has been interpreted correctly. Formatting imported text data: 1) Use a template and then menu:Insert>Sheet_form_File. Then you can apply the template's cell styles within seconds. 2) Open the csv, copy all and paste-special data into a second, pre-formatted spreadsheet. 3) Use Base connected to a csv-directory and use pre-formatted import ranges (F4, drag&drop) 4) Some macro driven solution performing 1), 2) or 3) automatically. [Example] Loading CSV into preformatted spreadsheets https://forum.openoffice.org/en/forum/viewtopic.php?f=100&t=23727 [Tutorial] Using registered datasources in Calc: https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=18511 -- You are receiving this mail because: You are the assignee for the issue.
