Saving a Document

From Apache OpenOffice Wiki
Jump to: navigation, search

Editing.png This page is in a DRAFT stage.

Saving a New Spreadsheet

To save a new spreadsheet you can perform any of the following:

  • Choose File → Save
  • Choose File → Save as
  • Click the Save Save Icon.jpg icon on the standard toolbar
  • Press  Control  +  S 

These actions will open the save as dialog box, where you can then enter the filename, confirm the filetype and destination location, and then save by clicking the save button. Save Button.jpg

To save a current spreadsheet with the same filename, choose File → Save.

Saving in different formats

Calc gives you the option to save your spreadsheet in many different formats, these include Microsoft Excel formats along with many others. To save your spreadsheet in a different format:

  1. Select File → Save As
  1. Click the drop down box next to Save as type: to select your required format
  2. Click save button.

Saving in different formats.jpg

Password lock a Spreadsheet

To password lock a file do the following:

  1. Choose File → Save As
  1. Enter the file name, format and save location
  1. Tick the Save with password box Save with password.jpg and click Save
  1. A window will pop up asking you to enter a password twice. Enter the same password twice to set the password when opening the file:

Password box.jpg

When someone attempts to open the file from now on it will request the password be entered:

Enter password.jpg

Saving Automatically

Calc will save the spreadsheet automatically at set time intervals (with the default being each 15 Minutes). Automatically saving will overwrite the last saved state of the same as a manual save would. To modify the settings for autosave:

  1. Navigate to Tools → Options → Load/Save → General
  2. Specify the time interval under Save → Save AutoRecovery information every by clicking the up or down arrow. The time will change in 1 minute increments.
  3. Click  OK  when complete.


Personal tools