Hi all,
i am working on a WPF application, which also uses the WPF Excel Engine..
I am using the latest version of IG controls, 24.1.39
i am trying to add a linecghart to excel, using the AddChart/SetSource Data Methods.
A stripped down datatable has two columns, a string, and a double column.
Filling this with some data reuslts in the following problem.
Wen i use integers for CellValues out of the dataset all is fine, excel docuiment opens without problems.
When usimng a double value, the excel file complains about seome wrong data in there, auto fixcing works, the chart itself displays correctly then. But we cannot ship the application with that error message of course.
Are there any ideas out there, what might go wrong here?
Thanks in advance.
i added a small sample project to show the probelm.ExcelTest.zip
Hi Divya, thanks for the answer.
Personally i am running Excel from the Office Professional Plus 2021 package. Collegues run Excel 2019.
All have same problem.
The screenshots were supposed to be attached in my original posts, disappeared anyhow.
I try again. Its in German though (also tried to set the culture for the workbook, did not help)
The second screenshot appears, when confirming the first message with "Yes".
It displays and charts the data correctly, so i really dont know whats going on here.
Thanks
Thomas
p.s. i again tried to attach images, they are auto deleted by the system.
Hello,
I run the same as it is (with double value) i dont get the error/complain message . May i know which version of MS excel file do you have it installed? and please share the screenshot of error message /dialog you are getting.