Description: This is an area that provides the structure of the formula and some features that allow for easily dealing with it. What do you think are the needed features? We can add things such as formatting, syntax highlighting, cell referencing, and debugging. Is it necessary to do all of these? Or just some of them? Or do you need completely different features? And for the debugging functionality, does it need to calculate intermediate results or just highlight the very first error? Actual Results: --- Expected Results: --- Reproducible: Always User Profile Reset: No Additional Info: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 342670dc6b0fc5b93a40b9cf86b8cca67fac88a3 CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
I do not know the exact scope of this report/RFE, but since the questions seem open, I'd like to mention that typical keyboard shortcuts are not available when using the Function Wizard nor the Functions Deck sidebar. Examples: A. F4 (cycle between absolute/relative references) B. [CTRL]+([SHIFT])+... (e.g. [HOME], [END]...); [PgDn]; [PgUp]... C. arrow keys D. the [ENTER] key should have "smarter" default actions in each particular case. For the above item "D", describing each case would be painfully long and verbose, but I believe that experienced users (of spreadsheet tools) should be able to imagine what I mean. Any medium-to-advance user of spreadsheet tools knows that the possibility of using keyboard shortcuts drastically changes efficiency/performance/UX with spreadsheets, and the FW (and FD) are particularly benefited by them. These are not the only possible improvements (and I have expressed others in other reports).
(In reply to ady from comment #1) > These are not the only possible improvements (and I have expressed others in > other reports). FWIW, in relation to the Function Wizard, tdf#155316 is one of those other potential improvements, but IDK whether it is relevant in this tdf#161542. The reasoning in tdf#155316 is explained in several comments in its predecessor, tdf#104487.
(In reply to ady from comment #1) > I do not know the exact scope of this report/RFE, but since the questions > seem open, I'd like to mention that typical keyboard shortcuts are not > available when using the Function Wizard nor the Functions Deck sidebar. This enhancement will be part of the GSoC Project "Improvement to the Functions Deck in LibreOffice Calc". I see that adding keyboard shortcuts will be super useful, so I will make that a priority. (In reply to ady from comment #2) > FWIW, in relation to the Function Wizard, > tdf#155316 is one of those other potential improvements. I don't think that would be relevant here, but it can be a good improvement to have in the Functions Deck sidebar in general.
My understanding of the sidebar in general is to provide a quick and simple access to features. It is not meant for complex interactions intending to replace the properties dialogs. Therefore I would abstain from function editing as it is done in the sheet. And I agree with Ady's wish list. => WF
(In reply to Heiko Tietze from comment #4) > Therefore I would abstain from function editing as it is done in the sheet. > And I agree with Ady's wish list. Okay, that seems great. We can disregard the editor area due to its unnecessary additional complexities. I will work on providing keyboard shortcuts for FD and FW. I just need to know exactly which shortcuts you want, because I find that many shortcuts already exist for them. I am not very experienced with spreadsheets, so I cannot imagine which shortcuts would be most useful. If you agree, should we close this ticket and open another one for "adding keyboard shortcuts"?