Currently my LibreOffice Calc sets width of columns by length of the header cells. I need it to set it by length of the data in the cell. The Excel does that without extra effort from my side, but Calc is not.

Here is the example.

I copy table data from the web page and paste it to the Calc. It places it into columns of identical width.

I select entire data set by clicking top left corner.

Then drag one of the column's border to the right, to some preposterous width.

Then doeble-click the delimiter line at the left side of the document (where the line numbers are). This creates lines of single height (depends on size of data in the cell).

Then I double click the delimiter line at the top of the document (where column IDs are) and that finally should give me automatically adjusted width of columns. At least this is how Excel works.

LibreOffice Calc in this scenario autowidth columns by the width of the header line and not by widest cell value in general.

Is it possible to tell Calc behave in the same way the Excel does it.