Selecting cells for User Input

In this step, you can define the input cells. These cells allow the end-user to type in data that can later be submitted or used to calculate a user-specific value.

Note: Only select cells that truly need to be edited by the end-users. Too many unnecessary input cells can cause high rendering times and, at its worst, server overloads. For example, do not select all of the cells in the Display Range as input cells if it's unnecessary. Only select those cells where you would like your client to input information.

What are the input cells? Please have a look at the 'Excel file' in the screenshot below. YELLOW CELLS will represent the data input cells on the web application. Check the screenshot of the web application. Here you can see that only the fields that had been defined as input cells before the conversion allow the end-users to input data. All of the other cells are not accessible. ORANGE CELLS represent calculated results in both images.

Excel file before Conversion

Web Application

Methods of Selecting Input Cells

A - Manually Selecting a Range

B - Auto detect by cell colors

C - Static Page / Form Controls

Form Controls as User Inputs

You can also use form controls as user inputs. There are two ways to create form controls:

1. Use the SpreadsheetWEB Wizard to create form controls. Click here for more information.
2. Create form controls with Excel using Excel's built-in form controls - see information below.

SpreadsheetWEB can automatically convert Excel's built-in form controls. Please see the table below for a list of Excel form controls that are currently supported in SpreadsheetWEB.

Combo Box
Check Box
Option Button
List Box