I’m writing a Macro that split the text of a range of cels (multiple columns and rows). When I use TextToColumns, always pop-up a preview dialog for each single cel.
dispatcher.executeDispatch(document, “.uno:TextToColumns”, “”, 0, Array())
I’ve already found some examples, that modify de last parameter (‘Array()’ → 'Array(MakePropertyValue( “Others”, “|” )’), to execute TextToColumns without the dialog, but that didn’t work in my case.