How to set empty cell in PowerPoint

[Kinali94]

Hello,

How to set =N/A or empty cell dynamically in PowerPoint chart?

Code: Select all

chart.ChartData[1 + index, 1].Value = null

It gives error if I set null as value.

Thanks,
Kinali Gandhi

[rachel.lei]

Hi Kinali,

Sorry for the late reply as weekend.
I tested your code with the latest Spire.Presentation Pack Hotfix Version:5.8.1 but did not encounter any issue. If you are using an older version, please download the latest version and try again.
Besides, I tested the code below and found that it also works well. You can give it a try on your side.

Code: Select all

                    chart.ChartData[1 + index, 1].Value = "";
                    chart.ChartData[1 + index, 1].Value = string.Empty;

If the issue still occurs after trying, please provide you full test code, and tell us your OS information and region setting, e.g. Win7 64 bit, China/Chinese.

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Greetings from E-iceblue!
How is your issue now? Looking forward to your feedback!

Sincerely,
Rachel
E-iceblue support team

[Kinali94]

Hello rachel,

Issue has been resolved, Thank you for you support and quick response.

Regards,
Kinali Gandhi

[rachel.lei]

Hello,

Thanks for your feedback!
Feel free to contact us if you encounter any questions in the future. Wish you all the best!

Sincerely,
Rachel
E-iceblue support team