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

Aspose.Cells Product Family
1

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
2

Hi,

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

3

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:


4

Hi,

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

5

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);


6

Hi,

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

7

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.