Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Jul 25, 2019 11:29 am

Hi!

Code: Select all
CellStyle cellStyle = workbook.Styles.Add('MyStyle');
cellStyle.Color = Color.FromArgb(220, 220, 220);
cellStyle.FillPattern = ExcelPatternType.Solid;

CellStyle clonedStyle = workbook.Styles["MyStyle"].clone();


The Color property of cellStyle and clonedStyle are not the same.
Am I wrong or is it a bug?

lacoo2004
 
Posts: 2
Joined: Wed Jul 17, 2019 8:15 am

Fri Jul 26, 2019 3:33 am

Hello,

Thanks for your inquiry.
I indeed found that the Color property of cellStyle could not be cloned successfully. This issue has been logged into our bug tracking system for further investigating and fixing. If there is any progress, we will let you know. Sorry for the inconvenience caused.

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Thu Aug 15, 2019 9:34 am

Hello,

Glad to inform that we have just released Spire.XLS Pack(Hotfix) Version:9.8.5 which has fixed the issue that the Color property of cellStyle could not be cloned successfully. Please download it from the following links and test.
Website: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget: https://www.nuget.org/packages/Spire.XLS/9.8.5

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Return to Spire.XLS

cron