Looks like few of the Excel functions are missing from the current WPF spreadsheet control, below are the few which we have found missing.
VALUE
MID
TRIM
Query 1: Does WPF spreadsheet control have an alternate names to these function which perform the same action?
Query 2: We are using a trial version for evaluation and may be the reason these have been omitted, could you please confirm the above/All of excel's default formulas are available in the retail version of Telerik WPF spreadsheet.?
Query 3: If not available, will Telerik plan to provide an update with these missing formulas implemented ?
However these missing formula appears to be in the ASP.NET version of the spreadsheet, which is quite strange, because i thought releases of WPF version and ASP.NET version of the spreadsheet control are in sync.
Regards
Manas
1 Answer, 1 is accepted
The mentioned functions are not supported in RadSpreadsheet for WPF. Some of the formulas supported by the web Spreadsheet control are not supported by RadSpreadProcessing, which is used as a model of RadSpreadsheet for WPF. Actually, RadSpreadProcessing is used for import/export and server-side conversion to PDF, but the calculation engine of the ASP.NET Spreadsheet is different. You can find a list of the functions supported by RadSpreadsheet for ASP.NET AJAX in the Formulas and Functions help article and the list for the WPF control available in the Functions article for RadSpreadProcessing.
Here are the feature requests for the three functions:
You can vote for an implementation of the functions as well as subscribe for notifications about status changes on them using the above linked public items.
The API for the functions in RadSpreadsheet is very extensible, so you should be able to add the functions as custom functions. How you can achieve this is described in the Custom Functions help topic. There is also a very handy code sample at GitHub here:
https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/CustomFunctions.
Hope this is helpful.
Regards,
Tanya
Telerik by Progress