spreadsheet formula - SUBTOTAL, SUMIFS?

2 posts, 0 answers
  1. Dodd
    Dodd avatar
    45 posts
    Member since:
    Dec 2012

    Posted 30 Aug 2017 Link to this post

    I used telerik WPF Radspreadsheet. 

    I have a question that why you didn't make some excel formulas like SUBTOTAL, SUMIFS. (but in KENDO UI, they are already built in. )


    Can I use these formulas another way in Radspreadsheet or Are you have any plans to built in those formulas in WPF Radspreadsheet? 

  2. Tanya
    Tanya avatar
    624 posts

    Posted 01 Sep 2017 Link to this post

    Hi Dodd,

    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 web Spreadsheet is different.

    You can find a list of the functions supported by Spreadsheet for Kendo UI in the Formulas and Functions help article and the list for the WPF control available in the Functions article for RadSpreadProcessing.

    We have already logged a request to implement the SUBTOTAL function in RadSpreadsheet for WPF and for the COUNTIF function, I just created one:

     - Support for SUBTOTAL function
     - Support for COUNTIF function

    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.

    Progress Telerik
    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