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

Problem with Filters in xlsx file

3 Answers 64 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Nabil
Top achievements
Rank 1
Nabil asked on 26 Apr 2017, 08:57 AM

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, 

 

3 Answers, 1 is accepted

Sort by
0
Nencho
Telerik team
answered on 28 Apr 2017, 06:46 AM
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
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.
0
Nabil
Top achievements
Rank 1
answered on 28 Apr 2017, 02:39 PM

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

0
Nencho
Telerik team
answered on 02 May 2017, 10:45 AM
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
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
Nabil
Top achievements
Rank 1
Answers by
Nencho
Telerik team
Nabil
Top achievements
Rank 1
Share this question
or