Bug 149905 - Add an option to automatically adjust cell width based on row height
Summary: Add an option to automatically adjust cell width based on row height
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks:
 
Reported: 2022-07-07 19:49 UTC by gabris.ivan
Modified: 2023-05-10 11:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description gabris.ivan 2022-07-07 19:49:28 UTC 
Description:
When i have longer text in columns, I need them wrapped and adjusted, so that they are shown in one column whole.
At first I finished writing everything I needed and then tried wrapping lines ( I went to Format - Cells - Alignment - Automatic_alignment) . It did not adjust the column size.
I tried creating new file, first setting text wrap as mentioned above and then pasting normally, unformated text and all other options. Did not adjust the size of column. 
In both cases, when i tried adjusting column height it did not wrap the text or it did not adjust the column size.

Steps to Reproduce:
One option
1.Write text
2.Wrap text
Second option
1.Wrap text in all (ctrl+A)
2.Paste every option.

Actual Results:
Nothing

Expected Results:
Wrapped text in column with adjusted size.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.3.4.2 / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: sk-SK (sk_SK.UTF-8); UI: sk-SK
Flatpak
Calc: threaded
Comment 1 m_a_riosv 2022-07-09 07:50:27 UTC 
As I know, wrap can adjust the row height, based on how many lines the cell has after wrap for a given cell width.
If I understand the question fine, you ask for an automatic cell width given a row height. I think it is not implemented, could be a request for enhancement.
Comment 2 gabris.ivan 2022-07-12 07:52:11 UTC 
Is there a way I can adjust it manualy? Because if it is written and i want it wrapped. It does not work and even if i adjust the height manualy, it doe not wrap itself.
Comment 3 Buovjaga 2023-01-24 08:33:37 UTC 
(In reply to m.a.riosv from comment #1)
> As I know, wrap can adjust the row height, based on how many lines the cell
> has after wrap for a given cell width.
> If I understand the question fine, you ask for an automatic cell width given
> a row height. I think it is not implemented, could be a request for
> enhancement.

For UX team's consideration
Comment 4 Heiko Tietze 2023-01-26 10:46:45 UTC 
You can double-click the right edge of the header cell to make the width fit the column content. Or use "Optimal Width" with some minimum value. Does this work for you?
Comment 5 Heiko Tietze 2023-05-10 11:02:45 UTC 
No response, resolving ID.