LibreOffice

view

LibreOffice Documentation April 2021

LibreOffice 7.0 / 7.x [1] documentation [2] is progressing nicely. Guides for :

Updated 12/04/2021 – Writer 7.1 guide is now available from the LibreOffice documentation page.

• Getting Started 7.0
• Impress 7.0
• Calc 7.0
• Math 7.0
• Writer 7.1

REFERENCES

1 LibreOffice 2 LibreOffice Documentation 3 Free Software Foundation 4 Free Software Foundation Europe

TAGS

#YearOfTheFediverse,#LibreOffice,#Office,#Writer,#Calc,#Base,#Draw,#Math,#GettingStarted

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

view

Toolbars

LibreOffice now has several options, when it comes to viewing the menus and options to undertake various tasks while working.

You can change the way the menu looks from the User Interface option.

STANDARD TOOL BAR

SINGLE TOOL BAR

SIDEBAR

TABBED

TABBED COMPACT

GROUPED BAR COMPACT

CONTEXTUAL SINGLE

#LibreOffice7,#Menu,#Options

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

view

Calc-Curriculum

I am presenting here a series of videos to undertake tasks in the LibreOffice spreadsheet module : Calc.

• LibreOffice 7 Calc Manual is now available to download.

Note this is WORK IN PROGRESS. Videos are hosted on Peertube. If you want something better / quicker PAY ME.

Starting calc – Choose Spreadsheet from the main screen

You will then be presented with :-

Save files

Save As Open Document format (recommended)

Video

• SaveAs Open document format

Saving as Office 365

Video

• SaveAs Office 365

Open Files

Choose File —> Open from the menu

Basic Operations

• Add Two Values
• Simple Expenses sheet

Charts * Pie Chart * Simple Chart 1 * Simple Chart 2

Print and page operations

• Set Print Ranges
• Print range and cell column / row headers
• Column Row Headers
• Display Grid
• Sheet Header

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

view

Gallery part 3

Inserting gallery images

1. Image Gallery

Insert Menu —> Media —> Gallery

Find the image you would like, drag to your page, you can then resize to suit, with the grab handles.

This allows you to set a glow effect around your image. This can make it stand out for example.

Here you can set various line properties.

Allows you to fine tune how big the image is, rotation and other properties

Sets other properties such as radius of the edge, to make it smoother for example.

For a deeper explanation of these tools please see the documentation. Or perhaps consider getting involved with the project so the team(s) can improve on this. There is a lot more work to do, and only a small team doing this.

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

view

Gallery part 2

Manipulating your gallery image

1. Image Gallery

Insert Menu —> Media —> Gallery

The vertical option bar on the right displays:-

The options here are (top to bottom)

• Sidebar Settings
• Properties
• Page
• Styles
• Gallery
• Navigator

This section will concentrate on Properties

The first option Area will display

Video

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

view

Gallery part 1

Inserting gallery images

1. Image Gallery

Insert Menu —> Media —> Gallery

Find the image you would like, drag to your page, you can then resize to suit, with the grab handles.

Video

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

view

Templates

How to create a writer template.

A template is useful, if you want to pull in a document with some pre-defined content and formatting, for example:

• Double lined spacing
• A title, header / footer
• A letter template

To create a template

1. Create a normal writer document, create the content, you then need to save this as a template.

This will create filename.ott file (note the ott extension.

1. If you want to add this to the list of templates then:-

Goto Manage templates from the templates menu on the main screen

Which brings up

1. Click on import and select the template you saved earlier.

You should now be able to select your new template from the LibreOffice Start up screen.

Once opened, saving any additional information to the template will force SaveAs so you then save as a normal odt (or other) document.

Under manage templates you can sort these and only list specific templates e.g My Templates

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

view

Page Orientation

By default, a document is in Landscape, so the long edge is at the side. If you are producing for example a document with a lot of data going left to right you may need to switch orientation.

You can do this from the Format —> Page Styles option.

This allows you to switch your DOCUMENT to Landscape, so the long edge is at the top, or back to portrait.

You can also use the Insert menu to add a new page which is a different orientation, this uses page breaks.

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License