QR GET BORDERS

version 2003

QR GET BORDERS (area; column; row; border; line{; color})

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.

• if row equals -1, the title of the report is affected

• if row equals -2, the detail of the report is affected

• if row equals -3, the grand total of the report is affected

• if row is a positive integer, it designates the Subtotal (break) level that is affected.

You can use constants from the QR Rows for Properties theme to designate the row item (qr title= -1, qr detail=-2, qr grand total=-3).

border is the value that indicates which cell border is affected:

• 1 indicates the left border

• 2 indicates the top border

• 4 indicates the right border

• 8 indicates the bottom border

• 16 indicates the inside vertical border

• 32 indicates the inside horizontal border.

You can use constants from the QR Borders theme to designate the border item.

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.

QR SET BORDERS.