[Solved] Set columns and rows autofix with code

[luofeiyu]

Set columns and rows autofix manually:

format--rows--optional height
format--columns--optional width

How can set columns and rows autofix with code?
Suppose that there are many ods file in the directory `data`,every ods workbook contains 10 worksheets in it.

[Zizi64]

Code: Select all

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

You can organize this API function into a program loop.