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

sheet.range.values function does not work on formula cells

1 Answer 166 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Adel Chenni
Top achievements
Rank 1
Adel Chenni asked on 14 May 2016, 03:07 AM

Using the below code: 

sheet.range("A2").formula("0");
sheet.range("A1:A3").values([[1],[2],[3]]);

I noticed that A2 is set to 0. I was expecting it to be set to 2. Is this expected or is it a bug?

Most likely, it is a bug since the below code sets all the range to 2 (including A2). 

sheet.range("A2").formula("0");
sheet.range("A1:A3").value(2);


1 Answer, 1 is accepted

Sort by
0
Accepted
Stefan
Telerik team
answered on 16 May 2016, 07:47 AM
Hello Adel,

Thank you for your report. I confirm this is an issue with the present version of the Kendo UI Spreadsheet.  I have forwarded your report to our developers for fixing. In addition, I have updated your Telerik points for bringing the problem to our attention.

Regards,
Stefan
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
Tags
Spreadsheet
Asked by
Adel Chenni
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or