Opening, Saving and Closing Spreadsheets

Creating a New Calc Spreadsheet

If Calc is not already open, click the Start menu > All Programs > LibreOffice.org > click LibreOffice.org Calc. A new spreadsheet, titled Untitled 1 – LibreOffice.org Calc, will appear on your screen.

 

If Calc is already open, go to File > New > Spreadsheet. A new Untitled spreadsheet will appear on your screen.

 

Before beginning any work, save the spreadsheet.

 

Saving a Spreadsheet

Saving an LibreOffice Calc spreadsheet is the standard method of saving a file on your computer. View the tutorial on Saving Files here.

 

Calc spreadsheets save by default as .ods file types and can only be opened by LibreOffice Calc. This is okay for schoolwork, because your teachers have LibreOffice on their computers and can open your files.

 

If you need to save your Calc .ods document as a Microsoft Excel .xls file, change the Save As Type drop-down menu (step 6 in the File Saving tutorial) to Microsoft Word 97/2000/XP (.xls). You will see the following message: This document may contain formatting or content that cannot be saved in the Microsoft Word 97/2000/XP file format. Do you want to save the document in this format anyway

  • Click Yes/Keep Current Format to save in the Microsoft Word 97/2000/XP file format
  • Click No/Save in ODF Format to use the latest OpenDocument file format and be sure all formatting and content is saved correctly

 

Opening a Previously Saved Spreadsheet

  1. Open Calc by clicking the Start menu > All Programs > LibreOffice.org > click LibreOffice.org Calc.
  2. Click File > Open.
  3. Find the file on your computer. School files are usually in My Documents. If you are not sure where you saved your file, view the tutorial on Finding Files.

 

 


Other Related Support Topics ...