Worksheet Controls portion of the SpreadsheetWEB Wizard.
Enter a name in the text field called "Worksheet Name". If you want to use the default settings for the other settings, you can click "Next >>" now to get to the next step. Otherwise, continue below.
To perform calculations and other operations, SpreadsheetWEB has the capability to add buttons to the web application such as Calculate, by selecting one of the desired button from the "Add New Button" selection.
The buttons have the following functions:
"Calculate" - Process the user input and delivers output based on the functions included in the web application.
"Reset" - Reset the input cells to default values as defined during the conversion process in the Wizard.
"Save" - Saves data to a database; stored data can be viewed in the control panel or downloaded as an Excel compatible file.
"Refresh" - Refreshes the Spreadsheet with recalculating the unctions and formulas as well as refreshes the data coming from the database.
"Back/Next" – Enable these options on pages where there is either a worksheet before or after the current worksheet to add a "Back" or "Next" button, allowing the user to shift between pages without using the tab bar.
"Export" – Allows you to export the file as a PDF document or as an Excel format.
"Custom" – Allows for custom button creation.
SpreadsheetWEB also allows editing a button by its label and its position. Simply click the the "Label" button to rename the button and select the "Cell Link" to select a cell in the worksheet to position the button.
If you do not define a custom button position, it will be placed at the bottom center of the web application.
"Enable Ajax based automatic calculations" - Activate this box to enable automatic calculations, pressing calculate button is then no longer required.
"Scripting / HTML" -- Allows for scripting support.