Free Support Forum - aspose.com

Worksheet tab colours disappear

Hi,
I have an Excel template that I fill using the WorkbookDesigner. The template has coloured worksheet tabs. After filling the template the colours of the worksheets tabs are gone.
Any idea what might cause this?
Thanks,
Jeffry

Hi Jeffry,

I opened a template file with colored tabs and saved it into a new file. It works fine.

Which version of Aspose.Cells are you using? Could you please post a simple project to show your problem? Thank you.

I'm using 4.0.2.0. I will try it with a simple excel file soon and let you know.
Thanks,
Jeffry
Hi Laurence,
I've created a really simple test and whenever I save the excel sheet again, the tab colors have disappeared. I'm just wondering how I can attach that project to this post.
This is all I do:

WorkbookDesigner wb = new WorkbookDesigner();

wb.Open(@"C:\test\colortest\colortest.xls");

double exchangeRate = 1.23;

wb.SetDataSource("VariableName", (decimal)exchangeRate);

wb.Process();

wb.Save(@"C:\test\colortest\colortest1.xls");

Thanks,
Jeffry

We have found and fixed this issue. Please try this attached fix.

Nope sorry, still the same.

Please change your code to:

wb.Save(@"d:\test\colortest1.xls", FileFormatType.ExcelXP);

Default format is Excel2000 which doesn't support tab color feature.

Aha, so that's the problem! In that case, we'll leave it like that because we need to support Excel 2000.
Thanks for pointing that out.
Jeffry