Spreadsheet Cells to WebPage Controls

When using the Create a WebPage from Selected Cells option, the following table lists the supported Spreadsheet functions, as well as the association between the Spreadsheet cell and the automatically created and configured WebPage User Inputs and Vision Controls and Displays elements.

Note:

The default values used in the WebPage element's configured properties will be based on the values in the Spreadsheet at the time the WebPage was created.
When using this option to generate a WebPage, the Bound property is the only aspect of the Spreadsheet function that will be updated based on the interaction in the WebPage. The state of the cell (established using the Cell State Dialog) will not be automatically configured. For example, if a cell is conditionally enabled, and its state is changed while offline by pressing the button, the related WebPage element will not be enabled and/or disabled.

Once the WebPage has been created, except for the bound properties, any changes made to the WebPage and/or Spreadsheet will not be reflected in the other. Therefore, there are two options to keep the two in sync:
1. Create a new WebPage based on the updated Spreadsheet values.
2. Manually update the WebPage and Spreadsheet to keep them synchronized.

Spreadsheet Function and Cell Type	WebPage Controls Element	Default Size of Controls	Configured Properties	Bound Property
Button	CheckBox	120 pixels by 40 pixels	Text	Checked
CheckBox	CheckBox	120 pixels by 40 pixels	Text	Checked
EditInt	NumericEntry	120 pixels by 40 pixels	Min Value Max Value	Value
EditFloat	NumericEntry	120 pixels by 40 pixels	Min Value Max Value	Value
EditString	TextBox	120 pixels by 40 pixels	MaxLength	Text
ListBox	SelectionBox	120 pixels by 40 pixels	Items	SelectedIndex
EditAnnulus	Button	120 pixels by 40 pixels	Click Command address Background Color Border Color Note: When these functions are selected, the AcquireImage function they are referencing will automatically be selected and configured as a Vision Controls and Displays user input, even if the cell containing the AcquireImage was not selected at the time the WebPage was created. The Border Color properties will be set to the color used by the associated Display user input.
EditCircle
EditCompositeRegion
EditLine
EditMaskedRegion
EditPoint
EditPolygon
EditPolylinePath
EditRegion
Vision Data Access Functions	Label	120 pixels by 40 pixels		Text
ColorLabel	Label	120 pixels by 40 pixels	Background Color Font Color	Text
Cells containing a constant, such as text or a number	Label	120 pixels by 40 pixels	Text
Note: Cells that contain an Image data structure or other data structures (e.g. a Blobs, Edge, or Patterns data structure) will not have a corresponding WebPage element. Nor will cells that are in a #ERR state.