Formula reference Another spreadsheet

4 posts, 1 answers
  1. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 23 Feb 2017 Link to this post

    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

     

  2. Ivan Danchev
    Admin
    Ivan Danchev avatar
    2080 posts

    Posted 24 Feb 2017 Link to this post

    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.
  3. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 24 Feb 2017 in reply to Ivan Danchev Link to this post

    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

  4. Answer
    Ivan Danchev
    Admin
    Ivan Danchev avatar
    2080 posts

    Posted 24 Feb 2017 Link to this post

    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.
Back to Top