Ask Your Question
0

Highlight current cell

asked 2018-11-15 18:08:27 +0200

ka3pmw gravatar image

I am running Calc Version: 6.1.2.1 (x64) on Windows 10. I need to highlight the current cell that the cursor is on.

Can someone please help me? I am able to do it with excel 2016, but that program has a problem with hyperlinks that Calc does not.

edit retag flag offensive close merge delete

Comments

I am able to do it with excel 2016

how?

Mike Kaganski gravatar imageMike Kaganski ( 2018-11-15 18:38:29 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2018-11-15 19:04:36 +0200

updated 2018-11-16 06:10:20 +0200

Well, personally I always simply do Shift+ArrowDown->ArrowUp... but possibly this could help:

Sub SelectCurrentCell
  Dim oDoc As Object
  oDoc = ThisComponent
  oDoc.getCurrentController().Select(oDoc.getCurrentSelection)
End Sub

EDIT: sorry - I misread "highlight" as "select". Well - there's a "Background color" button on the "Formatting" toolbar - doesn't it fit your needs?

edit flag offensive delete link more

Comments

This does not do the job. I'd like to be able to put a color in the cell I'm working in.

ka3pmw gravatar imageka3pmw ( 2018-11-15 21:07:53 +0200 )edit

No, I want to just change the color of the current cell so I can see exactly which dell I am working with.

ka3pmw gravatar imageka3pmw ( 2018-11-16 06:22:29 +0200 )edit
0

answered 2018-11-15 18:43:20 +0200

ka3pmw gravatar image

Mike, There is a macro that does it for excel but it does not work in calc.

edit flag offensive delete link more

Comments

Please don't "answer" with what is a comment (some discussion). E.g., I didn't use "answer" for my question, because that wasn't an answer to what you initially asked :-)

So, your question is about a macro then?

Mike Kaganski gravatar imageMike Kaganski ( 2018-11-15 18:48:45 +0200 )edit
0

answered 2018-11-16 17:37:02 +0200

m.a.riosv gravatar image

In the attached file there is a macro developed by Mauricio and Xixeme, in the Aoo Spanish forum
Highlight cell in use
(thread Resaltar fila acativa)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-15 18:08:27 +0200

Seen: 186 times

Last updated: Nov 16 '18