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).
|| 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.
|| To re-enable updating from a template:
- Use Tools > Macros > Organize Macros > OpenOffice.org Basic. Select the document from the list, click the +, and select Standard. If Standard has a + beside it, click that and select a module.
- 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.
- In the Basic window, enter the following:
' set UpdateFromTemplate
oDocSettings = ThisComponent.createInstance( "com.sun.star.document.Settings" )
oDocSettings.UpdateFromTemplate = True
End Sub 'FixDocV3
- Click the Run BASIC icon, then close the Basic window.
- Save the document.
Next time when you open this document you will have the update from template feature back.