Range Commands

A Range command is hot-linked to a single contiguous range on a spreadsheet. When updated, it inserts a picture of the range into the command. You change the settings for a Range command from the Edit Command Panel in the Report Navigator.

Range Command - Range Controls

The Range text displays the location of the linked range. The number in brackets is the file ID. The rest of the text string is the range's address. The address can use Excel's [sheet name]![column & row]:[column & row] notation, or it can be a range name. To view the linked range, click on the Go to Range Button. To change the linked range:

Select the Range

Select the range that you want to link to.

To link to the report's Analysis file, use Analysis Mode to select the range.

To link to a standard Excel workbook file, use Workbooks Mode to select the range.

Copy the Range

Click on the Copy Link Button in the Desktop Toolbar. You can also select Edit | Copy Link.

Paste the Range

Go to to Report Mode and click on the Paste Range Button in the top right corner of the Edit Command Panel.

Update the Command

Click on the Apply button in the lower right corner of the Edit Command Panel. The new range will be applied to the command.

The Color control sets the color format of the range image.

Color Format		Effect
Color		Range colors are the same as in the spreadsheet.
Black and White		Sets the interior color of the range to white and the font color of the range to black.
Grayscale		Sets the range colors to grayscale. Equivalent to Word’s UI command: Format \| Picture \| Picture Tab \| Image Control \| Color = Grayscale.

Range Command - Width Controls

You can let the software set the width of the range's image, or you can set the width manually.

Default (autosize)

The default width of the range is the same as in the spreadsheet, unless the spreadsheet range is wider than the page width in the report. In this case, the range width becomes the page width.

Custom

The Custom field sets the width of the range in inches. Widths greater than the page width (up to 20") are allowed; in these cases, the displayed range extends off the page and appears truncated. Regardless of how the width is set, the height of the range is calculated to preserve the same aspect ratio as in the spreadsheet.