https://bugs.kde.org/show_bug.cgi?id=420076
Bug ID: 420076 Summary: No Keyboard support for entering formula Product: calligrasheets Version: 3.1.0 Platform: unspecified OS: All Status: REPORTED Severity: normal Priority: NOR Component: usability Assignee: calligra-sheets-bugs-n...@kde.org Reporter: mathias_t...@mathiasfoehr.lu Target Milestone: --- 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 -- You are receiving this mail because: You are watching all bug changes.