https://bugs.documentfoundation.org/show_bug.cgi?id=162616
Bug ID: 162616
Summary: Columns Not Resizing Correctly To Prevent Text
Overflow
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Cell Text Overflow
When entering text into a cell and resizing the column any text over a certain
character count will overflow into the neighbouring cells. The effective is
cumulative; longer strings of text will overflow more into neighbouring cells
Cell Text Blank Space
Additionally, text should usually have a small amount of blank space between
the final character and the column separator line. As text length increases
this blank space reduces consistently when resizing until the text overflows as
above:
a) At approximately 10 characters long, blank space at the end of the
cell is ~5 pixels
b) Increasing to 11+ characters will reduce this value to 0 pixels once
~20 characters have been input
Steps to Reproduce:
Required (Overflow)
1. Enter text of at least 24 characters into any cell
2. Resize the column using:
a) Double click the column separator
b) Right click column header > Optimal Width... > Ensure "Default
value" is ticked > Click "OK"
Optional (Overflow)
3. Enter text into a neighbouring cell
Required (Blank Space)
1. Enter 10 characters of text into a cell
2. Resize the column using:
a) Double click the column separator
b) Right click column header > Optimal Width... > Ensure "Default
value" is ticked > Click "OK"
3. Enter another 10 characters of text into a cell
4. Resize the column using:
a) Double click the column separator
b) Right click column header > Optimal Width... > Ensure "Default
value" is ticked > Click "OK"
Actual Results:
Required (Overflow)
The column resizes but the last character is slightly overflowed usually by a
few pixels; the effective is cumulative so 25+ characters will overflow more
into neighbouring cells
Optional (Overflow)
The red overflow arrow appears, indicating text is now hidden to allow the
neighbouring cells text to be displayed
Required (Blank Space)
The amount of blank space reduces consistently until the final character is
displayed in contact with the column separator
Expected Results:
Overflow
The column resizes to allow all text to be visible within the cell with a small
amount of blank space and/or no overflow
Blank Space
The amount of blank space after the input text should remain consistent
throughout
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Ways To Fix (Overflow):
1. Click and drag the column width to desired size (manual resizing)
2. Right click column header > Column Width... > Enter desired size into
"Width" dialog box > Ensure "Default value" is unticked > Click "OK"
3. Right click column header > Optimal Width... > Enter desired size into "Add"
dialog box > Ensure "Default value" is unticked > Click "OK"
Ways To Fix (Blank Space):
None
Help > About LibreOffice
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 6; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
