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

Import excel with named ranges does not work

1 Answer 120 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Nikos
Top achievements
Rank 1
Nikos asked on 14 Feb 2017, 09:20 PM

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.

 

1 Answer, 1 is accepted

Sort by
0
Ianko
Telerik team
answered on 16 Feb 2017, 12:54 PM

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.
Tags
Spreadsheet
Asked by
Nikos
Top achievements
Rank 1
Answers by
Ianko
Telerik team
Share this question
or