Entering content frameSyntax documentationset_color Locate the document in its SAP Library structure

Sets the font and background colors for a particular area. The values come from the color palette in Excel, not RGB values, even if the spreadsheet in question only accepts RGB values.

CALL METHOD spreadsheet->set_color
       EXPORTING rangename = rangename
                 front     = front
                 back      = back
                 no_flush  = no_flush
       IMPORTING error     = error
                 retcode   = retcode.

Description of parameters

Parameter

Optional

Description

rangename

 

Area name

front

 

Font color (see color palette)

'-1' : Color remains unchanged

back

 

Background color (see color palette)

'-1' : Color remains unchanged

The color palette contains the following colors:

This graphic is explained in the accompanying text

Leaving content frame