Fill Series with range as start value

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
sokolowitzky
Posts: 103
Joined: Mon Sep 15, 2014 7:34 pm

Fill Series with range as start value

Post by sokolowitzky »

Hello to all,
I need to fill down some range with 62 rows and 72 columns.
But according to the tutorial "The method fillSeries() uses the first cell of each series as start value" [*]https://wiki.openoffice.org/wiki/Docume ... ill_Series[/*].

So it does not copy range only first row or column. Is there anyother way that you can suggest?

Thanks in advance.
Win10-OpenOffice 4.1/LibreOffice 7.4
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Fill Series with range as start value

Post by Villeroy »

fill down then right or vice versa.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
sokolowitzky
Posts: 103
Joined: Mon Sep 15, 2014 7:34 pm

Re: Fill Series with range as start value

Post by sokolowitzky »

I don't understand. do you mean manually? without a macro? I need to copy not the first rows of the range but all the rows.
Win10-OpenOffice 4.1/LibreOffice 7.4
sokolowitzky
Posts: 103
Joined: Mon Sep 15, 2014 7:34 pm

Re: Fill Series with range as start value

Post by sokolowitzky »

here I attach a file which shows the result that I need and the current behavior of the macro. maybe this can explain better.
Attachments
Fillit.ods
(11.97 KiB) Downloaded 133 times
Win10-OpenOffice 4.1/LibreOffice 7.4
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Fill Series with range as start value

Post by Villeroy »

if you cant get what you want manually, then you won't be successfull with the same method programmatically. You want to copy a range? Then do so.
http://www.openoffice.org/api/docs/comm ... #copyRange
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply