### [Solved] Can't make fillAuto work

Posted:

**Mon Dec 13, 2010 2:36 am**i'm trying to write Basic code that makes fillAuto work like fillhandle works on a sheet.

i'm trying to write the Basic equivalent of the following Java code i found on the net:

xSeries = getCellSeries(xSheet, "A7:G9");

xSeries.fillAuto(com.sun.star.sheet.FillDirection.TO_RIGHT, 2);

i put a formula in column B32 that correctly sums up column B.

now i'm trying to write Basic code that uses fillAuto to drag the formula to the 5 cells to the right:

osheet = ThisComponent.Sheets(0)

com.sun.star.sheet.xcellseries(osheet,"b32:b32").fillAuto(TO_RIGHT,5)

but i get error "method xcellseries not found".

i'm trying to learn how the OO0 object model works- i looked at the reference material,

but i don't see what i'm doing wrong.

thanks, and any insight and/or working Basic examples of the use of fillAuto would be appreciated.

i'm trying to write the Basic equivalent of the following Java code i found on the net:

xSeries = getCellSeries(xSheet, "A7:G9");

xSeries.fillAuto(com.sun.star.sheet.FillDirection.TO_RIGHT, 2);

i put a formula in column B32 that correctly sums up column B.

now i'm trying to write Basic code that uses fillAuto to drag the formula to the 5 cells to the right:

osheet = ThisComponent.Sheets(0)

com.sun.star.sheet.xcellseries(osheet,"b32:b32").fillAuto(TO_RIGHT,5)

but i get error "method xcellseries not found".

i'm trying to learn how the OO0 object model works- i looked at the reference material,

but i don't see what i'm doing wrong.

thanks, and any insight and/or working Basic examples of the use of fillAuto would be appreciated.