Call "Cell style" dialogbox

[Mr.Dandy]

Hello,

Is it possible to call this dialogbox by macro?

[RoryOF]

I think only as individual items in com.sun.star.style.CharacterProperties , ...ParagraphProperties and ...CellProperties

[RoryOF]

https://www.openoffice.org/api/docs/com ... Style.html

Search for "OpenOffice API cellstyle".
You'll have to select what is relevant to you.

[B Marcelly]

Hi,
You can open the Styles and Formatting dialog with the dispatcher:

Code: Select all

dim document as object, dispatcher as object

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

The highlighted style is the style of the current cell.

[Mr.Dandy]

You can open the Styles and Formatting dialog with the dispatcher:

Second best solution
I wanted to avoid having to build my own dialog

Thanks