Hi Thibault,
Your answer is very helpful for me. Thank you!!
Best regards
Lee
>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]
>
