OOo Calc AutoFill (How to?)

nom · Posted: Mon Jan 19, 2004 2:10 pm Post subject: OOo Calc AutoFill (How to?)

I was reading throught the spreedsheat API pages and all the examples are in Java!

I am trying to use StarBasic with OOcalc to specify a row range and have the first row start with a DATE and then auto increment (either by day or by week, or by month) to fill in the specified range.

I could do this using a "for" loop but I am sure that there is a way of doing it elegantly in basic. (I actually saw how to do it in Java). Can anyone point me in the right direction?

Thanks,

nom

P.S: For example I would like to fill in the range "A1:A12" starting with 01/01/04 (1st of January) and finishing with 01/12/04 (1st of December)

dfrench · Posted: Mon Jan 19, 2004 2:58 pm Post subject:

Not elegant but you can use the dispatch ... I recorded this macro

nom · Posted: Mon Jan 19, 2004 11:25 pm Post subject:

Thanks dfrench,

Isn't there an easier way. I was reading through the API files and came across this:
http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellSeries.html#fillSeries

but how do I use it in Basic?

nom

If I manage to get it working I will post back.

dfrench · Posted: Tue Jan 20, 2004 10:02 am Post subject:

DannyB · Posted: Tue Jan 20, 2004 11:57 am Post subject:

nom · Posted: Wed Jan 21, 2004 9:54 pm Post subject:

OK I tried all of your codes, but none of them worked...

Did you try your code (dfrench and Danny) before posting, or was it off head?

Also How did you find out about all these arguments for this (and their meaning)

DannyB · Posted: Thu Jan 22, 2004 8:36 am Post subject:

I'm just following along, hoping to learn something about Calc. I rewrote dfrench's macro simply as an example of my subroutine. I did not try the original. The rewrite should be functionally identical.
_________________
Want to make OOo Drawings like the colored flower design to the left?

dfrench · Posted: Thu Jan 22, 2004 10:50 am Post subject:

Both my examples were tested on my environment. There is a slight difference in the function between the dispatch and api example ... in the api example, A1 must contain a value to be used in the fill down.

The codes used in the Dispatch example are as recorded so the meaning for the values relates to the action recorded ... I asked for an increment of month so FillDateCmd = "M" ... you could geuss some of the alternatives (perhaps Y for year or record the macro to get the other values). The value 1.70E+307 is probably the largest value that can be assigned ... in practice here it only needs to be equal or greater than the largest filled date.