https://bugs.documentfoundation.org/show_bug.cgi?id=145911
Bug ID: 145911
Summary: Optimal Width incorrectly assesses cells where the
contects are created with TEXT functions
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Cells that have been created with the functions TEXT & TEXTJOIN are not
correctly assessed when column > optimal width is invoked from the context
menu.
The assessment is affected by the contents of "informal header" cells.
Attached sheet with highlighted cells demonstrates the effect.
Steps to Reproduce:
Note Word Wrap is active for the entire sheet as is Centred Text
Utilising the attached sheet select columns to include D
1. Right click the header and select optimal width
2. Observe how the column shrinks to facilitate the single character in D2
3. Undo the action
4. Delete "D" from D2
5. Redo 1
6. Observe how the column expands to over-compensate for the cell content
7. Undo
8. Enter text into D2 that is "almost" as lengthy as the contents of D3:D4
9. Redo 1
Columns y & Z demonstrate the same anomaly whereas AF seems to be on its own
planet as it shrinks the column to the contents of AF3:AF4 leaving AF2 in an
overflow condition
10. Undo
II. Change Global Alignment to Left Justified
12. Select columns B:G
13. Redo 1
14. Observe
Note that Column A is a simple assignment of Column D and is processed
correctly
Observation: Wordwrap has the same effect as Left Justified
Actual Results:
Inconsistent and incorrect column width adjustment
Expected Results:
Consistency would be good - accuracy aven better
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.2.2.2 (x64) / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
