Import excel with named ranges does not work

2 posts, 0 answers
  1. Nikos
    Nikos avatar
    1 posts
    Member since:
    Feb 2017

    Posted 14 Feb 2017 Link to this post

    when importing a spreadsheet which has named ramges the named ranges are not imported. So any cells that reference these by range name do not work.

    See attached file for demo.

    Nick.

     

  2. Ianko
    Admin
    Ianko avatar
    1940 posts

    Posted 16 Feb 2017 Link to this post

    Hello Nikos,

    Frankly, named ranges are not supported by Kendo Spreadsheet. I encourage you to post a feature request here: http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback

    A possible alternative is to use server-side approach to import the excel file and process it by using RadSpreadProcessing library. Which will eventually enable you to transform the named ranges to cell ranges. http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/named-ranges

    Regards,
    Ianko
    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