Repeat Signage V4 help

Microsoft Excel and OpenOffice Calc spreadsheets in Repeat Signage

Help home


Repeat Signage Spreadsheet control

In June 2015, we added the new Spreadsheet control to Repeat Signage, which means that Microsoft Excel .xlsx and .xls (Microsoft Excel 97/2000/XP) can be displayed.   There is a built in spreadsheet system as well so that you can create and use spreadsheets from within a Repeat Signage presentation or Repeat Picture.

There is also a free spreadsheet editor on the main screen's 'Free tools' menu.   This can be used on any PC, free of charge, with the Repeat Signage trial version installed, which never expires.

Previous to the Spreadsheet control, you had export from Microsoft Excel and OpenOffice spreadsheets to PDF format and then use either the Flash banner control, PDF/Document control or the Picture control to display them.  This is still an option and the only way of displaying native OpenOffice spreadsheets.


Notes on exporting to PDF files

Make sure you set the page size and margins in your spreadsheet and use the print preview to see how the pages will look first.  You may even need to change the page orientation from the default portrait format to landscape first.   (There are instructions on our Microsoft Word and OpenOffice.org Writer documents in Repeat Signage help page on setting up page sizes and orientations in both Microsoft Office and OpenOffice).

You can then display any page of your exported PDF file using either the Flash banner control, PDF/Document control or the Picture control


Microsoft Excel exporting to PDF

Instructions on how to export to PDF in Microsoft Excel 2010:

1.  Open your Excel spreadsheet in Microsoft Excel.
2.  On the menu, click on 'File' then 'Save & Send'.
3.  Click on the 'Create PDF/XPS document' button and follow the instructions.

You will need to choose a file name and location.


Apache OpenOffice.org 4 Calc - Exporting either a Microsoft Excel or OpenOffice Calc spreadsheet to PDF

OpenOffice.org 4 is a free office suite which you can download free of charge from www.openoffice.org.  Export instructions:

1.  Open your Excel or Calc spreadsheet in OpenOffice Calc.
2.  On the menu, click on 'File' then 'Export as PDF'

You will need to choose a file name and location.


Automatic update of content on your digital signage screens (Standard and above editions)

Let's say you have a graph of sales figures in your Excel spreadsheet and export this page as a PDF file.  You can then display this in a Repeat Signage presentation using the Picture control.  When you insert the PDF with the Picture control the PDF page will appear on screen. You can double click the Picture control to show its properties, then select the 'Refresh' tab and you can set the picture control to check for a new version of the PDF file every few minutes.

When you update your spreadsheet, you can just export again to the same PDF file (using the same name and location) and the playing Repeat Signage presentation will automatically display the new version of the PDF file dynamically (you don't need to close the presentation and play it again). Note - This is best done over a network where both the spreadsheet editing computer and the computer attached to your digital signage screen both have access to a shared network drive.

What you can also do, with the Standard and above editions, is to upload your new PDF file to a free www.repeatserver.com account.  The presentation playing on your digital signage screen can collect and display the PDF file from RepeatServer.com and monitor for when a new version is uploaded.  When up update your spreadsheet, export to PDF and upload your PDF file again, then the presentation will automatically display the new PDF.  Now since RepeatServer.com is available to any computer with an Internet connection you can use this to remotely update a digital signage screen from anywhere in the world.