Bug 420076

SUMMARY

Other spreadsheet programs permit to type an equal sign and then to use Arrow Keys, Crt + Arrow, ... to move out of the cell catching the reference of the cell to be referred to. 

STEPS TO REPRODUCE

You can test this on libreoffice or on Excel. When in a cell, type = and Arrow right.

OBSERVED RESULT

CalligraSheets outputs a #Parse! error value.

EXPECTED RESULT

Other spreadsheet programs permit to type an equal sign and then to use Arrow Keys, Crt + Arrow, ... to move out of the cell catching the cell to be referred to. It is also possible to type (as an example) =, to click in another cell and then to correct the cell referred to with arrow keys from the keyboard.

Important: the function key F2 is a toggle that permits to switch between this curious editing via cell "selection" on the keyboard and cell editing (e.g. changing a + in a - in a formula)

It is also possible to type (as an example) =, to click in another cell and then to correct the cell referred to with arrow keys from the keyboard.

And using Shift to extend a selection does also work in formula (e.g. in =sum(A3:A6) )

SOFTWARE/OS VERSIONS

I have experienced this on Debian Linux, but I suppose the functionnality is missing everywhere.

ADDITIONAL INFORMATION

I have tried Calligra today for the first time, and the user interface is extremely clean. I can well imagine to use Calligra in the future. But not being able to record a formula via the keyboard is a showstopper for a professional spreadsheetuser. This works since Lotus 123 on Dos on any spreadsheet ;)

Fixing this should be a minor problem; if you want my feed-back on this functionnality, it will be a pleasure.

Kind regards and keep on the good work

Mathias