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
SEE ALSO:  Split a Worksheet View - LibreOffice Calc

 

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


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Related

Support Us


Be an expert on LibreOffice.

Small and quality tutorials. Delivered. Thrice a week.


Leave a Reply

Your email address will not be published. Required fields are marked *

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

Back to top