Basic Programming Examples

Inserting a Graphic From a File

Inserting Graphics From the Gallery With Drag-and-Drop

Inserting a Scanned Image

Inserting a Calc Chart into a Text Document

Inserting Graphics From Office Draw or Impress

Tables in Text Documents

Turning Number Recognition On or Off in Tables

Modifying Rows and Columns by Keyboard

Deleting Tables or the Contents of a Table

Inserting Tables

Repeating a Table Header on a New Page

Resizing Rows and Columns in a Text Table

Objects in Text Documents

Positioning Objects

Wrapping Text Around Objects

Sections and Frames in Text Documents

Using Sections

Inserting, Editing and Linking Frames

Editing Sections

Inserting Sections

Tables of Contents and Indexes

Chapter Numbering

User-Defined Indexes

Creating a Table of Contents

Creating Alphabetical Indexes

Indexes Covering Several Documents

Creating a Bibliography

Editing or Deleting Index and Table Entries

Updating, Editing and Deleting Indexes and Tables of Contents

Defining Index or Table of Contents Entries

Formatting an Index or a Table of Contents

Fields in Text Documents

About Fields

Inserting a Fixed or Variable Date Field

Converting a Field into Text

Calculating in Text Documents

Calculating Across Tables

Calculating in Text Documents

Calculating and Pasting the Result of a Formula in a Text Document

Calculating Cell Totals in Tables

Calculating Complex Formulae in Text Documents

Displaying the Result of a Table Calculation in a Different Table

Special Text Elements

Using Captions

Conditional Text

Conditional Text for Page Counts

Inserting a Fixed or Variable Date Field

Adding Input Fields

Inserting Page Numbers of Continuation Pages

Inserting Page Numbers in Footers

Hiding Text

Defining Different Headers and Footers

Inserting a Chapter Name and Number in a Header or a Footer

Querying User Data in Fields or Conditions

Inserting and Editing Footnotes or Endnotes

Spacing Between Footnotes

About Headers and Footers

Formatting Headers or Footers

Animating Text

Creating a Form Letter

Automatic Functions

Adding Exceptions to the AutoCorrect List

Using AutoText

Creating Numbered or Bulleted Lists as You Type

Turning Off AutoCorrect

Automatically Check Spelling

Turning Number Recognition On or Off in Tables

Hyphenation

Numbering and Lists

Adding Chapter Numbers to Captions

Creating Numbered or Bulleted Lists as You Type

Chapter Numbering

Changing the List Level of a List Paragraph

Combining Numbered Lists

Adding Line Numbers

Modifying Numbering in an Ordered List

Defining Number Ranges

Adding Numbering

Numbering and Paragraph Styles

Adding Bullets

Spell Checking, Thesaurus and Languages

Automatically Check Spelling

Removing Words From a User-Defined Dictionary

Thesaurus

Checking Spelling Manually

Troubleshooting Tips

Inserting Text Before a Table at the Top of Page

Going to Specific Bookmark

Loading, Saving, Importing, Exporting and Redacting

Saving Text Documents in HTML Format

Inserting an Entire Text Document

Redaction

Automatic Redaction

Master Documents

Master Documents and Sub-documents

Links and References

Inserting Cross-References

Inserting Hyperlinks With the Navigator

Printing

Selecting What to Print

Selecting printer paper trays

Previewing a Page Before Printing

Printing Multiple Pages on One Sheet

Creating and Applying Page Styles

Searching and Replacing

Using Regular Expressions in Text Searches

List of Regular Expressions

HTML Documents (Writer Web)

Web Pages

HTML Filters and Forms

Saving Text Documents in HTML Format

Spreadsheets (Calc)

General Information and User Interface Usage

Office Calc Features

Shortcut Keys (Office Calc Accessibility)

Shortcut Keys for Spreadsheets

Error Codes in Office Calc

Add-in for Programming in Office Calc

Instructions for Using Office Calc

Command and Menu Reference

Menus

Toolbars

Drawing Object Properties Bar

Functions Types and Operators

Function Wizard

Functions by Category

Array Functions

Bit Operation Functions

Database Functions

Date & Time Functions

Financial Functions Part One

Financial Functions Part Two

Financial Functions Part Three

Information Functions

Logical Functions

Mathematical Functions

Statistics Functions

Statistical Functions Part One

Statistical Functions Part Two

Statistical Functions Part Three

Statistical Functions Part Four

Statistical Functions Part Five

Spreadsheet Functions

Text Functions

Add-in Functions

Add-in Functions, List of Analysis Functions Part One

Add-in Functions, List of Analysis Functions Part Two

Operators in Office Calc

User-Defined Functions

Loading, Saving, Importing, Exporting and Redacting

Inserting External Data in Table (WebQuery)

Saving and Opening Sheets in HTML

Importing and Exporting Text Files

Redaction

Automatic Redaction

Formatting

Rotating Text

Writing Multi-line Text

Formatting Numbers as Text

Text Superscript / Subscript

Changing Row Height or Column Width

Applying Conditional Formatting

Highlighting Negative Numbers

Assigning Formats by Formula

Entering a Number with Leading Zeros

