Text Documents (Writer)

General Information and User Interface Usage

Office Writer Features

Instructions for Using Office Writer

Docking and Resizing Windows

Shortcut Keys for Office Writer

Using Shortcut Keys (Office Writer Accessibility)

Command and Menu Reference

Menus

Toolbars

Drawing Object Properties Bar

Bullets and Numbering Bar

Status Bar (Writer)

Text Object Bar

Form Navigation Bar

Query Design Bar

Form Design Toolbar

LibreLogo Toolbar

Navigating Text Documents

Navigating and Selecting With the Keyboard

Moving and Copying Text in Documents

Rearranging a Document by Using the Navigator

Inserting Hyperlinks With the Navigator

Navigator for Text Documents

Using the Direct Cursor

Formatting Text Documents

Changing Page Orientation (Landscape or Portrait)

Changing the Case of Text

Defining Different Headers and Footers

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

Applying Text Formatting While You Type

Resetting Font Attributes

Applying Styles in Fill Format Mode

Wrapping Text Around Objects

Using a Frame to Centre Text on a Page

Emphasising Text

Inserting and Deleting Page Breaks

Creating and Applying Page Styles

Making Text Superscript or Subscript

Templates and Styles

Templates and Styles

Alternating Page Styles on Odd and Even Pages

Creating a Page Style Based on the Current Page

Using Styles From Another Document or Template

Creating New Styles From Selections

Updating Styles From Selections

Creating and Changing Default and Custom Templates

Template Manager

Graphics in Text Documents

Inserting Graphics

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

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

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

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

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

Creating a Form Letter

Automatic Functions

Adding Exceptions to the AutoCorrect List

Creating Numbered or Bulleted Lists as You Type

Turning Off AutoCorrect

Automatically Check Spelling

Turning Number Recognition On or Off in Tables

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

Spell Checking, Thesaurus and Languages

Automatically Check Spelling

Removing Words From a User-Defined Dictionary

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

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)

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

Text Formatting Bar

Print Preview Bar

Form Navigation Bar

Query Design Bar

Form Design Toolbar

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

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

Automatic Redaction

Formatting

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

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

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

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

Line and Filling Bar

Text Formatting Bar

Slide Sorter Bar

Form Navigation Bar

Form Design Toolbar

Edit Points Bar

Loading, Saving, Importing, Exporting and Redacting

Saving a Presentation in HTML Format

Importing HTML Pages Into Presentations

Loading Colour, Gradient, and Hatching Lists

Exporting Animations in GIF Format

Including Spreadsheets in Slides

Inserting Graphics

Insert Slide from File

Automatic Redaction

Formatting

Loading Colour, Gradient, and Hatching Lists

Loading Line and Arrow Styles

Defining Custom Colours

Creating Gradient Fills

Replacing Colours

Arranging, Aligning and Distributing Objects

Changing the Slide Background Fill

Adding a Header or a Footer to All Slides

Changing and Adding a Master Page

Printing

Printing Presentations

Printing a Slide to Fit a Paper Size

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 Text Characters into Drawing Objects

Converting Bitmap Images into Vector Graphics

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

Loading Line and Arrow Styles

Inserting Graphics

Including Spreadsheets in Slides

Selecting Underlying Objects

Creating a Flowchart

Text in Presentations

Converting Text Characters into Drawing Objects

Viewing

Changing the Slide Order

Zooming With the Keypad

Slide Shows

Showing a Slide Show

Using the Presenter Console

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

View (menu in Draw)

Toolbars

Form Navigation Bar

Form Design Toolbar

Edit Points Bar

Loading, Saving, Importing and Exporting

Loading Colour, Gradient, and Hatching Lists

Inserting Graphics

Formatting

Loading Colour, Gradient, and Hatching Lists

Loading Line and Arrow Styles

Defining Custom Colours

Creating Gradient Fills

Replacing Colours

Arranging, Aligning and Distributing Objects

Changing the Slide Background Fill

Changing and Adding a Master Page

Printing

Printing Presentations

Printing a Slide to Fit a Paper Size

Effects

Cross-Fading Two Objects

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 Text Characters into Drawing Objects

Converting Bitmap Images into Vector Graphics

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

Loading Line and Arrow Styles

Inserting Graphics

Including Spreadsheets in Slides

Selecting Underlying Objects

Creating a Flowchart

Groups and Layers

Grouping Objects

Inserting Layers

Working With Layers

Moving Objects to a Different Layer

Text in Drawings

Converting Text Characters into Drawing Objects

Viewing

Zooming With the Keypad

Database Functionality (Base)

General Information

Office Database

Database Overview

Creating a New Database

Working with Tables

Working with Queries

Working with Forms

Creating Reports

Registering and Deleting a Database

Importing and Exporting Data in Base

Executing SQL Commands

Formulae (Math)

General Information and User Interface Usage

Office Math Features

Instructions for Using Office Math

Shortcuts (Office Math Accessibility)

Office Formula Elements

Unary/Binary Operators

Command and Menu Reference

Working with Formulae

Manually Aligning Formula Parts

Changing Default Attributes

Merging Formula Parts in Brackets

Entering Comments

Entering Line Breaks

Inserting Brackets

Charts and Diagrams

General Information

Charts in Office

Office Chart Features

