Enhancing Productivity

Set basic options/preferences in the application: user name, default folder to open, save spreadsheets.

To set the basic options in the Calc application, click on ‘Tools’ from the main menu bar. From the resulting drop-down, click on ‘Options’. This will open the ‘Options’ dialog box.


img0
img1
img2
img3
img4
img5
img6
img7
img8
img9
img10
img11
img12
img13
img14
img15
img16
img17
img18
img19
img20
img21
img22
img23
img24
img25


In the ‘Options’ dialog box, under ‘LibreOffice’, in ‘User Data’ we have options to enter user info. The user name can be set here.

basic optionsIn the same dialog box, under ‘LibreOffice’, we have ‘Paths’. Here, we can set the different default paths for the folders to open and save files.

Paths

Use available Help functions.

All the components of LibreOffice offer extensive help system to the users. Calc is no different. To get the complete help system, click on ‘Help’ button from the main menu bar. Click on ‘LibreOffice Help’ from the drop down which gets displayed and this will open the full help system.

Additionally, you can click on ‘Tools’ from the main menu bar and then click on ‘Options’ from the resulting drop down menu. Select the ‘LibreOffice > General’ tab from the dialog which gets opened and you can then choose to check or uncheck the available help options like ‘Tips’ and ‘Extended Tips’.

Help Options

If ‘Tips’ are enabled you can place the mouse pointer over any icon to see a small tooltip box, which provides a small explanation for the functioning of that icon.

If a more detailed explanation is desired, then click on ‘What’s This?’ from the ‘Help’ dropdown on the main menu bar. Holding the pointer above any icon after this will provide a detailed explanation.

What's This

Use magnification/zoom tools.

The view magnification can simply be changed by clicking on the + or – sign in the zoom slider on the status bar.

Zoom

In order to make more custom changes, click on the percentage figure on the status bar. This opens the ‘Zoom & View Layout’ dialog. The appropriate changes can be made by selecting the desired values from this dialog.

Zoom Factor

Display, hide built-in toolbars. Restore, minimize the ribbon.

Whether to display or hide the different toolbars in Calc can be controlled by using the ‘View’ button on the main menu bar. Click on ‘View’ and then click on ‘Toolbars’ from the drop down. You get a list of different toolbars which can be checked or unchecked in order to display or hide them respectively.

Toolbars