Ask Your Question

How do I get Calc to highlight the input, cell position for easier use?

asked 2019-12-04 14:55:31 +0100

LorieN63214 gravatar image

updated 2019-12-04 14:56:01 +0100

So, I am working on my budget in Calc and I keep having to confirm where I am at to input data by seeing which row and column is highlighted in the outside borders. It would be easier if the intersection of these two, the input cell, was highlighted. How do I set that up?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-12-04 17:39:05 +0100

Lupp gravatar image

Pendig feature request tdf#33201.

edit flag offensive delete link more


I remember that there were provisional solutions (workarounds) based on user code, but I cannot find one of them now.

Lupp gravatar imageLupp ( 2019-12-04 17:48:55 +0100 )edit

Found meanwhile the relevant example.
If you don't insist on persisting .CellBackColor by direct formatting, you can base a solution on the demo found here.

Lupp gravatar imageLupp ( 2019-12-04 18:44:59 +0100 )edit

answered 2019-12-04 17:43:28 +0100

Opaque gravatar image


there is no option to highlight the intersection of column and row (i.e the currently active cell). The only thing visible indication of the currently active cell is its black border with a small square at the lower right corner.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-12-04 14:55:31 +0100

Seen: 15 times

Last updated: Dec 04