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
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
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.