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
Please attach a sample file(s), reduce the size as much as possible without private information.
Created attachment 196008 [details] Single sheet file showing Actual & Expected Results Columns A>C show the Actual Results as described in the initial report Columns E>G show the Expected Results as described in the initial report
Created attachment 196010 [details] Screenshot Of Attached File Above I have also attached a PNG screenshot of the issue
Created attachment 196017 [details] Screenshot right after opening the file, and after following the instructions
(In reply to m_a_riosv from comment #4) > Created attachment 196017 [details] > Screenshot right after opening the file, and after following the instructions Interesting, it would seem the issue doesn't recur in these screenshots I have attempted to run LibreOffice in Safe Mode and performed the same actions, but had the same results as my initial report; including removal of the merged/centred headers as per your attachment screenshots Help > About LibreOffice (Safe Mode) 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: default; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: threaded
Created attachment 196047 [details] Worksheet Template I have attached a copy of my custom worksheet used as the default template for new documents in Calc for reference
Created attachment 196050 [details] Screenshot Comparing Windows 7 & Windows 10 I managed to test the uploaded spreadsheet file on another desktop running Windows 10 (albeit with LibreOffice version 7.6.0.3) and found the issue was not present here Further to this, I updated LibreOffice to version 24.2.5 and opened the same file and the problem has now recurred. Further, I noted upon closer inspection that the character rendering between 7.6.0.3 and 24.2.5 is different; 7.6.0.3 has much less character spacing (more tightly grouped characters) than in 24.2.5 Please find below the About LibreOffice info from both versions: Original Windows 10 Test Version: 7.6.0.3 (X86_64) / LibreOffice Community Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 CPU threads: 6; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL threaded Latest Windows 10 Test Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59 CPU threads: 6; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL threaded
Bibisected with linux-64-24.2 to 4b743de97fc133623e46827869c4ea3eb845ad47 tdf#156234: Don’t round glyph coordinates when doing subpixel positioning I just observed how the opened spreadsheet looks like.