Missing Excel Functions

2 posts, 0 answers
  1. Manas
    Manas avatar
    2 posts
    Member since:
    Sep 2016

    Posted 27 Feb Link to this post

    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

  2. Tanya
    Admin
    Tanya avatar
    577 posts

    Posted 02 Mar Link to this post

    Hi Manas,

    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 is 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
    Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
Back to Top