When typing a long formula in the formula zone, it is necessary to highlight corresponding parenthesis like it is done in microsoft Excel. when an opening parenthesis is highlighted the corresponding closing parenthesis is highlighted by Excel and vice versa. ALso it is necessary to enhance the funct 9 key behavior: In microsoft Excel, when hitting Func9 key, the highlighted formula is replaced by its calculation and another part of the formula can hereafter be highlighted and replaced an so forth.
Sounds useful -> NEW
+1 to this, and I would also like to add some information that may be helpful for implementation: LibreOffice Calc already has parenthesis matching and highlighting code, just not in the formular bar. If you edit a cell's formula by pressing F2, it allows editing the formula "in place" and, somehow, that in-situ formula editor _does_ have "matching parenthesis highlighting". So I would recommend two things for someone willing to tackle this problem: 1. Reuse/port that code from the F2 editor into the main formula bar widget. 2. For better visual clarity for users, make it do some real highlighting (i.e.: a colored yellow background behind the matching parentheses) instead of just making the characters bold (the bold type is really not visible enough for me)