Bug 102335 - highlighting opening and closing parenthesis in the formula editing zone
Summary: highlighting opening and closing parenthesis in the formula editing zone
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2016-09-21 19:36 UTC by piscvau
Modified: 2023-05-08 19:14 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description piscvau 2016-09-21 19:36:53 UTC
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.
Comment 1 Buovjaga 2016-10-09 11:36:07 UTC
Sounds useful -> NEW
Comment 2 Jeff Fortin Tam 2020-03-26 16:24:35 UTC
+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)