MediaWiki:Collections/Developer's Guide - Spreadsheet Documents

From Apache OpenOffice Wiki
Jump to: navigation, search

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
Personal tools