spreadsheet jumps into begin if large text cells are edited

[kadarpik]

When we have 10+ rows doc with one column with very long text, every time I select the cell and try to edit it, the table
jumps into beginning. Or sometimes it does columnt jump too.

We use chrome latest browser and it happens in osx, Linux and windows.

To Reproduce
Steps to reproduce the behavior:

1. craete a table with large text cells with 10+ lines inside each cell.
2. Click on cell and then move into input bar on top of the sheet (where formula icons reside at the beinning)
3. The text appears in input box as well as correct cell col and rown number
4. sheet jumps into line one
5. When I do the editing and press enter the sheet jumps back into correct position, i.e. to the next line

test done under nextcloud 16 docker image 6.4,chrome 86.0.4240.75 (64-bitine)
can not upload ods file unfortunately but I have attached an url for fownload.
https://avalik.3kgroup.ee/index.php/s/iSsZycB7ssAsEST
the link to the file must be downloaded and tested with collabora online, the site uses onlyoffice.

[kadarpik]

Does anyone know, in what module the scroll, jump decision is made ? It happens when insert mode comes on. The data entry field at top is in expanded state, i.e. not one line height.

[kadarpik]

correct name of the text intput bar is formula bar might be the code reference Control.FormulaBar.js

[shuhaowu]

I can trivially reproduce this:

1. Create a new sheet
2. Enter a number on that textbox (say 30).
3. Convert it into a percent.
4. Go back to the same textbox and try to enter another number.
5. The moment you hit a number key while on that textbox, the screen jumps all the way to the right.

This is likely a HiDPI problem, when I turn my screen to 1080p, this is no longer an issue.

EDIT: seeing your description I'm not sure if it is the same issue, so I'm going to create a new one.

[kadarpik]

This is exactly what has happened here, but I did not know why *Toomas Kadarpik* *Board member+372 55514009Skype: kadarpik* *3KGroup OÜ* *Ruckus Networks value added distributor* *Helgi tee 2, Peetri alevik, Rae vald, 75312 Harjumma <http://www.3kgroup.ee/kontori-asukoht/>* *Estonia*

…

On Fri, 26 Feb 2021 at 05:48, Shuhao Wu ***@***.***> wrote: I can trivially reproduce this: 1. Create a new sheet 2. Enter a number on that textbox (say 30). 3. Convert it into a percent. 4. Go back to the same textbox and try to enter another number. 5. The moment you hit a number key while on that textbox, the screen jumps all the way to the right. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#548 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AK6EYXY3TTGFR6IDIFJSW53TA4KXHANCNFSM4TMZMVUQ> .

[mmeeks]

I thought I'd fixed this with this - https://gerrit.libreoffice.org/c/core/+/110419 merged some time ago; but it seems I didn't.
The problem is (almost certainly) that the calc formula edit line at the top uses an 'EditEngine' which is 99% used as a document element, and this EditEngine emits events that make it seem like they come from the document - to much confusion.
I have a follow-on prototype patch that needs some more attention to tackle this locally.

Internal ticket: https://phabricator.collabora.com/T25979 =)

Thanks for filing!

[pedropintosilva]

This was fixed with the following patches :

#1827
https://gerrit.libreoffice.org/c/core/+/113047