[Solved] Print range in Calc

[ANteC]

Hello. Please help me with OO Basic.

How i can set pring range (i have cellrange and need set it as one page for division into pages) ?

Sorry my English.

[Tribio]

Code: Select all

Dim oDoc as Object
Dim oPrintArea (0) as New com.sun.star.table.CellRangeAddress

...

oPrintArea (0).Sheet = 1
oPrintArea (0).StartColumn = 0
oPrintArea (0).StartRow = 0
oPrintArea (0).EndColumn = 5
oPrintArea (0).EndRow = 10

oDoc.Sheets.getByName ("Sheet 1").setPrintAreas (oPrintArea ())

This code will create a print range on the sheet named "Sheet 1". The range consists of the area A1:F11.

Hope this suits your needs.

[ANteC]

Thank you. There is what i need.