Create, Save, Open and Close a Workbook in LibreOffice Calc

This beginner tutorial would show you how to Create, Save, Open and Close a Workbook in LibreOffice Calc.

Create

Workbook is nothing but the Calc file itself. Typically, a workbook contains multiple worksheets. Worksheets are the “tabs” named “Sheet1”, “Sheet2” etc.
To create a workbook follow below steps:

Click File -> New -> Spreadsheet OR press key – CTRL+N

new-spreadsheet

A new spreadsheet would open which you can use for your purpose.

Save

Save options are present in File menu.
save-calc-1

Save option saves the file with updated content.
Save As option can save the file in desired path with a new file name.
Save a copy saves a copy of the current open workbook in a desired path.

Save to a Remote Server option saves to a remote disk/storage/cloud storage such as Google Drive. Once you click this option, below dialog would open:

remote-files_041

Click on the Add Service button. In the next dialog, choose your desired remote destination and provide credentials.

save-to-remote-services

Currently below are the services available in LibreOffice Calc 5+.

  • Google Drive
  • Alfresco 4/5
  • IBM FileNet P8
  • Lotus Live Files
  • Lotus Quickr Domino
  • Nuxeo 5.4
  • OpenDataSpace
  • OpenText ELS 10.2.0
  • SharePoint 2010
  • SharePoint 2013
  • WebDav
  • FTP
  • SSH
  • Windows Share

 

Open

Open option opens a Calc workbook file. You can choose the path with open file dialog and choose a file to be opened.

calc-open

Close

Close option closes the currently opened Calc file.

 

Next Chapter   Worksheets

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.