4D Doc Center : QR SET TEXT PROPERTY

Home

4D v14.3

QR SET TEXT PROPERTY


QR SET TEXT PROPERTY ( area ; colNum ; rowNum ; property ; value )

Parameter	Type	Description
area	Longint	Reference of the area
colNum	Longint	Column number
rowNum	Longint	Row number
property	Longint	Property number
value	Longint	Value for the selected property

Description

The QR SET TEXT PROPERTY command sets the text attributes for the cell determined by colNum and rowNum.

area is the reference of the Quick Report area.

colNum is the number of the cell column.

rowNum is the reference of the cell row. You can pass either:

a positive value designating the corresponding subtotal (break) level,

one of the constants from the QR Rows for Properties theme:

Constant	Type	Value	Comment
qr detail	Longint	-2	Detail area of report
qr footer	Longint	-5	Page footer
qr grand total	Longint	-3	Grand total area
qr header	Longint	-4	Page header
qr title	Longint	-1	Title of report

Note: When passing -4 or -5 as rowNum, you still need to pass a column number in colNum, even if it is not used.

Note: In cross-table mode, the principle is similar except for the row values, which are always positive.

property is the value of the text attribute to assign. You can use the constants of the QR Text Properties theme, and the following values can be set:

Constant	Type	Value	Comment
qr alternate background color	Longint	9	Alternate background color number
qr background color	Longint	8	Background color number
qr bold	Longint	3	Bold style attribute (0 or 1)
qr font	Longint	1	Font number returned by the Font number command
qr font size	Longint	2	Font size expressed in points (9 to 255)
qr italic	Longint	4	Italic style attribute (0 or 1)
qr justification	Longint	7	Justification attribute (0 for default, 1 for left, 2 for center or 3 for right)
qr text color	Longint	6	Color number attribute (Longint)
qr underline	Longint	5	Underline style attribute (0 or 1)

If you pass an invalid area number, the error -9850 will be generated.
If you pass an invalid colNum number, the error -9852 will be generated.
If you pass an invalid rowNum number, the error -9853 will be generated.
If you pass an invalid property number, the error -9854 will be generated.

Example

This method defines several attributes of the first column’s title:

  `The following call assigns the font Times:

 QR SET TEXT PROPERTY(qr_area;1;-1;qr font;Font number("Times"))

  `assigning the font size 10 points:

 QR SET TEXT PROPERTY(qr_area;1;-1;qr font size;10)

  `assigning the font attribute Bold:

 QR SET TEXT PROPERTY(qr_area;1;-1;qr bold;1)

  `assigning the font attribute Italic:

 QR SET TEXT PROPERTY(qr_area;1;-1;qr italic;1)

  `assigning the font attribute Underline:

 QR SET TEXT PROPERTY(qr_area;1;-1;qr underline;1)

  `assigning the color bright green:

 QR SET TEXT PROPERTY(qr_area;1;-1;qr text color;0x0000FF00)