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.

Wed Sep 13, 2017 1:41 pm

Hello,

I have an issue when i try to add some ConditionalsFormats to an Excel File with others ConditoinalsFormats in others sheet
The added ConditionalsFormats exist but take colors of first ConditionalsFormats.

Code: Select all
var workbook = new Workbook();
workbook.LoadFromFile("...\Sample.xlsx");
var worksheet = workbook.Worksheets["Feuil1"];
           
var range = worksheet.Range["B2:B6"];

// INf
var cond = range.ConditionalFormats.AddCondition();
cond.FormatType = ConditionalFormatType.CellValue;
cond.Operator = ComparisonOperatorType.Less;
cond.FirstFormula = "3";
cond.FontColor = Color.Red;
cond.BackColor = Color.Brown;

workbook.SaveToFile(Chemin + "Sample - Out.xlsx", ExcelVersion.Version2016);


Do you reproduce the issue ?
Do you have bypass ?

I use Spire.XLS 7.12.69

Thanks
Attachments
Sample.zip
(6.37 KiB) Downloaded 253 times

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Thu Sep 14, 2017 3:02 am

Dear VincentB,

Thanks for your inquiry.
Sorry that I didn't find the added ConditionalsFormats would impact the first ConditionalsFormats on the Feuil2 worksheet using Spire.XLS 7.12.76. But I noticed the color of added ConditionalsFormats is wrong, and posted it to our Dev team. We will inform you when there is any progress.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Fri Oct 20, 2017 7:42 am

Hi VincentB,

Thanks for waiting.
Now the issue I mentioned has been resolved in Spire.XLS Pack Hotfix Version:7.12.100.
Looking forward to your feedback.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Oct 24, 2017 8:13 am

Hi VincentB,

Greetings from E-iceblue.
Has the issue been resolved ?
Your feedback would be greatly appreciated.

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Oct 24, 2017 8:40 am

Hello,

Yes, I don't reproduce the issue !!

Thank you

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Tue Oct 24, 2017 9:03 am

Hi VincentB,

Thanks for your feedback.
Please feel free to contact us if there is any question.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS