Bug 129714

Summary: Cursor not in cell when editing xls file
Product: LibreOffice Reporter: Bernard <bht237>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: buzea.bogdan, oliver.brinzing
Priority: medium    
Version: Inherited From OOo   
Hardware: x86-64 (AMD64)   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108430    
Attachments: Simple xls file used as test case

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