stTabColor doesn't work for most predefined colors and any RGB color that contains a non 0- -1- 128 value in any RGB value

Aspose.Cells Product Family
1

Most of the predefined RGB color objects don’t work following use of the setTabColor method. Stanard colors (red/blue/green) seem to work but no predefined color or rgb color that has non 0,128 or -1 values in the rgb values seems to work.

eg
worksheet.setTabColor(Color.getRed()) works
worksheet.setTabColor(Color.getAcqa()) works
worksheet.setTabColor(Color.getAcqamarine()) does not work
worksheet.setTabColor(Color.getBlack()) works
worksheet.setTabColor(Color.getBlueViolet()) does not work
worksheet.setTabColor(Color.fromArgb(128, 128, 128)) works
worksheet.setTabColor(Color.fromArgb(64, 64, 64)) does not work

The list that don’t work seem to be any rgb value that has a non-0 non-128 or non-(-1/255) in any rgb value.

2

Hi,

Thanks for your posting and using Aspose.Cells.

Please save your workbook in Xlsx format and not in Xls format, then it will work fine. Please also download and use the latest version Aspose.Cells
for Java v7.5.2.1 for your needs.

We have tested it with the following code and also attached the output xlsx file for your reference.

Java


Workbook workbook=new Workbook();


Worksheet worksheet = workbook.getWorksheets().get(0);


worksheet.setTabColor(Color.fromArgb(64, 64, 64));


workbook.save(“F:/Shak-Data-RW/Downloads/output.xlsx”);