Bug 161542

Summary:	Add an editor area to the functions deck
Product:	LibreOffice	Reporter:	Ahmed Hamed <ahmedhamed3699>
Component:	Calc	Assignee:	Ahmed Hamed <ahmedhamed3699>
Status:	ASSIGNED ---
Severity:	enhancement	CC:	adylo811517, ahmedhamed3699, andreas.heinisch, eyalroz1, heiko.tietze
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	92416

Description Ahmed Hamed 2024-06-13 00:15:48 UTC

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

Comment 1 ady 2024-06-13 13:23:49 UTC

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).

Comment 2 ady 2024-06-13 15:18:52 UTC

(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.

Comment 3 Ahmed Hamed 2024-06-14 17:10:06 UTC

(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.