LibreOffice

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

view

User Data

LibreOffice has an feature that allows a user to store some details on their company, for example. This data can then be, retrieved and used in documents.

Tools (menu) —> Options

Brings up the following, I have entered some made up data for this tutorial

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

view

Spelling and Grammar

It is important to check your document for errors.

The spell check tool allows you to do this easily.

Tools —> Spelling or press F7

You can also set other options

It is usually a good idea to click at the top of the document before running a spell check, that way the entire document can be checked in one go. You can:

• Correct a misspelt word
• Correct Grammar
• Add new words to the dictionary.

If you need to change the language LibreOffice is using then you can use the pull down menu to choose a different language.

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

view

Page Zoom

Sometimes you may find the text on the screen is too small to read or perhaps you want to check a image for example.

You can use the zoom tool, found in the bottom right of the application to make the page bigger or smaller.

Move the slider left <–> right to zoom out and zoom in.

Video demonstration

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