Questions about conditionals formats

[Simon.yang]

Hello,

Glad to inform you that the issue of conditional format has been fixed. Please download Spire.XLS Pack Hotfix Version:7.12.144 and give it a try.

Sincerely,
Simon
E-iceblue support team

[Simon.yang]

Hello,

Greeting from E-iceblue.
Has the hotfix resolved your issue?
Your feedback will be greatly appreciated.

Best regards,
Simon
E-iceblue support team

[VincentB]

Hello

Thanks for the hotfix. it resolved some issues but i have others

I want to create a containsText Conditional format but Range["A1:B4"] is blue, not just .Range["A1:A4"]

Code: Select all

ws.Range["A1:A4"].Value = "2007";
ws.Range["B1:B4"].Value = "2008";

var cond = ws.Range["A1:B4"].ConditionalFormats.AddCondition();
cond.FormatType = ConditionalFormatType.ContainsText;
cond.FirstFormula = "7";
cond.FontColor = Color.Aqua;
cond.BackColor = Color.Blue;


CondFormat.PNG (28.43 KiB) Viewed 3518 times

And other issue, a containsText Conditional format on text value :

Code: Select all

ws.Range["A1:A4"].Value = "AA";
ws.Range["B1:B4"].Value = "BB";

var cond = ws.Range["A1:B4"].ConditionalFormats.AddCondition();
cond.FormatType = ConditionalFormatType.ContainsText;
cond.FirstFormula = "A"; //   'A is not valid named range'
cond.FontColor = Color.Aqua;
cond.BackColor = Color.Blue;


I have an message 'A is not valid named range'

Thanks

[Gary.zhang]

Hello,

The value of FirstFormula needs to use the MakeFormula method to assign. Here is the code for your reference. Sorry for inconvenience, we will consider changing this way.

Code: Select all

cond.FirstFormula = cond.MakeFormula("A");

Sincerely,
Gary
E-iceblue support team

[VincentB]

Hello,

Thanks of the MakeFormula method, it's work

I can change value in Excel cell and ConditionalFormat is ok but i do'nt know how i do'nt see conditiond value in Excel config :

cf.png (24.45 KiB) Viewed 3507 times

Thanks

[Gary.zhang]

Hello,

Thanks for your feedback. I have noticed the issue and posted it to our Dev team, once it is resolved, or we have some other update, we will let you know.

Sincerely,
Gary
E-iceblue support team

[Simon.yang]

Hello,

Glad to inform your that the issue has been fixed. Please download Spire.XLS Pack(Hotfix) Version:8.4.6 and refer to the below code snippet to have a try.

Code: Select all

Workbook workBook = new Workbook();
Worksheet ws = workBook.Worksheets[0];
ws.Range["A1:A4"].Value = "AA";
ws.Range["B1:B4"].Value = "BB";
XlsConditionalFormats xcfs = ws.ConditionalFormats.Add();
xcfs.AddRange(ws.Range["A1:B4"]);
IConditionalFormat cf = xcfs.AddContainsTextCondition("A");
cf.FontColor = Color.Aqua;
cf.BackColor = Color.Blue;
workBook.SaveToFile(outputFile, FileFormat.Version2010);

Sincerely,
Simon
E-iceblue support team

[Simon.yang]

Hello,

Greeting from E-iceblue.
Has the hotfix resolved your issue?
We will appreciate it if you could give us some feedback.

Best regards,
Simon
E-iceblue support team

[VincentB]

Hello,

It's work !

Thanks

[Simon.yang]

Hi Vincent,

Thanks for your prompt reply. If there is any other question, welcome to write to us.

Best regards,
Simon
E-iceblue support team