[Libreoffice-bugs] [Bug 139877] Cell editing does not allow arrows within the cell if it starts with =

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139877

--- Comment #4 from Ross Johnson <ross.johnson at homemail.com.au> ---
Calc's behaviour is not a bug.

The screencast shows a specific scenario where cell A1 is being edited. Google
sheets is moving the cursor on left arrow because there's no cell to the left
of the edited cell. However, the screencast shows it inserting cell addresses
to the right when the right arrow is used.

In the same situation, editing cells in column A, Calc refuses to move the
cursor left. Either way is ok, although the behaviour of Calc could be
preferable IMO in not setting up a false expectation/muscle memory.

What does Google Sheets do when editing cell B2? When the left arrow is pressed
I expect it inserts the address of cell B1. But then, pressing left arrow
repeatedly, does it start to move the cursor in cell B2 to the left?

Except for this minor difference in interpretation, both Calc and Google Sheets
appear to do the same thing. If possible they move to adjacent cells and insert
the address of that cell when the next key is pressed. The last inserted cell
remains highlighted and the next arrow keypress is relative to that cell.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210920/30cda522/attachment.htm>