• No results found

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