The Worksheet Tabcolor property does not save to file for Chart Worksheets

Hi,


I am using Aspose.Cells 7.0.1.0 and I am trying to set the tabcolor of a worksheet of type chart. If I open a workbook that contains a chart worksheet with a tab color set, and then save the file, the tab color on the chart worksheet disappears. This is the code:

FileStream fstream = new FileStream(“TestBook.xlsx”, FileMode.Open);
Workbook workbook = new Workbook(fstream);
workbook.Save(“Output.xlsx”, SaveFormat.Xlsx);

Also I have tried to directly set the tabcolor property of the worksheet as below:
//This line does not work:
workbook.Worksheets[“ChartWS”].TabColor = Color.Red;
//This line works:
workbook.Worksheets[“RegularWS”].TabColor = Color.Red;

Thanks,
Kirk

Hi,

Please provide us your source TestBook.xlsx file. We will check it and update you asap.

Hi,

I was able to replicate the issue with the latest version:
Aspose.Cells for .NET v7.0.1.3

Below is my code and screenshot for a reference. I have also attached the output file.

We have logged this issue. We will fix it and update you asap.

This issue has been logged as CELLSNET-30919.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\TestBook.xlsx”;


Workbook workbook = new Workbook(filePath);

workbook.Save(filePath + “.out.xlsx”, SaveFormat.Xlsx);


Screenshot:


Hi,

We have fixed this issue. Please download: Aspose.Cells for .NET v7.0.1.6

I have tested the new version and it now saves the tabcolor correctly for the xlsx format.


workbook.Save(“Output.xlsx”, SaveFormat.Xlsx);

However I also need it to work for the xls format. The line of code below will cause the same issue where the tab color is green for a chart worksheet for an existing workbook but it does not save to the output file.

workbook.Save(“Output.xls”, SaveFormat.Excel97To2003);


Hi,

You are right. We will fix it asap and let you know.

The issues you have found earlier (filed as 30919) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.