When spreadsheets are converted to web pages, all cells are locked for input except those required to use the form or calculator. For forms, you may want to unlock additional fields for input, e.g. text fields that aren’t used in any calculations.
SpreadsheetConverter can automatically guess what cells in your worksheet it needs to open for input. It does this by looking at your formulas and seeing what cells they take their input values from. If you insert a Text widget into a cell, it is also automatically opened for input on the web page.
To open additional input cells that may not be obvious to SpreadsheetConverter (e.g. for extra lines in address fields), or to prevent certain fields from modification by the user, you need to use one of the two methods that SpreadsheetConverter provides for manual designation of input cells: background color or unlocked cells.
In Excel, look for the SpreadsheetConverter tab at the right end of the menu ribbon. Click the tab to switch to the SpreadsheetConverter ribbon.
In the SpreadsheetConverter ribbon, select Properties > Show so that the SpreadsheetConverter task pane becomes visible.
In the SpreadsheetConverter task pane, select the Workbook tab so that the Workbook Settings become visible.
The first time you convert a particular spreadsheet, try using automatic detection first. Select “Auto” as the selection method.
With automatic detection, the following kinds of cells are converted to input fields, open for data entry:
If you need to use other cells in the spreadsheet for input, you can use a background cell color to explicitly open cells for input from the user. During conversion, SpreadsheetConverter locks all cells except the cells with the selected background color.
Begin by giving all input cells in the spreadsheet the same background color, e.g. yellow. Ensure that you use a background color that is not used elsewhere in the workbook. You must background color all input cells, also the ones referenced by your formulas, since they will not be opened automatically.
Before conversion, select “Cell color” for Input Cells selection on the Workbook tab. Then click on one of the cells that has the selected background color.
If you don’t want the input cells to actually use this background color on the web page, check the checkbox “Ignore background color for input cells and make them white”.
If your spreadsheet uses Excel’s built-in protection mechanism for locked cells, you can also use it to explicitly unlock input cells. You must unlock all input cells, also the ones referenced by your formulas, since they will not be opened automatically.
Select “Unlocked” for Input Cells selection on the Workbook tab. Remember to unlock the worksheet before conversion.