Conditional formatting when copy excel to doc

[nickmargu]

Hi,
I'm creating a report from multiple excel & word files.
I have an excel file with conditional formatting to hide 0 values.
I want to copy this excel to word file, but when I read cell.NumberText I get "0".
I would like to check is there a conditional formatting and apply it before copying.

Can anyone please explain me how?
Thanks in advance!

[Annika.Zhou]

Hello,

Thank you for your inquiry. To help us investigate and solve your issue more quickly and accurately, please provide the your input Excel file and the Word file you expected. You could attach it here or send to us via email (support@e-iceblue.com). Thanks in advance.

Sincerely,
Annika
E-iceblue support team

[nickmargu]

hi attached sample files

[Annika.Zhou]

Hello,

Thanks for your sharing.
An easy way to achieve your need is to set the cell.NumberValue of "0" as empty, then copy to excel file. See the code below.

Code: Select all

...
if (xCell.NumberValue == 0)
{
    xCell.Value = "";
}
...


Sincerely,
Annika
E-iceblue support team

[nickmargu]

Hi
thanks for your suggestion.
I want this behavior to be applied only when source excel has the conditional formatting definition.
Is there a way to check for conditional formatting in code?

[Nina.Tang]

Hi,

Thanks for your quick reply.
Our Spire.XLS provides the cell.HasConditionFormats to judge if a cell contains condition format. In your Excel file, these cells are applied condition format: =$A$4:$D$5,$A$32:$L$32,$A$22:$J$29,$A$34:$L$34,$A$16:$B$16,$A$20:$B$21,$A$6:$J$15,$A$17:$J$19. I think your ultimate goal is to get the style of the conditional formats, and apply the style when copying to Word, sorry to tell that the style of conditional formatting is calculated dynamically, there is no way to obtain it.
If there is any misunderstanding, please provide more information.

Sincerely,
Nina
E-iceblue support team

[Annika.Zhou]

Hello,

Greetings from e-iceblue.
How is your issue going? Can you give us some feedback at your convenience? Thanks in advance.

Sincerely,
Annika
E-iceblue support team

[nickmargu]

just used your suggestion to use

Code: Select all

 if (number == 0 && cell.HasConditionFormats)
               value = string.Empty;

[Annika.Zhou]

Hello,

Thank you for your feedback.
If you have other questions about using Spire.XLS in the future, please feel free to contact us.

Sincerely,
Annika
E-iceblue support team