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