Setting the Spec Range
Before you can generate and print a financial report from a report specification, you must define the Spec range.
The Spec range is a named range of cells in the spreadsheet.
To define the Spec range in Excel, follow these steps:
-
Mark the complete report specification, from the first row and column to the last row and column. (To mark, place the mouse point on the first cell of the range, hold down the left mouse button, and drag the pointer to the last cell of the range.)
-
Choose Insert, Name, Define.
-
Type "Spec" as the range name, then click OK.
You must type exactly these letters (the capitalization doesn't matter).
You don't define a Report range
Note that you don't need to define a Report range within the spreadsheet. Financial Reporter defines the Report range when it generates the report from a specification.