Formatting Spreadsheets

Formatting Numbers With Decimals

Naming Cells

Rotating Tables (Transposing)

Renaming Sheets

19xx/20xx Years

Using Rounded Off Numbers

Cells in Currency Format

Using AutoFormat for Tables

Inserting and Editing Comments

Selecting Themes for Sheets

Entering Fractions

Filtering and Sorting

Applying Filters

Applying Advanced Filters

Applying AutoFilter

Applying Sort Lists

Removing Duplicate Values

Printing

Printing Rows or Columns on Every Page

Printing Sheets in Landscape Format

Printing Sheet Details

Defining Number of Pages for Printing

Data Ranges

Defining Database Ranges

Filtering Cell Ranges

Sorting Data

Pivot Table

Creating Pivot Tables

Deleting Pivot Tables

Editing Pivot Tables

Filtering Pivot Tables

Selecting Pivot Table Output Ranges

Updating Pivot Tables

Pivot Chart

Creating Pivot Charts

Editing Pivot Charts

Filtering Pivot Charts

Pivot Chart Update

Deleting Pivot Charts

Scenarios

Using Scenarios

Subtotals

Using Subtotals Tool

References

Addresses and References, Absolute and Relative

Referencing a Cell in Another Document

References to Other Sheets and Referencing URLs

Referencing Cells by Drag-and-Drop

Recognising Names as Addressing

Viewing, Selecting, Copying

Changing Table Views

Displaying Formulae or Values

Freezing Rows or Columns as Headers

Navigating Through Sheet Tabs

Copying to Multiple Sheets

Only Copy Visible Cells

Selecting Multiple Cells

Formulae and Calculations

Calculating With Formulae

Copying Formulae

Entering Formulae

Displaying Formulae or Values

Calculating in Spreadsheets

Calculating With Dates and Times

Automatically Calculating Series

Calculating Time Differences

Entering Matrix Formulae

Using Wildcards in Formulas

Protection

Protecting Cells from Changes

Unprotecting Cells

Miscellaneous

Deactivating Automatic Changes

Consolidating Data

Applying Goal Seek

Solver

Applying Multiple Operations

Applying Multiple Sheets

Validity of Cell Content

Presentations (Impress)

General Information and User Interface Usage

Office Impress Features

Using Shortcut Keys in Office Impress

Shortcut Keys for Office Impress

Presenter Console Keyboard Shortcuts

Instructions for Using Office Impress

Command and Menu Reference

Menus

Toolbars

Loading, Saving, Importing, Exporting and Redacting

Saving a Presentation in HTML Format

Importing HTML Pages Into Presentations

Exporting Animations in GIF Format

Including Spreadsheets in Slides

Insert Slide from File

Redaction

Automatic Redaction

Formatting

Arranging, Aligning and Distributing Objects

Defining Custom Colours

Creating Gradient Fills

Replacing Colours

Changing the Slide Background Fill

Adding a Header or a Footer to All Slides

Changing and Adding a Master Page

Printing a Slide to Fit a Paper Size

Printing

Printing Presentations

Effects

Exporting Animations in GIF Format

Animating Objects in Presentation Slides

Animating Slide Transitions

Cross-Fading Two Objects

Creating Animated GIF Images

Objects, Graphics and Bitmaps

Combining Objects and Constructing Shapes

Grouping Objects

Drawing Sectors and Segments

Duplicating Objects

Transformations

Rotating Objects

Assembling 3-D Objects

Connecting Lines

Converting Bitmap Images into Vector Graphics

Converting 2-D Objects to Curves, Polygons, and 3-D Objects

Drawing Curves

Editing Curves

Including Spreadsheets in Slides

Selecting Underlying Objects

Creating a Flowchart

Text in Presentations

Adding Text

Using the Presenter Console

Viewing

Changing the Slide Order

Zooming With the Keypad

Slide Shows

Showing a Slide Show

Impress Remote Guide

Creating a Custom Slide Show

Rehearse Timings of Slide Changes

Drawings (Draw)

General Information and User Interface Usage

Office Draw Features

Shortcut Keys for Drawing Objects

Shortcut Keys for Drawings

Instructions for Using Office Draw

Command and Menu Reference

Menus

Toolbars

Loading, Saving, Importing and Exporting

Formatting

Arranging, Aligning and Distributing Objects

Defining Custom Colours

Creating Gradient Fills

Replacing Colours

Changing the Slide Background Fill

Changing and Adding a Master Page

Printing a Slide to Fit a Paper Size

Printing

Printing Presentations

Effects

Cross-Fading Two Objects

3-D Effects

Transformations

Objects, Graphics and Bitmaps

Combining Objects and Constructing Shapes

Drawing Sectors and Segments

Duplicating Objects

Rotating Objects

Assembling 3-D Objects

Connecting Lines

Converting Bitmap Images into Vector Graphics

Converting 2-D Objects to Curves, Polygons, and 3-D Objects

Drawing Curves

Editing Curves

Including Spreadsheets in Slides

Selecting Underlying Objects

Groups and Layers

Moving Objects to a Different Layer

Text in Drawings

Adding Text