String.Format(CultureInfo.GetCultureInfo("de-DE").NumberFormat, "{0:0.00}", someValue) does not format

[Peter]

I am trying to format outside of Syncfusion a String for a Cell in an EXCEL-file.
But the result in c# is not the same as in Excel, I need need a pricision of 2 digit without any currency sign.

This works:

String.Format(CultureInfo.GetCultureInfo("de-DE"), "{0:C}", someValue)

But that is not what I am looking for.

I need 2 digits and no sign, that is what I tried:

 String.Format(CultureInfo.GetCultureInfo("de-DE").NumberFormat, "{0:0.00}", someValue)

How to do this ?

[Abirami Varadharajan]

Hi Peter, 

Thank you for contacting Syncfusion support. 

As you are assigning value to the cell by appending two digits along with decimal, it gets ignored as per MS Excel behavior. 

So, we request you to apply Number format to the cell to achieve your requirement. Kindly refer below code snippet to achieve the same. 

Code Example: 

worksheet.Range["A10"].Value = "10000"; 

worksheet.Range["A10"].NumberFormat = "0.00"; 

 

Please let us know if you have any concerns. 

Regards, 

Abirami