Problem with Filters in xlsx file

[Nabil]

Hello,

I used spreadsheet to open an xlsx file like in this demo (http://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export), but I found a problem with the filters in the excel file. In the "filter by value" zone, it appears only "all" , the other values doesn't appear , also for the "filter by Condition" zone when I try to find some value the filter doesn't work, it only changes the color of the arrow icon but all the values still exists.

As for the excel file I created a simple excel file with some filters. I noticed that the filters works only if I used an excel file that I have already used its filters in Microsoft excel.

I used 

below the code that I used 

HomeController.cs:

        public string GetJsonExcel(string fileName1)
        {
            var fileName = fileName1.Replace("***", "'");
            string pathF = ConfigurationManager.AppSettings["PathDocs"].ToString();
            var physicalPath = Path.Combine(pathF, fileName);
            var workbook = Workbook.Load(physicalPath);
            return workbook.ToJson();
        }

 

Index.cshtml:

<div id="spreadsheet" style="width: 100%; height: 99%"></div>
<script>

    $("#spreadsheet").kendoSpreadsheet();
    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    $.getJSON(generateUrlWithParam("Home", "GetJsonExcel", "fileName1", "spreadsheet with file after using filters in microsoft excel.xlsx"))
        .done(function (sheets) {
            spreadsheet.fromJSON(sheets);
          });
         
        });
</script>

Best regards, 

 

[Nencho]

Hello Nabil,

The demonstrated implementation seems to be correct. In addition, I have tested the described problematic behavior with the referenced online demo, but I was unable to replicate the listed issues with the filter.

Could you test the behavior with the same excel file, using our online demo and let us know whether the issue still replicates? In addition, it would be great if you could submit a support ticket, along with a runnable sample attached, so we could test with the very same implementation that you have at your end in attempt to replicate the issue and pin down the reason for it.

Regards,
Nencho
Telerik by Progress

[Nabil]

Hi,

i used the same Excel file, when i import it via your online demo it not show the filter, i attached a screen of the file that i used with my message, it's simple juste create an excel file with some information and add a filter without doing any filter and then import it  via this is the url of your demo that i used : http://demos.telerik.com/aspnet-mvc/spreadsheet/sorting-filtering.

if i use the filter in local and i let it selected the if i import it via your demo it will work and wil show the filter.

PS: if you can tel me how can i create a support ticket.

Thanks,

best regards

[Nencho]

Hello Nabil,

I was able to replicate the described issue and it seems to be a bug with the Spreadsheet widget. I have logged it in our GitHub repo below:

https://github.com/telerik/kendo-ui-core/issues/3137

As for the support tickets, since you are a licensed user, you are able to submit a dedicated support ticket from your Telerik account - https://www.telerik.com/account/support-tickets

In addition, I have updated your Telerik Points for reporting for that problem. 

Regards,
Nencho
Telerik by Progress