Bug 84747

Summary: EDITING typed characters inserted into wrong sheet when defined name selected
Product: LibreOffice Reporter: B.J. Herbison <bj>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: sophi
Priority: medium    
Version: 4.3.2.2 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108252    
Attachments: Spreadsheet with defined name on Sheet2.

Description B.J. Herbison 2014-10-07 10:57:40 UTC
Created attachment 107476 [details]
Spreadsheet with defined name on Sheet2.

When a name is selected, pending characters are placed in the sheet of the name instead of the sheet where the characters were typed.

Steps to reproduce:
* Open the attached spreadsheet.
* Type "1". Do not press enter or any other key after typing.
* Click the down-arrow next to the name box (right of "A1") and click "trap".

Expected result:
- "1" in cell A1 in Sheet1, focus on A4 in Sheet2.

Actual result:
- "1" in cell A1 in Sheet2, focus on A4 in Sheet2.

If different cell is selected before typing (for example, C3), the edit is placed in that cell (C3) in the sheet of the name.
Comment 1 sophie 2014-10-21 11:54:52 UTC
Confirmed with 4.3.2.2 and master also with a new document. Set as New - Sophie
Comment 2 tommy27 2016-04-16 07:24:59 UTC Comment hidden (obsolete)
Comment 3 B.J. Herbison 2016-04-16 12:42:53 UTC
The problem still exists. Tested in Calc 5.1.2.2 on Windows 7.
No change in behavior.
Comment 4 QA Administrators 2017-05-22 13:26:18 UTC Comment hidden (obsolete)
Comment 5 B.J. Herbison 2017-05-23 01:07:07 UTC
The problem still exists. Tested in Calc 5.3.3.2 on Windows 7.
No change in behavior.
Comment 6 QA Administrators 2018-07-24 02:36:34 UTC Comment hidden (obsolete)
Comment 7 B.J. Herbison 2018-07-24 10:50:01 UTC
The problem still exists in 6.0.3.2. Tested on Ubuntu.
Comment 8 QA Administrators 2019-07-30 03:12:52 UTC Comment hidden (obsolete)
Comment 9 B.J. Herbison 2019-07-30 10:00:03 UTC
The problem still exists in 6.2.5.2. Tested on Ubuntu.
Comment 10 QA Administrators 2021-07-30 06:22:52 UTC Comment hidden (obsolete)
Comment 11 B.J. Herbison 2021-07-30 09:10:59 UTC
The problem still exists in 7.1.5.2. Tested on Ubuntu.

Is it worth the effort to confirm old bugs?

New releases come out with such important features as "Added realistic soft blurred shadows for objects" (bug 48722) but basic things like entering information into the correct cell don't get addressed.
Comment 12 QA Administrators 2023-07-31 03:05:38 UTC Comment hidden (obsolete)
Comment 13 B.J. Herbison 2023-07-31 09:32:55 UTC
Still present. Tested on Ubuntu.

Version: 7.5.5.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:7.5.5~rc2-0ubuntu0.22.04.1~lo1
Calc: threaded