Created attachment 79640 [details]
Column width information not remembered correctly on XLS.
Steps to reproduce:
1. Open attached file
2. Autofit width all columns A-F -> mark all columns A-F & double-click separator column F-G
3. Check that column width should be the same as written on row 27
4. Save, close, & reopen file
5. Check & see that column width change to what is written on row 28
6. Modify cell A1 by inputting single space, then enter
7. Save, close, & reopen file
8. Check & see that column width change to what is written on row 29
Problem: column width change unexpectedly without any changes that affect width
Tested on LO 184.108.40.206 (Win7 Home Premium 32bit). I believe this problem persists since LO 3.6.
Tested on LO 220.127.116.11 (Ubuntu 12.04 32bit) generates same behavior with slightly different value (smaller column width)
I'm using inches but I do see that the #'s are definitely changing.
LibreOffice Version 18.104.22.168
Minor - doesn't prevent high quality work but can slow it down substantially
High - in general these are low but I think column width is one of those things that most people expect to work correctly. Furthermore it's a feature that essentially anyone using spreadsheet depends on (ie. not some special feature)
Thanks for the clear report, really easy to triage this one due to attachment and steps :)
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.
Thank you and apologies for the noise
Migrating Whiteboard tags to Keywords: (needsDevEval)
Created attachment 124694 [details]
Affected XLS file example
This file opens with difference column widths in Windows LO 5.1 and Linux LO 5.1.
(In reply to brucehohl from comment #5)
> Created attachment 124694 [details]
> Affected XLS file example
> This file opens with difference column widths in Windows LO 5.1 and Linux LO
Column widths when opened on Windows LO 22.214.171.124:
A = 0.53
B = 2.34
C = 1.42
D = 1.42
E = 1.71
Column widths when opened on Linux LO 126.96.36.199
A = 0.67
B = 2.95
C = 1.79
D = 1.79
E = 2.15
There are definitely column width preservation problems in LO 5.x with respect to XLS and XLSX file formats (and perhaps between Windows & Linux builds).
I was completely unable to replicate. Tested with bibisect43all back to last36onmaster. (Ubuntu 16.04 x64). F column width was always 1.12in.