Bug 106113 - EDITING: Text in cells has different vertical alignment when being edited
Summary: EDITING: Text in cells has different vertical alignment when being edited
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks: Cell-Edit-Mode
  Show dependency treegraph
 
Reported: 2017-02-20 19:28 UTC by joshas
Modified: 2023-05-13 11:45 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Text alignment issue (1.94 KB, image/png)
2017-02-20 19:29 UTC, joshas
Details
LibreOffice 5.2.5.1 (33.93 KB, image/png)
2017-02-21 18:05 UTC, joshas
Details
LibreOffice 5.3.0.3 (33.65 KB, image/png)
2017-02-21 18:05 UTC, joshas
Details
Character carons are cut off (16.95 KB, image/png)
2017-07-01 07:48 UTC, joshas
Details

Note You need to log in before you can comment on or make changes to this bug.
Description joshas 2017-02-20 19:28:59 UTC
Description:
On Windows 7 text in all cells are bit lower, than vertical center. When cell text is in edit mode, that text moves few pixels higher. After editing is done, text returns to previous position, which is still off vertical center.

Steps to Reproduce:
1. Open new spreadsheet.
2. Enter some text.

Actual Results:  
Entered text is few pixels lower, than it should be. When editing, text is a bit higher.

Expected Results:
Text should stay vertically centered at all times, except when special formatting is applied.


Reproducible: Always

User Profile Reset: Yes. Problem still exists in safe mode.

Additional Info:
Version: 5.3.0.3 (x64)
Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Layout Engine: new; 
Locale: lt-LT (lt_LT); Calc: group


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:51.0) Gecko/20100101 Firefox/51.0
Comment 1 joshas 2017-02-20 19:29:45 UTC
Created attachment 131373 [details]
Text alignment issue
Comment 2 Xisco Faulí 2017-02-21 09:55:56 UTC
Hi,
Thanks for reporting.
This is the expected behaviour and it has been like that since OpenOffice, thus this is considered as not a bug.
Closing as RESOLVED NOTABUG
Comment 3 joshas 2017-02-21 17:41:07 UTC
It was working "correctly" in LibreOffice 5.2, all text was neatly aligned in the middle vertically. I think it is a regression.
Comment 4 joshas 2017-02-21 18:05:24 UTC
Created attachment 131389 [details]
LibreOffice 5.2.5.1
Comment 5 joshas 2017-02-21 18:05:43 UTC
Created attachment 131390 [details]
LibreOffice 5.3.0.3
Comment 6 joshas 2017-02-21 18:07:43 UTC
Please, take a look at two new screenshots, comparing similar views on 5.2 and 5.3 versions of LibreOffice. You will clearly see, that in 5.3 text is rendered a few pixels lower than in previous version.
Comment 7 Xisco Faulí 2017-06-26 18:22:04 UTC
This bug was never confirmed. Moving back to UNCONFIRMED
Comment 8 Xisco Faulí 2017-06-27 00:43:10 UTC
I'm sorry but I don't consider this a bug. It's true the vertical alignment is slightly different than in previous versions of LibreOffice, but it's not causing any side-effect, thus, we can consider this a bug.
Comment 9 joshas 2017-07-01 07:47:48 UTC
When entering characters with carons (see attached screenshot) they are cut off, because all text is shifted upwards. This is a usability issue.
Comment 10 joshas 2017-07-01 07:48:15 UTC
Created attachment 134419 [details]
Character carons are cut off
Comment 11 Xisco Faulí 2017-07-13 13:37:14 UTC
Moving it back to UNCONFIRMED until someone else confirms it.
Comment 12 Buovjaga 2017-08-07 17:21:52 UTC
Repro the caret thing, but it already happens in 4.4.7.2. Not in 3.5, though.
Unable to bibisect on Win as it does not go to 3.5, but I can also repro on Linux, so it could be bibisected.

Win 10
Version: 5.4.0.3 (x64)
Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c
CPU threads: 4; OS: Windows 6.19; UI render: default; 
Locale: fi-FI (fi_FI); Calc: group

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.3
Build ID: 5.4.0-1
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Comment 13 Buovjaga 2018-05-24 16:16:16 UTC
More testing: on Linux with 3.6.7.2, both Ř and Č are raised so the carets are cut off. With 3.3, the Č is by default so high that the caret is cut off.

On Windows with 3.5.0, the Ř is raised, but caret is not cut off and Č does not move and is not too high.

So I'm not sure, if bibisecting is worth it.
Comment 14 Buovjaga 2018-06-28 15:23:47 UTC
Bibisected on Linux with 43all, targeting as bad any build where the text moves when you start to edit it. Range given: https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=bed0447cefb949fc77cfde7543397d96590082ba...c29af1572ad15ac5199a09e5812fb8354c165329

Nothing jumps out to me. Take with a grain of salt or ignore.
Comment 15 QA Administrators 2019-06-29 02:58:51 UTC Comment hidden (obsolete)
Comment 16 joshas 2019-06-29 15:46:17 UTC
While character vertical alignment issue is not so extreme in current version, but when editing characters move about 1px up in cell.
Caron cut-off issue still exists. Default cell height could be about 2px higher to fix it.

Version: 6.2.4.2 (x64)
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: lt-LT (lt_LT); UI-Language: en-US
Calc: CL
Comment 17 joshas 2021-03-25 11:11:54 UTC
Issue still occurs in LibreOffice 7.0.5.2 on Fedora 33. While uppercase characters carons are not cut off, it is still a bit annoying when text moves up after pressing F2 to edit it and moves down after pressing Enter.
Comment 18 QA Administrators 2023-03-26 03:23:23 UTC Comment hidden (obsolete)
Comment 19 joshas 2023-03-26 07:40:12 UTC
LibreOffice Calc on Fedora Linux 37 (Workstation Edition)

Version: 7.4.6.2
Build ID: 40(Build:2)
CPU threads: 12; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: lt-LT (en_US.UTF-8); UI: en-US
Calc: threaded

Issue is still here, but text in edit mode moves up only by a single pixel, so character carets are not cut off and it is more of an annoyance than major blocker.
It would be interesting to hear from technical perspective, why this issue happens. I'd guess that "text" and "edit" components have a bit different rendering rules?
Comment 20 Buovjaga 2023-03-26 11:36:57 UTC
I did another bibisect and looks like in 5.4 it got less severe due to 60eed46d4b24b9b9eaa1ebd0a8f185900176aed5
Resolves: tdf#107249 round ascent/descent/extleading on conversion to int
Comment 21 BogdanB 2023-05-13 11:45:46 UTC
Adolfo, I included you here, if you can take a look.