Bug 124939 - editing cell does not follow edit line
Summary: editing cell does not follow edit line
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2019-04-24 17:22 UTC by TorrAB
Modified: 2022-02-01 15:09 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:
Regression By:

file to edit (8.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-04-24 17:22 UTC, TorrAB

Note You need to log in before you can comment on or make changes to this bug.
Description TorrAB 2019-04-24 17:22:42 UTC
Created attachment 150981 [details]
file to edit

Open edit.ods. Edit cell A3 via the edit line, in overwrite mode: enter 'b' over 'A': OK; but, in the copy in cell A3, the b is inserted in front of A instead of replacing it. If you hit Enter, the new formula in cell A3 is wrong: '=BA1'.
Comment 1 m.a.riosv 2019-04-24 21:34:12 UTC
Version: (x64)
Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL
Version: (x64)
Build ID: 3083fe569f96bf0289da1e9d0ef7da15ab22e2f6
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-04-16_03:05:57
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL
Comment 2 Xisco Faulí 2019-04-25 15:34:20 UTC
Regression introduced by:


author	Maxim Monastirsky <momonasmon@gmail.com>	2018-04-24 01:23:33 +0300
committer	Maxim Monastirsky <momonasmon@gmail.com>	2018-04-27 13:35:38 +0200
commit 632bc11ce8fab1c4046ab24810b90a7ce9ac5914 (patch)
tree bca77bf682485765350e3db57afcb71ca493a648
parent 2815499d7c0b32fa05fcd697e7b2c2d897f78dfb (diff)
tdf#117017 Pasting into the formula bar shouldn't retain formatting

Bisected with: bibisect-linux64-6.1

Adding Cc: to Maxim Monastirsky
Comment 3 Maxim Monastirsky 2019-04-27 21:59:53 UTC
(In reply to Xisco Faulí from comment #2)
> Regression introduced by:
> https://cgit.freedesktop.org/libreoffice/core/commit/
> ?id=632bc11ce8fab1c4046ab24810b90a7ce9ac5914
Are you sure this has anything to do with this commit? I seem to reproduce the same behavior with much older builds too (I tested,,

Exact steps, just to make sure we're testing the same thing:

1. Open the file. Cell A3 is selected.
2. Press Shift+Ctrl+F2 to enter the input line.
3. Press Insert to activate overwrite mode.
4. Press ESC to leave the input line.
5. Press Shift+Ctrl+F2 to enter the input line again.
6. Move the cursor over the 'A' letter with the arrow keys.
7. Press 'b'.

Is these steps correct? If yes - could you please test again? It not - please give exact steps, as I couldn't reproduce the problem in any other way.
Comment 4 b. 2019-04-28 04:48:44 UTC
funny thing, 

repro in: 

Version: (x64)
Build ID: 35d9a2618dc0116378ab795a7b9277d248c5afd4
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-04-05_04:55:04
Locale: de-DE (de_DE); UI-Language: en-US
Calc: *unthreaded*

on first try it looked like 'no repro', started described behaviour after first use of ctrl-shift-F2 to enter edit (first try had been just clicking in the edit-bar) and persisted after that also when switching back to enter with mouseclick. 

bibisection looks wrong, 

also repro with ver: 

Build ID: 40ff705089295be5be0aae9b15123f687c05b0a

but! ... not on first try, but on second!

used a new file and entered '=A1' in cell A3


Comment 5 b. 2019-04-28 04:58:26 UTC
additional, don't know if intentional, 

in both above versions switch to overwrite mode is persistent from one edit to the next for the edit-bar, but not! for a cell, cell edit always starts in insert mode. 


Comment 6 TorrAB 2019-04-28 21:44:51 UTC
This bug is tricky.

1: select A3
2: click before A on InputLine, in Overwrite mode (Note); cell A3 goes into edit mode, with cell A1 highlighted;
3: hit key b: A is replaced with b in editLine, but not in cell A3: '=bA1'. Bad.
	However, if the initial mode is Insert in step 2 when editing begins (Note), hit Ins to set mode to Overwrite; now, highlighting of cell A1 disappears, and step 3 gives the correct result: '=b1'.
	Note: The initial mode is important: hit Esc to end editing, then click the editLine for a 'fresh' edit in the last mode (Insert or Overwrite), which is now the initial mode.
Comment 7 Maxim Monastirsky 2019-04-29 08:41:30 UTC
Thanks for confirming. So as said, it has nothing to do with my commit. Removing 'regression', 'bibisected' keywords, and setting as the earliest affected version.
Comment 8 b. 2020-02-01 17:10:21 UTC
still wrong with: 

Version: (x64)
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Comment 9 QA Administrators 2022-02-01 04:45:47 UTC Comment hidden (obsolete)
Comment 10 TorrAB 2022-02-01 15:09:13 UTC
Version: (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL