| View previous topic :: View next topic |
| Author |
Message |
lixiang
Newbie
Joined: 09 Oct 2009
Posts: 2
|
 Posted: Fri Oct 09, 2009 1:00 am Post subject: How to select two sheets in SpreadsheetDocument? |
 |
|
i want to select two sheets and print them. i think XMultiSelectionSupplier may be useful, but i don't know how to get an instance of XMultiSelectionSupplier.
Help me!! Thank you!! |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Oct 09, 2009 1:37 am Post subject: |
|
|
Create a c.s.s.sheet.SheetCellRanges collection from the document, add range addresses from more than one sheet and pass the SheetCellRanges to the controller's select method.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
lixiang
Newbie
Joined: 09 Oct 2009
Posts: 2
|
| Posted: Fri Oct 09, 2009 2:53 am Post subject: |
|
|
| Villeroy wrote: | | Create a c.s.s.sheet.SheetCellRanges collection from the document, add range addresses from more than one sheet and pass the SheetCellRanges to the controller's select method. |
would you give me an example? thank you! |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Oct 09, 2009 3:16 am Post subject: |
|
|
Come on! You don't even tell us your office version or the language you are using. My answer is as short as your question. You can look up com.sun.star.sheet.SheetCellRanges with all it's properties and methods in the API documentation or using the object inspector of your choice.
http://www.oooforum.org/forum/search.phtml gives dozends of examples for SHeetCellRanges
The volunteers on this forum are no human macro recorders 
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
