FillDown using macros?

I have the following range-object (a row with a bunch of columns):

dim o as object
o = ThisComponent.Sheets.getByName("DATA").getCellRangeByPosition(0,1767,40,1767)

How do I now FillDown the contents of this row (for 10 rows)?

In VBA the range seems to have a FillDown Method, so I tried it like this:

dim o as object
o = ThisComponent.Sheets.getByName("DATA").getCellRangeByPosition(0,1767,40,1778)
o.FillDown()

but FillDown does not exist. So how to do this?

try with:

o.fillAuto( 0, 1 )
1 Like

See also: http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XCellSeries.html
Concerning the parameters controlling FillDirection and FillMode (this one only used by FillSeries method) there are predefined constants.