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: