HIGHLIGHT
= optional in Column A
Parameter | Mandatory/Optional | Value (example) | Occurrence in column A | Comment | |
|---|---|---|---|---|---|
FORMS | REPORT | ||||
HIGHLIGHT |
|
| TRUE | x number of times | If the default headings in the spreadsheet are hidden, it can be difficult for an end-user to navigate in a report or form and determine which row is the active row. This parameter can be used to specify which column should be highlighted when the row is active. |
HIGHLIGHT is an optional parameter that can be used in both FORMS and REPORTS. If a designer choose to hide the default row and column headings in a spreadsheet, it can be difficult for the end-user to view which row is active in the spreadsheet. Instead of activating the row and column headings, the HIGHLIGHT parameter can be used. The parameter defines which column should be highlighted when the end-user navigates in a document.
Parameter rules:
- Several HIGHLIGHT can be used in the same document to highlight different columns.
- A HIGHLIGHT parameter stated in column A, without any TRUE in a column, will turn off the highlight effect in the rows below.
- HIGHLIGHT can be used in any document or any worksheet.
- Only one TRUE column can exist in one HIGHLIGHT parameter row.
- The HIGHLIGHT should be defined with ROWTYPE = DESIGN (the row will be hidden when document is generated).
Template worksheet
The HIGHLIGHT parameter is defined in column A. The parameter value TRUE should be stated in the column that should be highlighted when navigating in the generated document. The highlight will start from the row below the parameter and be applicable to all below rows until another HIGHLIGHT parameter is found.
In the below example, the HIGHLIGHT parameter is set to TRUE in column G in the first section. In the second section, the parameter is set to TRUE in column F:
Below is an example of the generated report:
