Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Updating a spreadsheet from a changed template

The next time you open a spreadsheet that was created from the changed template, the following message appears.

Apply current styles message.

Click Yes to apply the template’s changed styles to the spreadsheet. Click No if you do not want to apply the template’s changed styles to the spreadsheet (but see Caution notice below).

Image:documentation_caution.png If you choose No in the message box shown above, that message will not appear again the next time you open the document after changing the template it is based on. You will not get another chance to update the styles from the template, although you can use the macro given in the Note below to re-enable this feature.
Image:documentation_note.png To re-enable updating from a template:
  1. Use Tools > Macros > Organize Macros > Basic. Select the document from the list, click the +, and select Standard. If Standard has a + beside it, click that and select a module.
  2. Name the macro. For example, you could call it FixDocument. If the Edit button is active, click it. If the Edit button is not active, click New, type a module name in the pop-up dialog, and click OK.
  3. In the Basic window, enter the following:
  4.  Sub FixDocV3 
     ' set UpdateFromTemplate 
      oDocSettings = ThisComponent.createInstance( "" ) 
      oDocSettings.UpdateFromTemplate = True 
     End Sub 'FixDocV3
  5. Click the Run BASIC icon, then close the Basic window.
  6. Save the document.

Next time when you open this document you will have the update from template feature back.

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire