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.
Fill Series with range as start value
-
- Posts: 103
- Joined: Mon Sep 15, 2014 7:34 pm
Fill Series with range as start value
Win10-OpenOffice 4.1/LibreOffice 7.4
Re: Fill Series with range as start value
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 103
- Joined: Mon Sep 15, 2014 7:34 pm
Re: Fill Series with range as start value
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
-
- Posts: 103
- Joined: Mon Sep 15, 2014 7:34 pm
Re: Fill Series with range as start value
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
Re: Fill Series with range as start value
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
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice