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
Imran Javed Zia
2335
User Defined Custom Function are not recognized after Load from exported file
posted

Hi,
I have some Custom Functions defined for my WoorkBook. And I have provided functionality that user can export workbook and import already exported/saved file.
I have following two problems:


In Infragistics.Excel, these custom functions are not recognized and show name error althopught I've registered custom functions after load. like follwoing:
Workbook wb = Workbook.Load(s);                       
wb.RegisterUserDefinedFunction(new MyUDF());

In Excel, these custom functions are not recognized and show name error althopught I've add ins for then there too. but if I just edit the function and press enter then these are recalculated.

I've logged same issue under SilverLight Library:
http://forums.infragistics.com/forums/t/36063.aspx

Thanks

Parents
No Data
Reply
  • 44743
    posted

    The RegisterUserDefinedFunction method is used for the formula solving logic. It is so that you can provide logic for custom function names so that they may be evaluated in the Infragistics.Excel library. They do not carry over as user defined functions in Microsoft Excel. It is possible this can easily be accomplished by just adding some logic to the RegisterUserDefinedFunction method. If not, we may be able to provide some other means of registering user defined functions for use in Microsoft Excel. In either case, this should be submitted so a developer can look into this and determine the best solution.

    I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.

Children
No Data