[Solved] Draw Border To Multiple Sheets at the same time

[npandit]

I have been using this line to get a specific sheet to work with it
oSheet = oDoc.getSheets().getByIndex(0)
With the above line it draws border only to specified index sheet
But I want to use multiple sheets to draw border at the same time
How to do that ?

[musikai]

Hi,

either you specify which sheets you want by changing the last number:

Code: Select all

oDoc=ThisComponent
oSheet = oDoc.getSheets().getByIndex(0)
rem  do something
oSheet = oDoc.getSheets().getByIndex(1)
rem  do something

Or you can change all one by one:

Code: Select all

oDoc=ThisComponent
for i=0 to oDoc.getsheets().count-1
oSheet = oDoc.getsheets().getbyindex(i)
rem  do something
next i

[Villeroy]

This is what templates are about. All office suites are mainly about templates. Generating new documents by means of program code is stupid even if you were able to program.

[npandit]

Hey
Thanks the For Loop worked .
But its applying border to all sheets now
I want to apply border from 2nd sheet till so on
i dont want border on the first sheet.
Can u please suggest code to apply border for all sheets except the first sheet?

[Zizi64]

If you are a programmer, you must know the solution method.

Just start the Loop from 1 instead of the 0

Or you can apply a different Style to the first Sheet. Always work with styles instead of the direct formatting properties!
The Styles is the most valable property of the AOO/LO.

Or simple open a preformatted Template by your program code, - as Villeroy suggested. Use the Styles for the formating the Template.

[npandit]

Thanks ZiZi
Thanks for the help means a lot
We all are learners here