Ask Your Question
0

how can Calc be set to highlight the row of the active cell

asked 2017-11-12 20:04:54 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have many-columned worksheets that would be easier to read and update if the row of the active cell were high lighted from border to border. I understand how to highlight the row by clicking on the left most border (row number), but it doesn't stay highlighted when I move the cursor to a cell on the line.

Am using Win7 Pro and LInux Mint 17.3.

According to the document foundation this issue apparently has not been solved (tried the macros and could not get them to work). https://bugs.documentfoundation.org/s...

edit retag flag offensive close merge delete

Comments

Please state your OS so others can help you better. You can check your 'Options' under the Tools-menu. In the Calc -> General settings you can activate 'Highlight selection in column/row headers' this will indicate the cell position in the row and column indicator line.

Henk C. Meerhof gravatar imageHenk C. Meerhof ( 2017-11-13 19:48:54 +0100 )edit

I am using Win7 and LO Version: 5.3.4.2 - I can't replicate your problem. When I select a complete row or column, this will stay in it's selected color while I move the mouse over the cells. Highlighting first disappears when selecting a cell in that row/column.

Henk C. Meerhof gravatar imageHenk C. Meerhof ( 2017-11-13 19:49:45 +0100 )edit

@Henk: that option doesn't help much with wide sheets. What users want is depicted here and in this answer and most importantly, in this bug open since 2011. What's so difficult about changing the translucency of a row, boggles my mind, but I haven't worked with the LO codebase.

dandv gravatar imagedandv ( 2020-08-25 22:44:58 +0100 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2020-08-18 12:09:20 +0100

EJF gravatar image

I have a similar need to the original post of 13 Nov 2017:- "I have many-columned worksheets that would be easier to read and update if the row of the active cell were high lighted from border to border.".

What I found to give the same effect is to press Shift+Spacebar ... and the row containing the active cell is highlighted in light pink; likewise Ctrl + Spacebar highlights the column containing the active cell .... (from border to border in both cases).

Both commands are standard L/O Calc keyboard commands found under Tools > Customize > Keyboard in the top Menu line of Calc.

Using the horizontal and vertical scrollbars will retain the highlighted row (or column) when viewing columns ( or rows) that were outside the initial window.

Even though the above does not automatically highlight the row (or column) containing the active cell, I find it easy, practical, and effective.

edit flag offensive delete link more
2

answered 2017-11-14 01:18:11 +0100

Lupp gravatar image

updated 2017-11-14 02:08:18 +0100

It's a questionable approach to use "macros" for the purpose. How to do it and how to call the macro with the help of a listener is demonstrated here: https://forum.openoffice.org/en/forum...
The solution is only applicable to sheets that do not use hard (direct) cell formatting. To preserve directly assigned cell attributes would require to apply a conditional format to overlay the highlighting. There are complications and disadvantages, however, again.

(Editing:)
I added a demo how to use CF for the purpose to the above linked thread. Not actually recommended!

edit flag offensive delete link more

Comments

The demo is pretty cool, and I'll upvote because it directly answers the question. But yeah, probably not good for common use.

Jim K gravatar imageJim K ( 2017-11-14 16:35:53 +0100 )edit
1

answered 2017-11-13 22:33:21 +0100

Jim K gravatar image

updated 2017-11-13 22:35:41 +0100

Instead of highlighting the row, create a cell style that has a background color.

Then go to Format -> Conditional Formatting. Input a formula for alternate rows to use the style, as explained at https://ask.libreoffice.org/en/questi....

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-11-12 20:04:54 +0100

Seen: 5,513 times

Last updated: Aug 18