Repeat Signage V5 help

Built-in spreadsheet editing screen

Help home

Repeat Signage digital signage software

Spreadsheet editor

You can use this screen to build up a spreadsheet for displaying with the Spreadsheet control.  It uses a similar layout and design to Microsoft Excel and supports many of it's features.  Users will need to be familiar with using spreadsheets packages in order to use this screen.

When finished editing, click on the 'File' tab and use the 'Save and close' button to return to the previous screen.  Note - Your actual Repeat Signage presentation file is not actually updated until you use 'File' then 'Save' on the designer screen.

Additional notes

Duplicating pictures

If you need to make a copy of a picture within a spreadsheet, then click on the picture and use the right mouse click menu's 'Duplicate' option.  This will duplicate the picture and keep all the original source picture settings.  You could use copy and paste but this just copies the picture and inserts as an embedded picture and then you only have resizing option.  If you use copy and paste, rather than duplicate, on a Repeat Icon, then again makes the copy an embedded image and you will be able to edit and switch to a different icon, or change colours. 

Duplication pictures

Previewing at the spreadsheet control's current size in the designer

See Spreadsheet preview at same size as control.

Pictures and Repeat Icons

You may want to decorate your spreadsheets with Repeat Icons and pictures, so the spreadsheet tool bar has these insert buttons:

Insert picture, insert Repeat Icon box

which support our Repeat Icons:

Repeat Signage icons

which can be used to decorate spreadsheets:

Repeat Icons to decorate spreadsheets

and our picture system:

Picture location screen

so you can collect pictures from a variety of sources.  It allows you to crop and resize images to insert into your spreadsheets. 

Rotating pictures

Pictures can also be rotated by clicking on them and using the resizer handles an the green circle rotate handle:
Rotating pictures
Example of rotated picture
Pictures added you to spreadsheets through Repeat Signage save details on your icon or picture and double click pictures allows you to edit them with ease.


If you have any questions or would like help creating your spreadsheet, then please email us at and we will be happy to help.  Use the 'Save as' button to save your existing spreadsheet to a .xlsx file, which you can attach to your email, which will help us to answer your questions. 

Importing an existing spreadsheet

You can import an existing Excel .xlsx file (or an Excel 97/2000/XP .xls) by clicking on the 'File' tab and using the 'Import spreadsheet' button.  This will overwrite your existing built in spreadsheet.  This overwrite doesn't happen until you save.  If you change you mind you we suggest you use the 'Close' button and 'Close without saving' when prompted. 

When you import an existing spreadsheet, the source spreadsheet is not changed.

Exporting your built-in spreadsheet to an Excel spreadsheet .xlsx file

Click on the 'File' tab and then the 'Save as' button to save to an external file.

'Show control area' and 'Preview at control size' buttons

When you create a Spreadsheet control in the designer, if will start by displaying it as a 640x480 pixel sized control.  You can then resize this in the designer by using the resizer handles, or updating the width and height on the menu.  Clicking on the 'File' tab's 'Show control area' option:

Show control area box

will make the area outside of your control's size pink, so that you can see how much of your spreadsheet will actually be displayed.  This doesn't currently take into account if you have changed the 'Zoom percent' option from the default of 100% on the spreadsheet options tab on the previous screen. 

This also doesn't work if you control is larger than the current spreadsheet size on screen.  We have added a Spreadsheet preview at same size as control menu item:

Preview at control size box

which allows you to quickly preview what your final spreadsheet will look like within your presentation.