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
WorksheetCell.Value does not resolve MS Excel 'Text' function
posted

Hi there!

We are using WinForms 12.1 and are having problems with retrieving the correct value for certain cells with formulas.

For example the formula TEXT(B2;"tt.MM.jjjj") with ("01.04.2013") displayed in cell B2, will return "tt.04.jjj" as calculated value using WorksheetCell.Value, whereas in Excel this value will resolve correctly to "01.04.2013".

Is it not possible to resolve text formatting formulas with the infragistics Excel engine?

Thanks for your help!

Janina

Parents Reply Children