Worksheet tab colours disappear

jeffry · September 13, 2006, 5:49am

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

Laurence · September 13, 2006, 6:15am

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.

jeffry · September 13, 2006, 6:28am

I'm using 4.0.2.0. I will try it with a simple excel file soon and let you know.

Thanks,

Jeffry

jeffry · September 28, 2006, 1:57am

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

Laurence · September 28, 2006, 2:12am

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

jeffry · September 28, 2006, 2:24am

Nope sorry, still the same.

Laurence · September 28, 2006, 2:39am

Please change your code to:

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

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

jeffry · September 28, 2006, 2:50am

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