Named Ranges in formula

[Jerry]

I created a simple xlsx file with 2 worksheets - Sheet1, and Sheet2.

Create a Named Range called NR1 that References Sheet2:B5

On Sheet1 create a formula "=NR1"

This looks great in excel.

Open it in RadSpreadsheet and it comes up as #NAME?

Is this a shortcoming in RadSpreadsheet, or am I missing something VERY fundamental?

 

[Peter Milchev]

Hello,

Indeed it seems that the RadSpreadsheet server-side object does not support Named Ranges. 

Nevertheless, you can load them client-side with the code below, by saving a JSON in a hidden field and loading it via the API:

protected void Page_Init(object sender, EventArgs e)
{
    var path = Server.MapPath("~/App_Data/spreadsheet.xlsx");
    var workbook = Workbook.Load(path);
    HiddenField1.Value = workbook.ToJson();
}

<script>    
    function pageLoadHandler() {
        var spreadsheet = $find("<%= RadSpreadsheet1.ClientID %>");
        var hiddenfield = $get("<%= HiddenField1.ClientID %>");
        if (hiddenfield.value) {
            spreadsheet.get_kendoWidget().fromJSON(JSON.parse(hiddenfield.value))
            hiddenfield.value = '';
        }

        // Sys.Application.remove_load(pageLoadHandler);  
    }
    Sys.Application.add_load(pageLoadHandler);
</script>
<telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1"></telerik:RadSpreadsheet>
<asp:HiddenField runat="server" ID="HiddenField1" />

A similar project you can find here:

• https://www.telerik.com/support/code-library/spreadsheet-client-side-import-file-from-server-and-save-client-side-exported-file-on-server

Also, I have logged a feature request for the server-side support for NamedRanges which you can follow here:

•  https://feedback.telerik.com/aspnet-ajax/1463541-server-side-support-for-named-ranges

As a token of gratitude for helping us identify the issue, I have updated your Telerik points.

Regards,
Peter Milchev
Progress Telerik