:: com :: sun :: star :: sheet ::

unpublished service Spreadsheet
Description
represents a complete spreadsheet in a spreadsheet document.

This service extents the service SheetCellRange. A spreadsheet is nothing else than a cell range with extended functionality.

See also
::com::sun::star::sheet::SpreadsheetDocument
Developers Guide
Included Services
::com::sun::star::sheet::SheetCellRange
Description
provides functionality for cell range handling.
::com::sun::star::sheet::Scenario
(referenced entity's summary:)
represents a scenario in a spreadsheet document.
Exported Interfaces
::com::sun::star::sheet::XSpreadsheet
Description
provides methods to create a cell cursor.
::com::sun::star::container::XNamed
Description
provides accessing the spreadsheet name.
::com::sun::star::util::XProtectable
Description
provides methods to protect and unprotect the sheet contents.
::com::sun::star::sheet::XDataPilotTablesSupplier
Description
provides access to the collection of DataPilot tables.
::com::sun::star::sheet::XScenariosSupplier
Description
provides access to the collection of scenarios.
::com::sun::star::sheet::XSheetAnnotationsSupplier
Description
provides access to the collection of annotations.
::com::sun::star::drawing::XDrawPageSupplier
Description
provides access to the draw page of this spreadsheet.
::com::sun::star::table::XTableChartsSupplier
Description
provides access to the collection of chart objects.
::com::sun::star::sheet::XCellRangeMovement
Description
provides methods to move cell ranges inside the spreadsheet or to other spreadsheets in this document.
::com::sun::star::sheet::XPrintAreas
Description
provides access to the print area settings of this sheet.
::com::sun::star::sheet::XSheetPageBreak
Description
provides access to the page breaks of this sheet.
::com::sun::star::sheet::XSheetOutline
Description
provides access to row and column outline settings.
::com::sun::star::sheet::XSheetAuditing
Description
provides access to the auditing (detective) functionality.
::com::sun::star::sheet::XSheetLinkable
Description
provides methods for a linked sheet.
Properties' Summary
boolean
IsVisible
specifies if the sheet is visible.  
string
PageStyle
specifies the page style of the sheet.  
boolean
AutomaticPrintArea
[ OPTIONAL ]
specifies whether the sheet has an automatic print area.  
Properties' Details
IsVisible
boolean IsVisible;
Description
specifies if the sheet is visible.
PageStyle
string PageStyle;
Description
specifies the page style of the sheet.
AutomaticPrintArea
boolean AutomaticPrintArea;
Usage Restrictions
optional
Description
specifies whether the sheet has an automatic print area.

The automatic print area is used to print a sheet without explicit print areas, also if other sheets have print areas.

If the property is true, and there are print areas on other sheets, the used area of this sheet is also printed.

If the property is false, and there are print areas on other sheets, only these specified print areas are printed.

If there are no print areas on the other sheets it does not matter whether property is true or false.

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.

See also
::com::sun::star::sheet::XPrintAreas

 
Top of Page