My slides disappear when I set the date on a line chart

[egokan]

// This is a pre-existing chart with data in it

// I want to set the dates on the first column. If I do these, the entire slide blanks out.
// if I comment out these, everything is fine.
// Instead of date, I can also set the first column's value to a number - then it is fine. But I need to set the date.
// Here are lines that cause problems.
chart.ChartData[1+row, 0].Value = DateTime.Now.ToString();
chart.ChartData[1+row, 0].Text= DateTime.Now.ToString();

// However, I can safely set the value of the the first or second column to a number.
// when I save the PowerPoint everything is fine.
chart.ChartData[1+row, 0].Value = 100.
chart.ChartData[1+row, 1].Value = 100.

[amy.zhao]

Hello,

Thanks for your inquiry.
Sorry for the inconvenience. I have posted your issue to our dev team. We will tell you when it is resolved.
Welcome to write to us again for further problems.

Best wishes,
Amy
E-iceblue support team

[Gary.zhang]

Hello,

Sorry for long silence. Now it can support the feature to set some chart data as date value. Please download the newest hotfix from the link as below and try the following code.

http://www.e-iceblue.com/Download/downl ... t-now.html

Code: Select all

chart.ChartData[1, 0].Value = DateTime.Now;
chart.PrimaryCategoryAxis.NumberFormat = "yyyy-mm-dd";


If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team

[amy.zhao]

Hello,

Did Spire.XLS Pack Hotfix Version:7.6.43 resolve your issue?
Thanks for your feedback.

Best wishes,
Amy
E-iceblue support team