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.
- 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:
- Create a new WebPage based on the updated Spreadsheet values.
- 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 | ||||
EditInt | NumericEntry | 120 pixels by 40 pixels |
Min Value Max Value |
Value |
EditFloat | ||||
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:
|
|
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.
|