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.


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


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


Save options are present in File menu.

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:

SEE ALSO:  How to Add Numeric Data Validation in Calc Spreadsheet


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


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 option opens a Calc workbook file. You can choose the path with open file dialog and choose a file to be opened.



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.

Join our Telegram channel and stay informed on the move.



IT professional by profession and founder of Loving Linux and other technologies since 2002. I believe in open source and its philosophy. Follow me on Twitter or email me.

Leave a Reply

Your email address will not be published.

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