This is a migrated thread and some comments may be shown as answers.

SpreadSheet custom function execute 3 times

2 Answers 83 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Zhang
Top achievements
Rank 1
Zhang asked on 11 Nov 2015, 09:09 AM
Hi,I am developing with RadSpreadsheet control.I register my custom function to the RadSpreadsheet .When the function evaluates ,I found that each time the EvaluateOverride method execute 3 times.Is there anything wrong here,or it's supposed to do this.I just worry about running efficiency.

2 Answers, 1 is accepted

Sort by
0
Zhang
Top achievements
Rank 1
answered on 11 Nov 2015, 09:30 AM
Sorry, not each time!  The problem arise when I paste my custom function to the cell rather than type the function text into the cell.
0
Nikolay Demirev
Telerik team
answered on 12 Nov 2015, 09:39 AM
Hello,

The copy - paste feature uses worksheet internally, in which the copied values are set. And for this logic to work in some scenarios there is a need to calculate the functions, so they can be successfully copied.

Is this behavior causing some performance hits in your project?

Regards,
Nikolay Demirev
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Spreadsheet
Asked by
Zhang
Top achievements
Rank 1
Answers by
Zhang
Top achievements
Rank 1
Nikolay Demirev
Telerik team
Share this question
or