Apache OpenOffice Community Forum

Posted: **Sat May 07, 2022 10:31 am**

Hi i am developing with libre calc.
I want to set optimal width automitically.
I recorded the macro.
It's like blow:

dispatcher.executeDispatch(document, ".uno:SetOptimalColumnWidthDirect", "", 0, Array())

Or

Code: Select all

dispatcher.executeDispatch(document, ".uno:SetOptimalColumnWidth", "", 0, Array())

But it didnt work with set property for SetOptimalColumnWidthDirect.

Can anyone help me on this one?

Posted: **Sat May 07, 2022 11:31 am**

IIRC I once recorded a macro to set View > Optimal width ..., and used Events to run the macro each time Writer opened a document. Does the same work in Calc?

Posted: **Sat May 07, 2022 2:08 pm**

What do you mean it didn't work?

SetOptimalColumnWidthDirect looks to always use the default value for the added width and ignore the aExtraWidth property value. As does this method:

Code: Select all

thiscomponent.sheets(0).columns(0).optimalwidth = true

(note just looked at this in OO not LO)

Posted: **Sat May 07, 2022 3:07 pm**

Just assign the following one-line-python to (→Rightclick Sheettab → Events →Content changed ):

Code: Select all

def optimal_width(event):
    event.Columns.OptimalWidth = True

Apache OpenOffice Community Forum

Set optimal width by C#

Set optimal width by C#

Re: How to set optimal width programmingly by C#

Re: How to set optimal width programmingly by C#

Re: How to set optimal width programmingly by C#