L.2.2 Sheets
Sheets are the central structures within a workbook, and are where a user does most of his spreadsheet work. The most common type of sheet is the worksheet, which is represented as a grid of cells. Worksheet cells can contain text, numbers, dates, and formulas. Cells can also be formatted. A workbook usually contains more than one sheet. To aid in the analysis of data and the making of informed decisions, spreadsheet applications often implement features and objects which help calculate, sort, filter, organize, and graphically display information. Since these features are often connected very tightly with the spreadsheet grid, these are also included in the sheet definition on disk.
Other types of sheets include chart sheets and dialog sheets.
Subsections
- L.2.2.1 Minimum Worksheet Scenario
- L.2.2.2 Example Sheet
- L.2.2.3 Sheet Properties
- L.2.2.4 Sheet Data
- L.2.2.5 Supporting Features
- L.2.2.6 Sheet Properties
- L.2.2.7 sheetData Cell Table
- L.2.2.8 Row
- L.2.2.9 Cell
- L.2.2.11 Defined Names
- L.2.2.12 AutoFilter
- L.2.2.13 Merged Cells
- L.2.2.14 Conditional Formatting
- L.2.3.1 Overview
- L.2.3.2 File Architecture
- L.2.3.3 Example: Plain Text
- L.2.3.4 Illustration
- L.2.3.5 The XML
- L.2.3.6 Shared String Table
- L.2.3.7 Cell Table
- L.2.3.8 Example: Rich Text
- L.2.3.10 Shared String Table
- L.2.4.1 Overview
- L.2.4.2 File Architecture
- L.2.4.3 Example: Table
- L.2.4.4 Illustration
- L.2.4.5 The Sheet XML
- L.2.4.6 The Table XML
- L.2.5.1 Overview
- L.2.5.2 Example
- L.2.6.1 Overview
- L.2.6.2 Example
- L.2.6.3 File Architecture
- L.2.6.4 The XML
- L.2.6.5 Authors
- L.2.6.6 Comments
- L.2.7.1 Overview
- L.2.7.2 File Architecture
- L.2.7.3 Organization in the Styles Part
- L.2.8.1 Overview
- L.2.8.2 File Architecture – Relationships
- L.2.8.3 Example
- L.2.9.1 Feature Overview
- L.2.9.2 File Architecture
- L.2.10.1 Overview
- L.2.10.2 How It Works
- L.2.10.3 Example
- L.2.11.1 Overview
- L.2.11.2 Web Query Example
- L.2.11.3 Text Import Example
- L.2.11.4 Access Table Example
- L.2.12.1 Overview
- L.2.12.2 OLAP Connection
- L.2.12.3 Pivot XML fragment
- L.2.12.4 Connection XML
- L.2.12.5 Web Query
- L.2.12.6 QueryTable XML
- L.2.12.7 Connection XML
- L.2.12.8 Unused Connection
- L.2.12.9 ODBC
- L.2.12.10 Connection XML
- L.2.12.11 SQL
- L.2.12.12 Connection XML
- L.2.12.13 Text Import
- L.2.12.14 Connection XML
- L.2.13.1 Overview
- L.2.13.2 Formula Example
- L.2.13.3 Sheet XML
- L.2.13.4 Workbook Relationships
- L.2.13.5 Supporting Workbook Cache
- L.2.13.6 External Link
- L.2.13.7 Supporting Workbook Cache
- L.2.13.8 External Link
- L.2.13.9 Hyperlink Example
- L.2.13.10 Worksheet XML
- L.2.13.11 Relationship
- L.2.14.1 Overview
- L.2.14.2 File Architecture - Relationships
- L.2.14.3 Example
- L.2.15.1 Overview
- L.2.15.2 File Architecture - Relationships
- L.2.15.3 Conceptual Model
- L.2.15.4 Example
- L.2.16.1 Introduction
- L.2.16.2 Constants
- L.2.16.3 Operators
- L.2.16.4 Cell References
- L.2.16.5 Functions
- L.2.16.6 Names
- L.2.16.7 Types and Values
- L.2.16.8 Error values
- L.2.16.10 XML Representation
- L.3.1.1 Introduction
- L.3.1.2 Basic Utilities
- L.3.1.3 The Presentation Object
- L.3.1.4 Presentation Properties
- L.3.2.1 Introduction
- L.3.2.2 Masters
- L.3.2.3 Presentation Slide
- L.3.2.4 Notes Page
- L.3.2.5 Slide Layouts
- L.3.3.1 Introduction
- L.3.3.2 Functional Overview
- L.3.3.3 Comment Author List
- L.3.3.4 Comment List
- L.3.4.1 Introduction
- L.3.4.2 Slide Transitions
- L.3.4.3 Timeline Overview
- L.3.4.4 Timeline Construction
- L.3.4.5 Animation Behaviors
- L.3.4.6 Conditional Properties
- L.3.4.7 Build Animations