The SUMIFS function adds all of its arguments that meet multiple criteria. A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions This function can be implemented as a custom function. Check the following resources for more details on how to achieve that: - http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions - https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/WPF/CustomFunctions
Handle the case when the cell is too small and the value contains a decimal separator.
For example, see attached images.
Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. If we want to be consistent with MS Excel we should implement this property. It is useful for many operations of a region such as filtering(selecting one cell and executing the Filter command should apply it to the current region), sorting, selecting all and etc. This document will be useful: https://docs.microsoft.com/en-us/office/vba/api/excel.range.currentregion.
Add information about the selection in the SelectionChanged event arguments.
- We need to differentiate from mouse event to keyboard event. But since the EventArgs is empty we are not able to differentiate.
Add an event that indicates when a hyperlink is clicked.
Spreadsheet: Add the ability to build formulas using keyboard navigation:
1. Press '=' in a cell. The cell goes into Edit Mode.The sheet selector should hide sheets when their visibility is set to hidden or very hidden. The context menu of the sheet selector should contain Hide and Unhide options that allow to hide a sheet or unhide one of the hidden sheets.