Ask Your Question
0

Calc parenthesis highlighting [closed]

asked 2018-03-21 22:45:44 +0100

PAlotta gravatar image

I am using Calc in LO 6.0.2. Is there any parenthesis highlighting that can be enabled for the formula bar? I have a habit of missing parenthesis in long formulas so this would be useful. If it not a feature, is there a way to request such an enhancement?

Peter

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-03-26 14:35:24.871243

Comments

Enhancement requests are to post to bugs.documentfoundation.org as if they were bugs.
(Often they are.)

Lupp gravatar imageLupp ( 2018-03-21 23:49:28 +0100 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2018-03-21 23:52:15 +0100

Lupp gravatar image

updated 2018-03-21 23:53:30 +0100

You surely noticed that you can edit formulae also in the cell-grid area after you entered the cell for editing with a left doubleclick otr by F2. There the corresponding half of a pair of parentheses is displayed bold if you placed the cursor behind the other half.
(A trick I use sometimes: Insert some spaces to get a visual subdivision.)

The most efficient way to get things clearly arranged, often applicable, is to use shorter formulae, and in specific no deeply nested calls to the IF function.

edit flag offensive delete link more
0

answered 2018-03-22 15:00:04 +0100

Jim K gravatar image

updated 2018-03-22 15:34:57 +0100

Consider this example, inspired by @Lupp's answer.

=IF(1=1;IF(1=2;IF(1=2;IF(1=2;3;4);5);IF(1=2;3;6));IF(1=2;3;7))

The cell-grid area of Calc looks like this (notice the bold )). That's helpful for medium-complexity formulas but not so good for large, ugly ones.

Calc paren matching

Selecting part of a formula and pressing F9 shows a partial result.

partial result

For large formulas, I typically copy and paste the formula into my favorite text editor. Not only does it show the match more clearly, but one keystroke (%) can jump to the other matching paren.

gVim paren matching

Indenting also helps.

indented in text editor

Presumably, other editors such as Notepad++ or Emacs could be used in the same way.

edit flag offensive delete link more
0

answered 2018-03-26 00:26:34 +0100

PAlotta gravatar image

Lupp, I did notice the cell grid editing will bold parenthesis pairs, but I should have been a little more detailed. Sometimes it is easier if pairs are highlighted in different colors to more easily discern their relationship. The bold highlighting in LO is sometimes a little difficult for me to see. I had gotten used to syntax highlighting in Notepad++ and have seen such highlighting elsewhere. Your suggestion about spaces is a good on and I have started to do this. Thanks.

Jim K, thanks for the F9 tip!

edit flag offensive delete link more

Comments

Yes. I also have problems to catch the highlighted "brother", and editing in a cell set to bold font I need to switch that off interim.
Concerning the multi-color dream I'm sceptical. At least with my formulae with many referencs, among them large ranges of different kind, I sometimes feel bedazzled and quit trying to rely on the colours.
My pipe-dream: A floating editor callable for complicated situations, offering lots of support on request.

Lupp gravatar imageLupp ( 2018-03-26 13:21:56 +0100 )edit

The Function Wizard exists.. Ctrl+F2 on an existing formula and you can step through the functions using the Next and Back buttons.

erAck gravatar imageerAck ( 2018-03-26 14:32:35 +0100 )edit

Yes. It's a different thing, however. Useful anyway.

Lupp gravatar imageLupp ( 2018-03-26 14:45:49 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2018-03-21 22:45:44 +0100

Seen: 209 times

Last updated: Mar 26 '18