Bug 65200 - FORMATTING: Autofit width not behave properly if cell(s) contain text wrapping
Summary: FORMATTING: Autofit width not behave properly if cell(s) contain text wrapping
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: Other All
: medium minor
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks:
 
Reported: 2013-05-31 06:57 UTC by ign_christian
Modified: 2017-06-21 17:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample file to test (6.00 KB, application/xls)
2013-05-31 06:57 UTC, ign_christian
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ign_christian 2013-05-31 06:57:49 UTC
Created attachment 80081 [details]
Sample file to test

After some searching, it looks like I did not find a bug like that would be my report. Please mark this as duplicate if anyone find similar bug reported before. 

Attached file contain 3 columns (A,B,C), each column have same content.
- Column A : "Wrap text automatically" disabled at all cells
- Column B : "Wrap text automatically" enabled at all cells
- Column C : "Wrap text automatically" only at cell C1, else no

Steps to reproduce bug:
1. Open that file & mark all columns A,B,C
2. Autofit width -> double click separator between column C-D
3. See that all columns behave differently 
-> width of columns A,B,C (respectively) : 1.45 cm , 2.66 cm , 0.66 cm

Problem: 
Autofit width behave unexpected if any/all cells contain text wrapping. Column C seems to autofit only considering number. (Test: change cell C2 with 100, then autofit width)

Another weird behavior: fill cell B10 with 1, then autofit width -> column B adjusted again to 0.55 cm

LO 4.0.4.1 (Win7 32bit)
Comment 1 ign_christian 2014-04-13 14:22:15 UTC Comment hidden (obsolete)
Comment 2 Albrecht Müller 2014-09-22 18:40:19 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2015-10-14 19:58:24 UTC Comment hidden (obsolete)
Comment 4 Albrecht Müller 2015-10-15 08:56:13 UTC
Still there in Version: 4.4.4.3
Build-ID: 2c39ebcf046445232b798108aa8a7e7d89552ea8

Observed the same data as before:
Column width after autofit A: 1.44 cm, B: 2.26 cm, C: 0.69 cm
Column width after B10 = 1 and autofit: A: 1.44 cm, B: 0.57 cm, C: 0.69 cm.
Comment 5 QA Administrators 2016-11-08 11:42:08 UTC Comment hidden (obsolete)
Comment 6 Timur 2017-06-21 17:03:36 UTC
Behavior reproduced from LO 4.0 to master 6.0+. It was as expected from OO to 3.6.