Description
I would like to suggest a highly useful feature for advanced users, which is currently a standard in Microsoft Excel but missing in OnlyOffice: the ability to evaluate a selected portion of a formula using the F9 key.
How it should work:
-
The user selects a specific segment, expression, or nested function inside the Formula Bar.
-
The user presses F9.
-
OnlyOffice immediately evaluates only that selected part and replaces it with its static calculated result directly in the formula bar.
-
If the user presses Esc, the formula reverts to its original state (canceling the evaluation). If they press Enter, it saves the formula with that part converted to a static value.
Why this is important:
When dealing with long, complex, or heavily nested formulas, debugging is incredibly difficult without this tool. This feature allows power users to perform quick “inline debugging” to see exactly which part of a formula is returning an error or an unexpected value, without having to break the formula into multiple cells.
It would be a massive quality-of-life improvement for spreadsheet power users and a great competitive advantage for OnlyOffice Spreadsheet.
Thank you for considering this!