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.
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.
I am able to do it with excel 2016
how?
Mike,
There is a macro that does it for excel but it does not work in calc.
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?
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?
This does not do the job. I’d like to be able to put a color in the cell I’m working in.
No, I want to just change the color of the current cell so I can see exactly which dell I am working with.
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)