Hi, I am having complications with importing .csv files into a spreadsheet.
The Locale is set to German (Germany) during import.
First problem should be quite simple. The .csv data has a column containing values with currency symbol (€), this is always imported as text. After running text to columns it recognizes that value and formats it with the currency symbol. How could I make Calc do this 2nd step during import?
The second problem is with dates in german standard formatting (DMY and a dot as delimiter).
To make Calc recognize the column as date values I have to choose Column type Date (DMY) on every import. Column type standard imports it as text. The locale already gives advice how a date could possibly be formatted so I think I am missing something. I do not have these troubles while working with Excel.
How could the .csv import be easier for me at these points?
