Bug 87420 - In-cell editing field is always top-aligned
Summary: In-cell editing field is always top-aligned
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 106426 141864 151562 (view as bug list)
Depends on:
Blocks: Calc-UX Cell-Edit-Mode
  Show dependency treegraph
 
Reported: 2014-12-17 19:44 UTC by saha
Modified: 2025-05-14 05:28 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
A sample to experiment (10.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-05-14 05:28 UTC, Mike Kaganski
Details

Note You need to log in before you can comment on or make changes to this bug.
Description saha 2014-12-17 19:44:35 UTC
Problem description: when typing into a cell the cursor automaticly go to top even if i have choosed an other vertical position

Steps to reproduce:
1. change vertical position other than TOP position
2. Type something

Current behavior: see problem description

Expected behavior: when typing into a cell the cursor should stay at the position that I choosed. It's not a real problem, but I think that it will give some fluidity when typing and maybe save some memory.

Sorry for my english

Best reguards
Comment 1 raal 2014-12-17 21:15:52 UTC
I can confirm with Version: 4.4.0.0.beta2+
Build ID: e1de94244c1b0419c1c3415c02381e8b7a87abe0
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2014-12-14_11:45:23
Comment 2 QA Administrators 2015-12-20 16:06:49 UTC Comment hidden (obsolete)
Comment 3 saha 2015-12-20 19:30:13 UTC
Hello,

This bug is still present with LibreOffice 5.0.4.2 
Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78
Comment 4 QA Administrators 2017-01-03 19:46:23 UTC Comment hidden (obsolete)
Comment 5 Yousuf Philips (jay) (retired) 2017-10-04 17:03:26 UTC
still present

Version: 6.0.0.0.alpha0+
Build ID: 892c719fffa06de4c7aeab497326cad7bae9e5c6
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-09-27_03:02:09
Locale: en-US (en_US.UTF-8); Calc: group
Comment 6 OfficeUser 2017-10-05 14:05:45 UTC
Thanks for the report. This is a very old but annoying issue.

Two things I want to note...

1.
If you have something middle-aligned on a very high row (because neighbor cells contain much text) there is a enormous jump to the top of the string to be edited.

A               B                             A               B

                45646465                      middle-aligned  45646465
                56465465                                      56465465
                TestText                                      TestText
middle-aligned                     ==>> 
                45646465                                      45646465
                56465465                                      56465465
                TestText                                      TestText

[View mode]                                   [Edit mode]


2.
There is functionality lost caused by this bug. In general it is possible to enter edit mode with a double-click exact on that position where you want to have the caret. With this bug the caret is always at the end of the cell content after a double-click.
Interesting: If you manage to double-click on the expected position at the cell top where the text will jump to, the caret will be at the intended position.
Comment 7 OfficeUser 2017-10-05 14:10:00 UTC
*** Bug 106426 has been marked as a duplicate of this bug. ***
Comment 8 OfficeUser 2017-11-18 21:51:32 UTC
Adjusted importance because of the extreme jumps described in my last comment.
Comment 9 QA Administrators 2018-11-19 03:39:47 UTC Comment hidden (obsolete)
Comment 10 OfficeUser 2018-11-19 13:21:26 UTC
Still reproducible with:
Version: 6.1.3.2
Comment 11 QA Administrators 2019-11-20 03:51:11 UTC Comment hidden (obsolete)
Comment 12 Thomas Lendo 2021-05-04 22:13:14 UTC
Still reproducible.

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 8ae3ae4bf75fdd0aaa132c956d9da029baa3adc6
CPU threads: 2; OS: Linux 5.8; UI render: default; VCL: gtk3
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-04-23_17:13:02
Comment 13 Heiko Tietze 2021-05-07 07:14:53 UTC
*** Bug 141864 has been marked as a duplicate of this bug. ***
Comment 14 Eyal Rozenberg 2022-09-16 08:35:21 UTC
Should this block the CJK meta-issue?
Comment 15 Heiko Tietze 2022-11-02 15:00:34 UTC
*** Bug 151562 has been marked as a duplicate of this bug. ***
Comment 16 fml2 2022-11-10 22:27:05 UTC Comment hidden (obsolete)
Comment 17 QA Administrators 2025-03-12 03:12:30 UTC Comment hidden (obsolete)
Comment 18 fml2 2025-03-12 06:27:43 UTC
Still present with

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded
Comment 19 Mike Kaganski 2025-05-14 05:28:23 UTC
Created attachment 200794 [details]
A sample to experiment

The editing of Calc cells indeed creates the edit box with top-aligned text, while editing a graphical object (textbox in the attached example) makes the edit box set up correctly. Note that both use the same editengine internally, so it's not something fundamentally undoable.

(In reply to OfficeUser from comment #6)
> There is functionality lost caused by this bug. In general it is possible to
> enter edit mode with a double-click exact on that position where you want to
> have the caret. With this bug the caret is always at the end of the cell
> content after a double-click.
> Interesting: If you manage to double-click on the expected position at the
> cell top where the text will jump to, the caret will be at the intended
> position.

This issue is resolved in commit d0a1616ccad0dd5f5a02c1b0204f537b57d0b4b5.

A code pointer: ScTabView::MakeEditView is a place where one could put a breakpoint when looking for a code that actually sets up the editing box.