Skip to end of metadata
Go to start of metadata

Available Input Types

The text box (A) is the default input type. The other input types ( B - E ) are called form controls. There are two ways to create form controls:
1. Create form controls with Excel using Excel's built-in form controls - If you have already created one or more of the following form controls in Excel, then you do not have to do anything here, as SpreadsheetWEB converts these automatically. These form controls include the Combo Box, Check Box, Option Button and List Box. Note: Make sure that you have at least one SpreadsheetWEB created cell input. Without at least one input created by SpreadsheetWEB, the Wizard will not automatically detect all Excel-created form controls and the page will become static after conversion.


Overview of form controls

2. Use the SpreadsheetWEB Wizard to create form controls. These form controls are called PSW form controls from now on.


Input Cell Settings in SpreadsheetWEB Wizard. 

Overview of the buttons and functionalities


Default Value The value of the box when the web page is first opened or reset to default values.
Type Here you define what type the input cell will be on the web page. Default type is "Text Box".
Cell Link Contains the address of the cells in Excel spreadsheet, for which you have a specific input type.
Input Range When creating a combo box, check box, option button or a list box, options that the users can choose from must be defined in a range of cells. Here you have to specify the address of this range of cells.
Deletes an input cell that has been defined in the previous step.
Clears the default values in all input cells.
Add input cells without going back to the previous step in the Wizard.
Advanced When you click on the advanced button, the following dialog window appears:

Advanced:
1. Hides or disables an input control dependent on the value of a cell in the Excel spreadsheet. The accepted value can either be FALSE or TRUE.
Example: In the linked cell enter an if-statement such as:
=if(c1 > 1, TRUE, FALSE)
If the value of cell C1 is greater than 1, the cell link returns true and the form control will be concealed or disabled. If the value is below 1 the form control is available.
2. "Validation" allows inputs to be validated, ensuring the correct input type is entered.  Validation checkboxes are only enabled for textbox inputs.
3. "Formatting" allows values in a texbox appear formatted consistent with cell format feature in Excel  Formatting is only enabled for textbox inputs and available for limited cell format types.
4. "Required" shows if an input field is required.  It ensures that data is entered into required fields of input.
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.