Hi,

You can try to :
- remove all user-defined print areas
- force printing on one page

sub main

        dim doc as object
        dim aSheet as object

        doc = thisComponent
        aSheet = doc.sheets.getByIndex(0)

        'remove all user-defined print areas
        aSheet.automaticPrintArea = true
        'force printing on one page
        
doc.styleFamilies.getByName("PageStyles").getByName(aSheet.pageStyle).scaleToPages
 = 1

end sub

Regards
Thibault

----- Mail Original -----
De: "Lee" <[email protected]>
À: "dev" <[email protected]>
Envoyé: Mardi 20 Juillet 2010 11:50:39
Objet: [api-dev] How to remove the automatic page breaks in spreadsheet?

Hi everyone,


I'm trying to remove all page breaks in spreadsheet.
I can remove the manual page breaks by IsStartOfNewPage property.
But i don't know how to remove the automatic page breaks.


How can I do? 


Thanks for any hint




Best regards


Lee

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to