Bug 129714 - Cursor not in cell when editing xls file
Summary: Cursor not in cell when editing xls file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Mouse-Cursor
  Show dependency treegraph
 
Reported: 2020-01-01 03:38 UTC by Bernard
Modified: 2023-05-13 13:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Simple xls file used as test case (8.50 KB, application/vnd.ms-excel)
2020-01-01 03:38 UTC, Bernard
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Bernard 2020-01-01 03:38:49 UTC
Created attachment 156868 [details]
Simple xls file used as test case

How to reproduce:


The cell text is EDIT_THIS_TEXT_PLEASE

- Open the attached spreadsheet
- At this point, the cursor should be in cell B3 with text "Start"
- With cursor keys [Up], [Right], [Right], without using the mouse, locate the cell D2 with text "EDIT_THIS_TEXT_PLEASE" and press [F2] to edit it.

Expected behavior: The caret should be in the cell so that one can see which character it is on.

Actual behavior: The caret is not visible. It needs to be activated by clicking on the cell with the mouse.


For a serious spreadsheet user, this is quite annoying, and such a bug should not exist in a product that has been around for so long. a spreadsheet is a front end tool a GUI to manipulate data, so basic navigation should be correct.
Comment 1 Oliver Brinzing 2020-01-01 17:23:22 UTC
reproducible with:

AOO 4.1.5

Version: 6.5.0.0.alpha0+ (x64)
Build ID: 75778a50f730568fee2466b6e794401f1e2a8f67
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded
Comment 2 QA Administrators 2022-01-01 03:34:28 UTC Comment hidden (obsolete)
Comment 3 Bernard 2022-05-14 01:22:04 UTC
I re-tested this with

Version: 7.3.3.2 (x64) / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: en-NZ (en_NZ); UI: en-US
Calc: CL

The problem still persists.

Editing is possible via moving the INVISIBLE cursor with the left and right arrow keys. But I cannot see the cursor until I click with the mouse in the cell. Then the cursor becomes visible.

The problem is not always reproducible but it is persistent. It is a really bad problem because no spreadsheet program should make data editing in cells that difficult.
Comment 4 BogdanB 2023-05-13 13:02:25 UTC
Also in
Version: 7.5.0.1 (X86_64) / LibreOffice Community
Build ID: 77cd3d7ad4445740a0c6cf977992dafd8ebad8df
CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded