When you open a csv file, it will determine the column width based on the contents. If there is a lot of text in say the first column (say a couple of hundred characters), that col will be very wide, often wider than my screen, which is not so easy to work with. The way I currently solve this: - Select all by clicking left top corner of the spread sheet - Right click on one of the column headers - Select Column Width - Default value, so that all columns will take on the default width. Would be nice if instead, calc would just open csv files using the default column width (I think ms excel does this), or maybe use a max column width instead.
I think a max makes more sense, many users (myself included) like that it auto adjusts but I think there should be a max width so that if it's greater than this it either a) defaults to default b) sets itself at the max width. Marking as NEW as it's confirmed.
Wide columns being "not so easy to work with" is a bit of an understatement; they trigger some bugs which make it impossible to scroll or resize columns with the mouse. See Bug 57361.
I run into this old bug all the time. Are there plans to solve it ? A single long cell in a CSV file screws up all the formatting. Rather than using a max on all cells width, maybe the width should be set to the 90th percentile of widths, and never be set above a certain threshold.
Bump this bug. This one is still present in latest LibreOffice.
*** Bug 141380 has been marked as a duplicate of this bug. ***
Created attachment 174301 [details] Proposed solution (limited column length) Could this be an acceptable solution? Just limit the amount of shown characters in the columns.
Another solution could be that the length of the string is determined by the first encounter of the end of line, but then the height of the row should be increased.