Add ConditionalFormats when other ConditionalFormats exist

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Add ConditionalFormats when other ConditionalFormats exist

Postby VincentB » 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 12 times
VincentB
 
Posts: 98
Joined: Thu Sep 15, 2016 9:44 am

Re: Add ConditionalFormats when other ConditionalFormats exi

Postby Betsy.jiang » 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: 1631
Joined: Tue Sep 06, 2016 8:30 am

Re: Add ConditionalFormats when other ConditionalFormats exi

Postby Betsy.jiang » 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: 1631
Joined: Tue Sep 06, 2016 8:30 am

Re: Add ConditionalFormats when other ConditionalFormats exi

Postby Betsy.jiang » 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: 1631
Joined: Tue Sep 06, 2016 8:30 am

Re: Add ConditionalFormats when other ConditionalFormats exi

Postby VincentB » Tue Oct 24, 2017 8:40 am

Hello,

Yes, I don't reproduce the issue !!

Thank you
VincentB
 
Posts: 98
Joined: Thu Sep 15, 2016 9:44 am

Re: Add ConditionalFormats when other ConditionalFormats exi

Postby Betsy.jiang » 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: 1631
Joined: Tue Sep 06, 2016 8:30 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests