MediaWiki:Collections/Developer's Guide - Spreadsheet Documents
From Apache OpenOffice Wiki
OpenOffice.org Developer's Guide
Spreadsheet Documents
- Spreadsheet Documents
- Example: Adding a New Spreadsheet
- Example: Editing Spreadsheet Cells
- Handling Spreadsheet Documents Files
- Handling Spreadsheet Documents Files
- Saving Spreadsheet Documents
- Filter Options
- Printing Spreadsheet Documents
- Working With Spreadsheet Documents
- Working With Spreadsheet Documents
- Spreadsheet Services - Overview
- Capabilities of Spreadsheet
- Capabilities of SheetCellRange
- Capabilities of SheetCell
- Capabilities of SheetCellRanges Container
- Capabilities of Columns and Rows
- Spreadsheet
- Cell Ranges
- Properties of Cell Ranges
- Cell and Cell Range Access
- Merging Cell Ranges into a Single Cell
- Column and Row Access
- Data Array
- Absolute Address
- Fill Series
- Operations
- Multiple Operations
- Handling Array Formulas
- Cells
- Properties of SheetCell
- Access to Formulas, Values and Errors
- Access to Text Content
- Absolute Address
- Cell Annotations
- Cell Ranges and Cells Container
- Columns and Rows
- Formatting
- Character and Paragraph Format
- Indentation
- Equally Formatted Cell Ranges
- Table Auto Formats
- Conditional Formats
- Navigating
- Cell Cursor
- Referencing Ranges by Name
- Named Ranges
- Label Ranges
- Querying for Cells with Specific Properties
- Search and Replace
- Sorting
- Database Operations
- Filtering
- Subtotals
- Database Import
- Database Ranges
- Linking External Data
- Sheet Links
- Cell Area Links
- DDE Links
- DataPilot Tables
- Creating a New DataPilot Table
- Modifying a DataPilot Table
- Removing a DataPilot Table
- DataPilot Sources
- Source Object
- Dimensions
- Hierarchies
- Levels
- Members
- Protecting Spreadsheets
- Sheet Outline
- Detective
- Other Table Operations
- Overall Document Features
- Overall Document Features
- Function Handling
- Settings
- Spreadsheet Document Controller
- Spreadsheet Document Controller
- View Panes
- View Settings
- Range Selection
- Spreadsheet Add-Ins
- Spreadsheet Add-Ins
- Function Descriptions
- Service Names
- Compatibility Names
- Custom Functions
- Variable Results