Spreadsheet - Calculate display value instead of keyed value

1 Answer 27 Views
Spreadsheet
Brian
Top achievements
Rank 1
Iron
Brian asked on 03 Feb 2022, 08:49 AM

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

Sort by
0
Neli
Telerik team
answered on 08 Feb 2022, 07:52 AM

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.

Tags
Spreadsheet
Asked by
Brian
Top achievements
Rank 1
Iron
Answers by
Neli
Telerik team
Share this question
or