[Solved] Macro Calc to deselect all cells

ghizzo74 · Post by **ghizzo74** » Sun Mar 06, 2016 10:12 am

Hi!

I've not found a example wich show me how to deselect ALL the selected cells in the current sheet using a Macro.... Can someone help me?

Thanks a lot in advance!

edit this topic's initial post · Post by **Villeroy** » Sun Mar 06, 2016 10:53 am

Code: Select all

dummy = ThisComponent.createInstance("com.sun.star.sheet.SheetCellRanges")
view = ThisComponent.getCurrentController()
view.select(dummy)

ghizzo74 · Post by **ghizzo74** » Sun Mar 06, 2016 1:27 pm

Thanks Villeroy!

It works nicely....in the meanwhile i've found an alternative way using the Uno API

Code: Select all


document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dispatcher.executeDispatch(document, ".uno:Deselect", "", 0, array())

[Solved] Macro Calc to deselect all cells

[Solved] Macro Calc to deselect all cells

Re: Macro Calc to deselect all cells

Re: [SOLVED] Macro Calc to deselect all cells