Shortcuts for Charts

Macros and Scripting

Office BASIC

General Information and User Interface Usage

Office Basic Help

Programming with Office Basic

Office Basic Glossary

Office Basic IDE

The Basic Editor

Support for VBA Macros

Command Reference

Compiler Options

Using Procedures, Functions or Properties

Libraries, Modules and Dialogs

Syntax Diagrams

Guides

Recording a Macro

Changing the Properties of Controls in the Dialog Editor

Creating Controls in the Dialog Editor

Programming Examples for Controls in the Dialog Editor

Opening a Dialog With Basic

Creating a Basic Dialog

Organising Libraries and Modules

Using Variables

Debugging a Basic Program

Document Event-Driven Macros

Basic Programming Examples

Basic to Python

Python Scripts Help

General Information and User Interface Usage

Python Scripts Organisation

Python Interactive Shell

Programming with Python

Python : Programming with Python

Python examples

Python to Basic

Script Development Tools

Development Tools

Office Installation

Changing the Association of Microsoft Office Document Types

Common Help Topics

General Information

General Glossary

Glossary of Internet Terms

Accessibility in Office

Shortcuts (Office Accessibility)

General Shortcut Keys in Office

Versions and Build Numbers

Office and Microsoft Office

Using Microsoft Office and Office

Comparing Microsoft Office and Office Terms

About Converting Microsoft Office Documents

Changing the Association of Microsoft Office Document Types

Office Options

Application Colours

Expert Configuration

Load/Save options

Internet options

Text Document Options

HTML Document Options

Spreadsheet Options

Presentation Options

Drawing Options

Microsoft Office

Languages (Options)

Language Setting Options

Data sources options

Wizards

Euro Converter Wizard

Letter Wizard

Fax Wizard

Agenda Wizard

HTML Export Wizard

Document Converter Wizard

Document Converter

Configuring Office

Configuring Office

Extension Manager

Changing Icon Views

Adding Buttons to Toolbars

Changing Your Working Directory

Creating and Changing Default and Custom Templates

Registering an Address Book

Inserting and Editing Buttons

Working with the User Interface

Navigation to Quickly Reach Objects

Navigator for Document Overview

Showing, Docking and Hiding Windows

Switching Between Insert Mode and Overwrite Mode

Digital Signatures

About Digital Signatures

Applying Digital Signatures

PDF Export Digital Signature

Time Stamp Authorities for Digital Signatures

Signing Existing PDF

Adding Signature Line in Documents

Signing the Signature Line

Printing, Faxing, Sending

Printing Address Labels

Printing in Black and White

Sending Documents as Email

Sending Faxes and Configuring Office for Faxing

Drag & Drop

Dragging-and-Dropping Within a Office Document

Moving and Copying Text in Documents

Copying Spreadsheet Areas to Text Documents

Copying Graphics Between Documents

Copying Graphics From the Gallery

Drag-and-Drop With the Data Source View

Copy and Paste

Copying Drawing Objects Into Other Documents

Copying Graphics Between Documents

Copying Graphics From the Gallery

Copying Spreadsheet Areas to Text Documents

Charts and Diagrams

Inserting Charts

Charts in Office

Load, Save, Import, Export, PDF

Opening Documents

Opening documents saved in other formats

Saving Documents

Saving Documents Automatically

Saving Documents in Other Formats

Importing and Exporting Data in Text Format

Links and References

Inserting Hyperlinks

Relative and Absolute Links

Editing Hyperlinks

Document Version Tracking

Comparing Versions of a Document

Merging Versions

Recording Changes

Recording and Displaying Changes

Accepting or Rejecting Changes

Version Management

Labels and Business Cards

Creating and Printing Labels and Business Cards

Inserting External Data

Inserting Data From Spreadsheets

Inserting Data From Text Documents

Inserting, Editing, Saving Bitmaps

Adding Graphics to the Gallery

Automatic Functions

Turning off Automatic URL Recognition

Searching and Replacing

Searching With a Form Filter

Searching Tables and Form Documents

List of Regular Expressions

Guides

Applying Line Styles

Changing the Colour of Text

Changing the Title of a Document

Creating Round Corners

Defining Background Colours or Background Graphics

Defining Line Ends

Defining Line Styles

Editing Graphic Objects

Drawing Lines in Text

Inserting Objects From the Gallery

Inserting Non-breaking Spaces, Hyphens and Soft Hyphens

Inserting Special Characters

Inserting and Editing Tab Stops

Using Remote Files

Protecting Content in Office

Protecting Records

Selecting the Maximum Printable Area on a Page

Selecting Measurement Units

Selecting the Document Language

Turning off Bullets and Numbering for Individual Paragraphs

Calculating Time Differences

If you want to calculate time differences, for example, the time between 23:30 and 01:10 in the same night, use the following formula:

=(B2<a2)+b2-a2< p=""> </a2)+b2-a2<>

The later time is B2 and the earlier time is A2. The result of the example is 01:40 or 1 hour and 40 minutes.

In the formula, an entire 24-hour day has a value of 1 and one hour has a value of 1/24. The logical value in parentheses (round brackets) is 0 or 1, corresponding to 0 or 24 hours. The result returned by the formula is automatically issued in time format due to the sequence of the operands.

Calculating With Dates and Times