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

Formula reference Another spreadsheet

3 Answers 164 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Marc
Top achievements
Rank 1
Marc asked on 23 Feb 2017, 07:50 AM

Hi, Is there a way to add a formula to spreadsheet X that references another kendo spreadsheet on the same page (spreadsheet Y)? If there is, can you send a small example please?

Thanks

Marc

 

3 Answers, 1 is accepted

Sort by
0
Ivan Danchev
Telerik team
answered on 24 Feb 2017, 07:47 AM
Hello Marc,

The Excel formula syntax for referencing other sheets (=Sheet2!A1*2 for example) is supported by the Spreadsheet.

Edited.

Regards,
Ivan Danchev
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Marc
Top achievements
Rank 1
answered on 24 Feb 2017, 07:52 AM

Hi Ivan,

Thanks for the quick reply! I was actually looking for a way to reference a different spreadsheet completely, not just another sheet in the same kendo spreadsheet. Is this possible?

Thanks

Marc

0
Accepted
Ivan Danchev
Telerik team
answered on 24 Feb 2017, 08:08 AM
Hello Marc,

Referencing another Spreadsheet widget is currently not  supported. I can suggest logging your idea as a feature request in our public Feedback Portal.

Regards,
Ivan Danchev
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Spreadsheet
Asked by
Marc
Top achievements
Rank 1
Answers by
Ivan Danchev
Telerik team
Marc
Top achievements
Rank 1
Share this question
or