Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
80
Wrong value when using formulas in Excel with region specific format strings
posted

Hello!

We are using Infragistics3.Documents.Excel.v12.1 (Version 12.1.20121.2008) and have an issue with region specific formulas. Using a system with the region and language set to German, the evaluation of the following formula fails: =TEXT(A1;"0,00"), the value in cell A1 is 1,6666.

Excel shows the correct value of "1,67", with infragistics the value is interpreted as "002". It seems, when interpreting this formula, the invariant culture is used instead of the current system culture. Do we have to set the culture explicitly before reading the cell's value?

I have attached a small program using the infragistics lib and an example Excel file.

InfragisticsXlsTest.zip