<html> <head> <title>Service Spreadsheet</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="Spreadsheet-xref.html" class="navimain">Use</a></td> <td class="navimain"><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Spreadsheet_Services_-_Overview" class="navimain">Devguide</a></td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#IncludedServices" class="navisub">Included Services</a></td> <td class="navisub"><a href="#ExportedInterfaces" class="navisub">Exported Interfaces</a></td> <td class="navisub"><a href="#PropertiesSummary" class="navisub">Properties' Summary</a></td> <td class="navisub"><a href="#PropertiesDetails" class="navisub">Properties' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sheet</a> :: </p> </td> </tr> <tr> <td class="title"><table class="title-table" width="99%"> <tr> <td width="25%" class="title2">unpublished </td> <td width="50%" class="title">service Spreadsheet</td> <td width="*"/></tr> </table> </td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>represents a complete spreadsheet in a spreadsheet document. </dd> <dd><p>This service extents the service SheetCellRange. A spreadsheet is nothing else than a cell range with extended functionality.</p> </dd> <dt><b>See also</b></dt> <dd><a href="SpreadsheetDocument.html">SpreadsheetDocument</a></dd> </dl> <a name="devmanual"> </a><dl> <dt><b>Developers Guide</b></dt> <dd><a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Spreadsheet_Services_-_Overview">Spreadsheets - Spreadsheet Services - Overview</a></dd> </dl> </td> </tr> </table> <hr> <a name="IncludedServices"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Included Services</td> </tr> <tr> <td class="imsum_left"><a href="SheetCellRange.html">SheetCellRange</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides functionality for cell range handling. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="Scenario.html">Scenario</a></td> <td class="imsum_right"><dl> <dt>(referenced entity's summary:)</dt> <dd>represents a scenario in a spreadsheet document. </dd> </dl> </td> </tr> </table> <a name="ExportedInterfaces"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Exported Interfaces</td> </tr> <tr> <td class="imsum_left"><a href="XSpreadsheet.html">XSpreadsheet</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides methods to create a cell cursor. </dd> </dl> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../container/module-ix.html">container</a>::<a href="../container/XNamed.html">XNamed</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides accessing the spreadsheet name. </dd> </dl> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../util/module-ix.html">util</a>::<a href="../util/XProtectable.html">XProtectable</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides methods to protect and unprotect the sheet contents. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XDataPilotTablesSupplier.html">XDataPilotTablesSupplier</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to the collection of DataPilot tables. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XScenariosSupplier.html">XScenariosSupplier</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to the collection of scenarios. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XSheetAnnotationsSupplier.html">XSheetAnnotationsSupplier</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to the collection of annotations. </dd> </dl> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../drawing/module-ix.html">drawing</a>::<a href="../drawing/XDrawPageSupplier.html">XDrawPageSupplier</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to the draw page of this spreadsheet. </dd> </dl> </td> </tr> <tr> <td class="imsum_left">::com::sun::star::<a href="../table/module-ix.html">table</a>::<a href="../table/XTableChartsSupplier.html">XTableChartsSupplier</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to the collection of chart objects. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XCellRangeMovement.html">XCellRangeMovement</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides methods to move cell ranges inside the spreadsheet or to other spreadsheets in this document. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XPrintAreas.html">XPrintAreas</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to the print area settings of this sheet. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XSheetPageBreak.html">XSheetPageBreak</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to the page breaks of this sheet. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XSheetOutline.html">XSheetOutline</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to row and column outline settings. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XSheetAuditing.html">XSheetAuditing</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides access to the auditing (detective) functionality. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XSheetLinkable.html">XSheetLinkable</a></td> <td class="imsum_right"><dl> <dt><b>Description</b></dt> <dd>provides methods for a linked sheet. </dd> </dl> </td> </tr> <tr> <td class="imsum_left"><a href="XExternalSheetName.html">XExternalSheetName</a></td> <td class="imsum_right"><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>provides a method to set an external name at the sheet. </dd> <dt><b/></dt> <dd/></dl> </td> </tr> </table> <a name="PropertiesSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Properties' Summary</td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#IsVisible">IsVisible</a></td> <td class="imsum_right">specifies if the sheet is visible. </td> </tr> <tr> <td class="imsum_left">string<br> <a href="#PageStyle">PageStyle</a></td> <td class="imsum_right">specifies the page style of the sheet. </td> </tr> <tr> <td class="imsum_left">short<br> <a href="#TableLayout">TableLayout</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies the direction of the columns in the spreadsheet. </td> </tr> <tr> <td class="imsum_left">boolean<br> <a href="#AutomaticPrintArea">AutomaticPrintArea</a></td> <td class="imsum_right"><b>[ OPTIONAL ]<br> </b>specifies whether the sheet has an automatic print area. </td> </tr> </table> <a name="PropertiesDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Properties' Details</td> </tr> <tr> <td class="imdetail"><a name="IsVisible" class="membertitle">IsVisible</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>IsVisible</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies if the sheet is visible. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="PageStyle" class="membertitle">PageStyle</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>string <b>PageStyle</b>;<hr> <dl> <dt><b>Description</b></dt> <dd>specifies the page style of the sheet. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="TableLayout" class="membertitle">TableLayout</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>short <b>TableLayout</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies the direction of the columns in the spreadsheet. </dd> <dd><p>Possible values are com::sun::star::text::WritingMode2::LR_TB to order the columns from left to right, and com::sun::star::text::WritingMode2::RL_TB to order the columns from right to left.</p> </dd> <dt><b>See also</b></dt> <dd>::com::sun::star::<a href="../text/module-ix.html">text</a>::<a href="../text/WritingMode2.html">WritingMode2</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="AutomaticPrintArea" class="membertitle">AutomaticPrintArea</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>boolean <b>AutomaticPrintArea</b>;<hr> <dl> <dt><b>Usage Restrictions</b></dt> <dd><i>optional</i></dd> <dt><b>Description</b></dt> <dd>specifies whether the sheet has an automatic print area. </dd> <dd><p> The automatic print area is used to print a sheet without explicit print areas, also if other sheets have print areas.</p> <p> If the property is true, and there are print areas on other sheets, the used area of this sheet is also printed.</p> <p> If the property is false, and there are print areas on other sheets, only these specified print areas are printed.</p> <p> If there are no print areas on the other sheets it does not matter whether property is true or false.</p> <p> This property can only be true, if there are no print areas given on this sheet. If the property is set to true the print areas of this sheet will be removed.</p> </dd> <dt><b>See also</b></dt> <dd><a href="XPrintAreas.html">XPrintAreas</a></dd> </dl> </td> </tr> </table> </td> </tr> </table> <br> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2008 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>
distrib
>
Mandriva
>
2008.1
>
x86_64
>
media
>
main-testing
>
by-pkgid
>
2c50825dd66d0497b96a67f7fab2ee84
>
files
>
5726
