Unable to insert fractional values into Excel using OpenXMLSDK2.0

Question

Hi,

I am not able to insert fractional data(Ex: 2.3, 111.24) into Excel2011 using OpenXML SDK through C#.

My code works completely fine if I insert intergers or strings. The code is similar to the ones present in

http://msdn.microsoft.com/en-us/library/dd452407(v=office.12).aspx

or

http://debugmode.net/2011/10/04/inserting-in-excel-file-from-c-collection-using-open-xml-sdk-2-0/

Can someone guide me, what I should be doing different.

Regards,

Sandeep

Answer 1

Hi SandeepKorrapati,

Thanks for posting in the MSDN Forum.

I'm not able to reproduce your issue due to I have no mac environment to reproduce your issue. I will involve some experts into this issue to see whether they can help you. It might be some time delay, thanks for your patience.

Have  a good day,

Tom

---

Tom Xu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi Tom,

Thanks for the reply. But, I have solved my problem. It was occurring due to the culture difference.

The values being generated by my .ToString() were ","(comma) separated. I think is because of German-standards coming into picture. 

If I replace the "," with "." everything is working fine.

Regards,

Sandeep