Bug 84747 - EDITING typed characters inserted into wrong sheet when defined name selected
Summary: EDITING typed characters inserted into wrong sheet when defined name selected
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.2.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
 
Reported: 2014-10-07 10:57 UTC by B.J. Herbison
Modified: 2023-07-31 09:32 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with defined name on Sheet2. (10.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-10-07 10:57 UTC, B.J. Herbison
Details

Note You need to log in before you can comment on or make changes to this bug.
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