Bug 159237 - Optimal Column Width does not work with Right Indent Cells
Summary: Optimal Column Width does not work with Right Indent Cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Management
  Show dependency tree / graph
 
Reported: 2024-01-17 09:20 UTC by nobu
Modified: 2024-09-13 07:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
sample file (20.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-01-17 09:22 UTC, nobu 		Details
View All 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 nobu 2024-01-17 09:20:45 UTC 
Description:
Optimization of Column Width does not work with Right Indent.

Steps to Reproduce:
1. Open New Calc
2. Cell Input [A1] = "ABC"
3. Change Cell Format : Horizontal=Right , Indent=40pt
4. Select Cell [A1] , Excecute "Optimal Column Width"

Actual Results:
5. Cells become narrower, The text goes to the left and is no longer visible.

Expected Results:
5. Appropriate cell widths and text is visible.


Reproducible: Always


User Profile Reset: No

Additional Info:
  Or
Open Attached File ,  Excecute "Optimal Column Width"

---
Reproducible with
Version: 7.1.2.2 (x86) / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: default; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded

Reproducible with
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 90b12c9bad55e8f50b75a6d7b68caa27d82cc2b9
CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Comment 1 nobu 2024-01-17 09:22:06 UTC 
Created attachment 192009 [details]
sample file
Comment 2 raal 2024-01-20 14:29:47 UTC 
No repro with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ef6083200a4f28e43198c7a0878da6f4b880725f
CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

Please retest with newer version. Caolán did some tweaks in bug 158997. Thank you.
Comment 3 ady 2024-01-20 16:03:15 UTC 
(In reply to raal from comment #2)
> Please retest with newer version. Caolán did some tweaks in bug 158997.
> Thank you.

FWIW, this can be reproduced in recent LO 24.8 alpha on MS Windows, either using attachment 192009 [details] or a new file.

I do not know whether the "optimal width" action should consider indentation, but I surely can understand users' expectation.

I am setting this as NEW for now, but maybe there are some other reports regarding the same issue / behavior.
Comment 4 nobu 2024-05-05 22:24:12 UTC 
Confirmed with
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f4ef5435df5560e6b6b061ce4053c71e2819bf51
CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Comment 5 nobu 2024-08-30 09:01:46 UTC 
Confirmed with
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 4e04e96334a841865914c1629202912e343c4cb2
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 10240); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Comment 6 nobu 2024-09-10 04:34:15 UTC 
Reproducible with
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 3e8183e0c4b4c116cbd9187bfdfa7dfdf447805e
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 10240); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Comment 7 nobu 2024-09-13 07:47:19 UTC 
Works well with MS-Excel.