Hi,
Is there a way to calculate/sum the display value instead of the keyed value on the spreadsheet control? In the example below, the actual value for the E3 and E4 is actually 1.5 as we do not allow decimal points, it is shown as 2 instead of 1.5. I will like the sum (cell E5) to be "4" instead of "3". Is it possible?
1 Answer, 1 is accepted
Hello Brian,
The Spreadsheet SUM formula will return - the set of numbers, including all numbers in a range. If the value of the cell is a decimal number, it will be used for the calculation.
You could take a look at the article regarding custom functions and try to implement a custom formula according to the requirements of the project:
- https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/custom-functions
Regards,
Neli
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.