F - Masked Text Box
In this step you can choose what type of input cells you want to use on the web page. For each individual input you converted in the previous step, you can edit the type of input. This allows you to specify exactly how you want your webpage to function through manipulation of every facet of the web application.
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:
You can 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 enter anything here because SpreadsheetWEB converts these automatically. The supported Excel Form Controls include the Combo Box, Check Box, Option Button and List Box.
You can use the SpreadsheetWEB Wizard to create form controls. These form controls are called form controls throughout the rest of the help document.
| A - Text box (default) | |
| B - Combo Box | |
| C - Check Box | |
| D - Option Button | |
| E - List Box | |
F - Masked Text Box |
|
| G - Grid | |
| H - Calendar |
|
| I - Attachment |
|
Default Value |
The value found in the box when the web page is first opened or reset to default values. |
Type |
You can define what type of input the cell will be after conversion. The default type is "Text Box". |
Cell Link |
This contains the address of the cells in the 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, the available options displayed in these form controls must be defined through a range of cells. This is where you specify the address of this cell range. |
|
This button deletes an input cell that has been defined in the previous step. |
 |
When you click on the advanced button the following dialog window appears:
Advanced: 1. 'Hide or disable an input control' is based on the value of a cell in the Excel spreadsheet. The accepted value can either be FALSE or TRUE. For example, in the linked cell you can enter an 'if-statement' such as
If the value of cell C1 is greater than 1, the cell link will return "TRUE" and the form control will be concealed or disabled. If it is below 1, then the cell link will return "FALSE" and the form control will be available to the user. 2. Validation allows inputs to be validated, ensuring the correct input type is entered. Validation checkboxes are only enabled for textbox inputs. For example, if the cell can only have numbers in it, then the validation will check for other characters. If there are characters inputted that are not numbers, then it will retrieve an error message for the user. 3. Formatting saves the original format of the cell after the conversion. For example, if a particular cell in the original spreadsheet is formatted into a percent value (e.g. 12.35%), it will look exactly the same in the web application once the formatting option is activated. If a cell is originally formatted with special characters such as a percentage sign, activating the formatting option is strongly recommended in this stage. Otherwise, the value in the text field will look unformatted in the web application and the format will not function. On the condition that the formatting button is checked, the value will appear at large and the format will function properly. Note: next time a new value is entered into the web application, typing it without the special character (% in this case) will be sufficient. 4. Required shows if an input field is required. It ensures that data is entered into required fields of input. |
|
This button clears the default values in all input cells. |
|
Add input cells without going back to the previous step in the Wizard. |
