SpreadsheetWEB allows you to create multiple worksheet applications.
Start the conversion by first providing a name for the web application in the text field labeled 'Application Name'.
When you start a fresh conversion, the box below 'Worksheet(s)' will be empty. To add a worksheet to the application, click on the 'Add' button below the worksheets box. This will immediately take you to the next step. After you have defined all settings for this worksheet, the wizard will return you to this screen, where you can add additional worksheets or edit existing ones.
You can only upload your application when you have added at least one worksheet to your application. To upload the application, click 'Next'. This will take you to the following Wizard step where you can first preview your application and then upload it.
When you add more than one worksheet to your application, SpreadsheetWEB will automatically add a worksheet tab bar at the top of the web application (i.e. at the top of the browser window after conversion and upload). This tab bar works very much like the worksheet tab bar you know from Excel. It allows you to navigate between the different worksheets.
Use the 'up' and 'down' buttons to change the order of the worksheets in the worksheet tab bar. Changing the order in this worksheet list will render the tabs in the finalized web application in a different order. The tab bar in the web application will order the worksheets from first to last (in the wizard) in the same order from left to right (in the tab bar). For example, if this is your worksheet list:
Then your finalized tab bar in the web application will look like this:
By selecting a worksheet and using the "Up" and "Down" buttons, you are able to re-order the worksheet tab bar in the finalized web application according to the order seen in the worksheets section of the Wizard.
To set a worksheet as the main worksheet displayed by the application when you first open it in the web browser, select it from the list of available worksheets and click the 'Set as main worksheet' button.
If you do not want the worksheet tab bar to be displayed, tick the check box next to 'Hide worksheet tab bar'. This is generally used to hide worksheets that runs "behind-the-scenes". For example, if all of your calculation matrices are located in Worksheet 2 (as displayed below), then you will want to hide that worksheet. After ticking the "hide worksheet tab bar" option, the finalized web application will not display the tab bar so no one will be able to access any worksheets other than the first one in the list (as is displayed in the third image). This is only one way that SpreadsheetWEB offers you the ability to hide worksheets. In this method, you hide all additional worksheets. If you simply want to hide a specific worksheet, view the Worksheet Controls section of the Help Document.
Image 1 - Worksheet two contains all calculation matrices, so we activate the "Hide worksheet tab bar".
Image 2 - If the "Hide worksheet tab bar" is not checked, then there will be a tab bar present in the final web application.
Image 3 - If the "Hide worksheet tab bar" is checked, then there will be no tab bar present in the final web application. Therefore, people accessing the web application will not even know that there is a second worksheet.