Strange issue with column widths

[tlouwers]

I have been trying to create sheets with formatting, in which some columns have specific widths. I noticed that when opening the created workbooks in Excel act strange regarding column widths: if I set a particular column to a non-default column width (for instance: 4), and I use Excel to right-click on the column, then click ok (accept whatever value is in the popup), all columns are resized to that value. I cannot undo this action: it will only reset all column widths to the Excel default (it seems).

The thing is that workbooks generated by Excel itself, or LibreOffice Calc do not have this issue.

In pictures:

• Starting out with file 'DummyOut.xlsx'
• Right-click on column 2, goto 'Column Width'
• After accepting the value presented in the popup
• After trying the 'Undo' function

As reference: DummyOut.xlsx - generated by xlnt v1.4.0 DummyOut.xlsx - generated by LibreOffice Calc v6.4.3 DummyOut.xlsx DummyOut2.xlsx

[tfussell]

Thanks for the detailed report. I'll get to this when I'm able.