Frequently Asked Questions Tree Grids and Tables

Email Support: support@inovista.com

1) Q. Why are charts not visible when I preview a grid?
A: The most common cause of this issue is that a chart or shape has no data values. If the values are not showing in a grid column, check that the column has its data values correctly set.
2) Q. How do I relocate charts or text in a column either vertically or horizontally? How do I make more space between the columns?
A: Use the padding options. You can set top, bottom, left and right padding options individually. In a grid you have the option to set the padding generically so that it happens in the same way for each cell in the grid. You will find the 'Chart Padding' option in the General/Generic Properties tab. Each component in the grid also has the options of setting up padding for that component only (in the case of a grid, this will mean for the whole column). Locate the individual chart padding options in the Columns/Appearance/Layout tab.
3) Q. How do set a gradient background for the grid?
A: In the General/Appearance tab, set the 'Grid Alpha' property to 0, then use the gradient editor.
4) Q. Why do I only see one row in Xcelsius even though I have selected many more in the data source selector?
A: This is standard behavior for the grid and tree grid. When you preview or export the swf, all the data will be visible.
5) Q. How do I create dynamic tool tips with non-standard variables i.e. when I want to use a spreadsheet variable rather than variables like $value and $target?
A: In the General/Generic Binding tab, there is a 'Bind Tooltips' property. Use this binding option in conjunction with the tool tip tab for each column when values in the spreadsheet are to update the tool tip. Remember that this is not necessary when the variables are the standard options like '$value'. Select a range of cells with the tool tip text, the first cell represents the first column, the second represents the second column etc. Leave the cell as empty to ignore it and use the value entered in the tool tip tab for the column.NOTE: You only need one cell per column. Download an xlf with an example.

6) Q. How do I set a minimum and maximum range for charts in a column?
A: Select the chart in the table in the General/Chart Columns tab. Then select the Chart tab. Where applicable, you will find the 'Chart Minimum' and 'Chart Maximum' properties. Bind or enter the values you require. Don't forget to select the checkbox at the end of each of these properties to make sure they are read.
7) Q. How do I set a dynamic minimum and maximum range for charts in a column i.e. a different minimum and maximum for each row?
A: In the General/Generic Binding tab, there is a 'Bind Tooltips' property. Use a spreadsheet table range where the values represent the minimum or maximum value of the respective chart in the data grid. Note that you will still have to set the Minimum and Maximum Range Value checkbox in the 'Columns' tab for each chart you wish to setup. Also note that you need a cell to represent each row and column even columns where you do not want to set a range. For those columns, just leave empty data. Download an xlf with an example.
8) Q. Can I include more than one data line in the charts?
A: You can do this by using the target values which are typically used for an alert as the data values. Select the chart in the table in the General/Chart Columns tab. Then select the Chart tab. Then in the Alerts/Define Alert tab, select the 'Draw Targets as Line' option. Download an xlf with an example.
9) Q. How does the cell rollover and mouse click functionality work?
A: The mouse rollover and click options are found in the Behavior/Click Visibility tab. Select the 'Click Listen' option to listen for mouse clicks. Select the 'Rollover Listen' option to listen for mouse over events. Then select a spreadsheet cell that will be populated with the output data. This cell will receive values in the form 'row:col', for example if you click the cell in row four, column two; '4:2' will be placed in the cell. If, for example, you have chosen the cell 'E4' as the output cell, use the Excel formula '=LEFT(E4,FIND(":",E4)-1)' to extract the row value. Use the formula '=RIGHT(E4,LEN(E4)-FIND(":",E4))' to extract the column. Download an xlf with an example.
10) Q. How do I hide rows that contain no data values?
A: In the General/Grid Options tab select the 'Hide Blank Rows' option.
11) Q. How do I setup an axis in a column header?
A: In the General/Chart Columns tab, select the 'Axis Header' checkbox for the rows where you would like an axis in the column header. Note that this option is only available for charts like the Bar Chart that have a horizontal axis. Then in the Columns/General/Axis tab, select the 'Show Axis' option. Define the axis properties in the way you want, then when you have finished, deselect the 'Show Axis' option. Download an xlf with an example.
12) Q. How do I setup value labels in a column header?
A: Horizontally plotted charts can use value labels to indicate the start and end values of the axis, for example 'Jan' ... 'Dec'. In the General/Chart Columns tab, select the 'Axis Header' checkbox for the rows where you would like value labels in the column header. Then in the Columns/General/Axis tab, select the 'Show Axis' option. Define the value label properties in the way you want, then when you have finished, deselect the 'Show Axis' option. Download an xlf with an example.
13) Q. How do I setup a legend footer?
A: In the General/Chart Columns tab, select the 'Legend Footer' checkbox for the rows you would like to have legends at the bottom of the grid. Then in the Columns/General/Legends tab (this varies from component to component), select the 'Show Legends' option. Define the legend properties in the way you want, then when you have finished, deselect the 'Show Legends' option. Download an xlf with an example.
14) Q. How do I make the component invisible/visible at runtime?
A: In the Behavior/Click Visibility tab, select the 'Test Visibility' checkbox to tell the grid to check if it should be set to visible or not. Use the 'Status' bind property to select a spreadsheet cell to define the value that will be tested. Bind or enter the 'Key' value. When the 'Key' value matches the 'Status' value, the component will be visible, otherwise it will be hidden.
15) Q. How do I add the component to an Inovista container like the Floating Background?
A: The Inovista containers check a spreadsheet range to know what other components to include. To add the grid to the range, use the 'Output ID' property in the Behavior/External Bind tab.
Email Support: support@inovista.com