QR GET BORDERS
QR GET BORDERS ( area : Integer ; column : Integer ; row : Integer ; border : Integer ; line : Integer {; color : Integer} )
| Parameter | Type | Description | |
|---|---|---|---|
| area | Integer | → | Reference of the area |
| column | Integer | → | Column number |
| row | Integer | → | Row number |
| border | Integer | → | Border value |
| line | Integer | ← | Line thickness |
| color | Integer | ← | Border color |
History
| Release | Changes |
|---|---|
| 2003 | Created |
Description
The QR GET BORDERS command allows you to retrieve the border style for a border of a given cell.
area is the reference of the Quick Report area.
column is the column number of the cell.
row designates the row number of the cell. You can either:
- pass a positive integer value to designate the corresponding subtotal (break) level that is affected.
- pass one of the following constants of the QR Rows for Properties theme:
| Constant | Type | Value | Comment |
|---|---|---|---|
| qr detail | Integer | -2 | Detail area of report |
| qr grand total | Integer | -3 | Grand total area |
| qr title | Integer | -1 | Title of report |
border is the value that indicates which cell border is affected. Pass one of the constants from the QR Borders theme:
| Constant | Type | Value | Comment |
|---|---|---|---|
| qr bottom border | Integer | 8 | Bottom border |
| qr inside horizontal border | Integer | 32 | Inside horizontal border |
| qr inside vertical border | Integer | 16 | Inside vertical border |
| qr left border | Integer | 1 | Left border |
| qr right border | Integer | 4 | Right border |
| qr top border | Integer | 2 | Top border |
Note: Unlike the command QR SET BORDERS, QR GET BORDERS does not accept a cumulative value. You must test all the parameters separately to have an overall view of the cell border.
line is the thickness of the line:
- 0 indicates no line
- 1 indicates a thickness of 1/4 point
- 2 indicates a thickness of 1/2 point
- 3 indicates a thickness of 1 point
- 4 indicates a thickness of 2 points.
color is the color of the line; it returns the value of the color applied to the line segment.
If you pass an invalid area number, the error -9850 will be generated.
If you pass an invalid column number, the error -9852 will be generated.
If you pass an invalid row number, the error -9853 will be generated.
If you pass an invalid border parameter, the error -9854 will be generated.
See also
Properties
| Command number | 798 |
| Thread safe | no |
| Modifies variables | error |