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