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
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.
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 Thomas,
Its good that you were able to narrow down the issue, so if the issue is with German setting then i would like to have the same setting at my end and should be able to reproduce the issue , i open the control panel-> region setting and changed the format to German(Germany) pow i would like to know what is the setting for number in Germany?
I attached a doc file with the screenshot , help me with the settings and ill see if i am able to reproduce it.
RegionSetting.docx
Hi Divya,
Number format settings are identical to your screenshort. Decimal,grouping symbol show as expected in your screenshot.
For the Region format i do have "same as windows", since my windows installtion itself is german, also i use a german office, meaning also a german Excel, maybe this is the importtant point.