Description: Please extend the use of RecalcOptimalRowHeightMode to work for CSV imports. Steps to Reproduce: 1. Import a CSV file 2. 3. Actual Results: Adjusting row height happens taking a very long time for large CSV files. Expected Results: Row height adjustment is user configurable just like ODF and XLS file opens. Reproducible: Always User Profile Reset: No Additional Info: N/A
How to?, CSV is imported as unformatted text, what it is.
Not sure why you are asking how to, when I import some CVS files with wide text columns or text columns that include new line characters, Calc first imports the CSV files then spends time "adjusting the row heights" according to the status message at the bottom of the window. The some rows of the CVS files end up being marked as 39.37" high, and scrolling in Calc is brain damaged such that you get large jumps and can't review them at all. Since there is no inherent height information in the CSV file, Calc is the one actor performing this behavior. It seems readily analogous to that being done when reading an ODF or XLS file.
But these adjustments are not by the format, only length and new lines, something that LO knows when importing. But there is no format on the csv text, like bold e.g. The only thing is to apply the style you need to the data, by modifying one that already exist or creating a new one. Even you can modify default style. Maybe better create a template just for that, first create a new file with that template then use Menu/Sheet - Insert sheet - Insert sheet from file - External links for the two first you can set up it as link, so an update is possible., without recreated the import.