Issue 13843 - Optimal Column Width and Automatic Line Break of a cell
Summary: Optimal Column Width and Automatic Line Break of a cell
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-04-26 13:10 UTC by rogerathome
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Spreadsheet with problem demo (5.41 KB, application/octet-stream)
2003-04-26 13:11 UTC, rogerathome 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description rogerathome 2003-04-26 13:10:45 UTC 
When I use Optimal Column Mode and one of the cells is not in Automatic Line
Break mode the Width sometimes isn't set correctly. Sometimes the Column gets
smaller sometimes bigger and sometimes it works after using this function twice
without any other changes.
If one of the Cells is not in Automatic Line Break I guess it should use this
one as the reference for the widest one.
Comment 1 rogerathome 2003-04-26 13:11:33 UTC 
Created attachment 5908 [details]
Spreadsheet with problem demo
Comment 2 frank 2003-04-28 07:51:41 UTC 
Hi Niklas,

one for you.

I think the default for optimal column width is the cell with the
maximum width.

Frank
Comment 3 frank 2003-04-28 10:40:12 UTC 
Hi Bettina,

Niklas told me that it works as specified. I think we should change
the default behaviour as it is not intuitive. Optimal Column width
should use  the widest cell. 

What do you think ?

Frank
Comment 4 rogerathome 2003-09-13 11:40:56 UTC 
Reposted for review.
Comment 5 bettina.haberer 2004-01-21 18:07:46 UTC 
Summary: When using Optimal Column Mode and one of the cells is not in Automatic
Line Break mode the Width sometimes isn't set correctly. Sometimes the Column gets
smaller sometimes bigger and sometimes it works after using this function twice
without any other changes. If one of the Cells is not in Automatic Line Break it
should use this one as the reference for the widest one.
This issue is considered for OO.o later.
Comment 6 patb 2005-10-09 05:10:51 UTC 
I found same problem in another spreadsheet
Problem still exists in OpenOffice 2.0rc

Problem: getting "Format-Column-Optimal Column width" to work on a selected
column. Problem seems to be more than having all cells in a column in Automatic
line break mode
in "OptimalColumnWidth error example.sxc" problem is column D

Expected sequence of events:
a) select Column D
b) go to Format-Column-Optimal column with and press "OK"
c) Column D increases in width to accommodate longest text in a cell - at least
that's the way every other spreadsheet that I've used tends to work

I get result wanted by doing following
1. go to Format-Cells-Alignment and select Horizontal = Left and Vertical =
Middle and tap "OK"
2. select Column D
3. go to Format-Column-Optimal Column With and tap "OK"
4. get desired result: column D increases in size to acommodate all text

Obviously problem with "Format-Column-Optimal column width" working regardless
of the format of the individual cells in the column. 
"Format-Column-Optimal column width" does not work when cells in column have
different formats and/or have some particular formats.

I'll add my problem case if I can figure out how to add it... I was buying parts
for a bicycle ... actually using 2.0rc and ran into this error.
Comment 7 bettina.haberer 2010-05-21 15:06:03 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".