set_frame

You can change the appearance of the lines in a range using a control byte and a color index.

CALL METHOD spreadsheet->set_frame
       EXPORTING rangename = rangename
                 typ       = typ
                 color     = color
                 no_flush  = no_flush
       IMPORTING error     = error
                 retcode   = retcode.

Description of parameters

Parameter

Optional

Description

rangename

 

Area name

typ

 

Control byte for setting the frame

color

 

Frame color (see color palette)

The control byte type contains the following bits. If a bit is set, its corresponding line is drawn. You can set the thickness of the line to one of four levels using bits 6 and 7.

Bit

Description

0

Sets the left margin

1

Sets the top margin

2

Sets the bottom margin

3

Sets the right margin

4

Horizontal line

5

Sets the left margin

6

Thickness

7

Thickness