Feature Request: Syntax Highlighting and Subformula Visuals in Formula Bar #2015
Description
This issue is unique.
- I have used the search tool and did not find an issue describing my idea.
Your idea.
Description:
Currently, the formula bar in OnlyOffice Spreadsheet displays all formula text in plain white, without syntax highlighting or visual aids. This makes reading and editing complex or nested formulas difficult.
Expected Behavior (Example from Excel):
1. Parentheses and nested subformulas are color-coded for easier visual parsing.
2. In recent Excel versions, placing the caret inside a subformula highlights that part and dims the rest of the formula, making it easier to focus on specific sections.
Why It's Useful:
- Improves readability and usability when working with complex formulas.
- Makes debugging formulas faster and less error-prone.
- Helps users visually match opening/closing parentheses and function boundaries.
Suggestion:
Implement basic syntax highlighting in the formula bar:
1. Color matching parentheses.
2. Optional: highlight current subformula when caret is placed inside it.
Additional Notes:
While not strictly a critical bug, this is a very important feature from a usability perspective, especially for users, like me :), who work with complex formulas regularly. Visual cues like syntax highlighting and subformula focus greatly reduce the effort needed to read, write, and debug formulas. It’s one of those features that might seem small on paper, but really improves the overall experience in a noticeable way.
Thanks again for the great work on OnlyOffice, and I truly hope this can be considered for a future update!