Forums Ultimate UI for Windows Forms
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
Close
J Jäger
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
No Data
Reply
  • 29065
    Offline posted

    Hello Janina,

    As our documentation states:

    "If a forumula has been applied to a cell or a dta table is associated with the cell, getting the Value will return the calculated value of the cell."

    If you wish to retrieve the cell text you can try using the GetText Method.

    Let me know if you have any questions regarding this matter.

Children