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
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.