Working with Components
2. In the Characters Allowed box, type the allowed and not allowed characters or click the Cell Selector button ( ) to select a cell in the spreadsheet that contains the values
4.2.8 Using other components
4.2.8.1 Other component general properties
Use the following table as a guide for setting the properties on the General view for other components.
The available options vary depending on the type of component.
Description Option
Type the title text or click the Cell Selector ( ) to select the title text from the embedded spreadsheet. The title is centered at the top of the component by default.
Title
Specify the text that appears on the button.
Type the text in the box or click the Cell Selector ( ) to select the label text from the embedded spreadsheet.
Label
These titles appear on each frame of a panel set.
Choose a Layout before configuring panel titles. Click the Cell Selector ( ) to select the title text from the embedded spreadsheet or click the Manual Edit button to type the title for each panel.
Panel Titles
For a panel set, select the arrangement of panels from the list.
Layout
For a panel set, the number of panels in the list corresponds to the selected layout. Select each panel and set the content options.
Panels
Description Option
For a panel set, this option specifies the type of information provided in the se-lected panel. Select one of the following options:
Description Option
The panel is blank.
None
The image files for the panel are saved with the model. Click the Import button and browse to the location of the file.
Embedded JPEG or SWF
The image files for the panel are loaded from an external URL location at runtime. Click the Cell Selector ( ) to select the URL from the embedded spreadsheet or click the Manual Edit ( ) to type the URL manually, and select an Application Domain.
By URL Content Type
For a panel set, this option specifies the text that appears in the drop-down lists for each panel. If a panel contains several images, users can select the image to display using this list.
Select a panel in the Panels list and click the Cell Selector ( ) button to select the label text from the embedded spreadsheet or click the Manual Edit ( ) to type the label text.
If you create more labels than images for a panel, the extra labels do not appear in the drop-down list.
Drop-Down Menu Labels
This option specifies the type of information that is inserted when a selection is made. Select one of the following options:
For "Calendar" components:
• Day: inserts the number of the day of the month. For example, April 7, 2011 is inserted as "7".
• Date: inserts the number of the day, counting up from January 1, 1900. For example, April 7, 2011 is inserted as "40640".
For "Source Data" components:
• Value: inserts the value from a single cell.
• Row: inserts the values in a row of data.
• Column: inserts the values in a column of data.
Insertion Type
Description Option
Specifies the location of the source data for selections. Click the Cell Selector ( ) to select the range from the spreadsheet.
Source Data
Specifies the location in the spreadsheet the component inserts data. Click the Cell Selector ( ) to select the range in the spreadsheet.
Note:
The required size of the destination range varies according to the structure se-lected in Insertion Type. If the component inserts columns or rows of data, select a range that is large enough to contain the largest column or row of data.
Destination
The location in the spreadsheet to insert the month value for the selected date.
Month Destina-tion
The location in the spreadsheet to insert the year value for the selected data.
Year Destination
Specifies the source data that the component uses. Click the Cell Selector ( ) to select the range in the spreadsheet.
For the grid component, a value is displayed for each cell selected and values are arranged in the same order as in the spreadsheet. Changes to the sheet values are reflected in the grid, and users can also change the spread-sheet values by editing the grid during runtime.
For the trend icon component, if the value in this cell is greater than 0, the component displays an up arrow. If the value is less than 0, it displays a down arrow, and if it equals 0, it displays a neutral symbol.
Data
These options specify the upper and lower limit to the values that users can enter in the grid. Type the limit in the box or click the Cell Selector ( ) to select the limit amount from the embedded spreadsheet.
Minimum Limit and Maximum Limit
Description Option
For a trend icon, this option specifies the colors that represent different trends.
Select a color for each option:
Description Option
Icon color when the data value is greater than 0.
Positive Value Color
Icon color when the data value is equal to 0.
Zero Value Color
Icon color when the data value is less than 0.
Negative Value Color Colors
For a history component, this option specifies the location in the embedded spreadsheet where data is inserted. The number of cells in this range determines the number of historical values that are stored. When each cell in the range has a value, the oldest value gets overwritten each time a new historical value is inserted.
For a range with a single column, new values are always inserted in the bottom cell, and the data is bumped up by a row each time a new value is inserted.
A range consisting of a single row behaves similarly. New values are inserted in the rightmost cell.
If the range has multiple rows and multiple columns, newer data is inserted in the bottom right cell. The data is bumped to the right until the bottom row is full, and then the next row is filled right-to-left, and so on.
Data Destination
For a history component, select this option to record the cell history each time the value in the cell changes.
When Value Changes
For a history component, select this option to record the cell history at timed intervals. In the Duration (seconds) box, specify the interval duration.
On Interval