Input Type Definitions

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.

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

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.
	Removes the selected inputs from the list. You can select multiple inputs using the CTRL and SHIFT keys. Selected inputs will be highlighted in blue.
	Clears the default values in all input cells.
	Add input cells without going back to the previous step in the Wizard.
	Removes all input selections from the list.
Advanced	When you click on the advanced button, the following dialog window appears: Hide by Cell & Disable by Cell: Hides or disables an input control depending 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 less than 1, the form control is available. V: “Validation” allows inputs to be validated, ensuring the correct input type is entered. Validation checkboxes are only enabled for textbox inputs. F: “Formatting” allows values in a text box to appear formatted consistent with cell format feature in Excel. Formatting is only enabled for textbox inputs and available for certain cell formats. R: “Required” shows if an input field is required. It ensures that data is entered into required fields of input. FBI:”Formula Based Input” AC:”Auto Complete” This option can be checked only for “Combo Box” type of inputs. Once it is checked, the Combo Box will have the auto complete feature. This feature will automatically fill the rest of the option, when users to start typing in their selection.