Skip to Content

In SAP sample ALV report BCALV_GRID_01, when the output is downloaded into spreadsheet XXL format. Colors appear for the key rows and column headings with default color.

In this blog we are going to see how to change those default colors to user defined.

Go to transaction SE38, execute the report BCALV_GRID_01. Click on Export –> Spreadsheet –> XXL –> Table –> Microsoft excel.

/wp-content/uploads/2016/01/4_871121.jpg

/wp-content/uploads/2016/01/5_871124.jpg

/wp-content/uploads/2016/01/5_871124.jpg

/wp-content/uploads/2016/01/5_871124.jpg

The output below has default colors in the rows and columns as below.

/wp-content/uploads/2016/01/5_871124.jpg

These colors are defaulted or hard-coded in the system as in the below report.

2.JPG

The system looks for the user defined colors from table COLORSEXC, if there is no user default then it uses the default color codes 12 and 36.

Lets try by maintaining the table COLORSEXC to use the user defined colors.

Refer to the below link for the color codes used in excel.

Color Palette and the 56 Excel ColorIndex Colors

We will use color code 32 and 34.

2.JPG

Now execute the report again and download it into XXL format as explained earlier and it downloaded with the user defaults colors maintained in the table.

2.JPG

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply