Updating a running slideshow

From The Document Foundation Wiki
< Faq‎ | Impress
Jump to: navigation, search

How do I update a running slide show?

I want to project data from a spreadsheet which is being continuously updated during the slideshow. How do I automatically refresh the presentation?

  • In the spreadsheet, select the range of data in question, then use Data > Define range to give a name to the selection.
  • In the slideshow,
    • Launch Insert ▸ Object ▸ OLE Object[1] ▸ Create a new object ▸ LibreOffice spreadsheet.
    • Menu Sheet ▸ Link to external data. Use the button to search for the spreadsheet; the available ranges will appear. Select one, set the update frequency, and press OK.
    • As a transition for the slide, select automatically after 1 sec for example.
    • In Slideshow ▸ Parameters, choose the type Auto with a delay of 0 seconds.

Notes:

  1. OLE (Object Linking and Embedding). Objects can be linked to a document or embedded into it. When you embed an object, a copy of the object together with the details of the source program are inserted into the document.