Ask Your Question

FillDown using macros?

asked 2016-11-13 09:44:42 +0200

error0x6b gravatar image

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)

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-11-13 11:54:12 +0200

karolus gravatar image

updated 2016-11-13 11:58:53 +0200

try with:

o.fillAuto( 0, 1 )
edit flag offensive delete link more


See also:
Concerning the parameters controlling FillDirection and FillMode (this one only used by FillSeries method) there are predefined constants.

Lupp gravatar imageLupp ( 2016-11-13 12:41:29 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-13 09:44:42 +0200

Seen: 62 times

Last updated: Nov 13 '16