Problem with Filters in xlsx file

4 posts, 0 answers
  1. Nabil
    Nabil avatar
    9 posts
    Member since:
    May 2016

    Posted 26 Apr 2017 Link to this post

    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, 

     

  2. Nencho
    Admin
    Nencho avatar
    1871 posts

    Posted 28 Apr 2017 Link to this post

    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.
  3. Nabil
    Nabil avatar
    9 posts
    Member since:
    May 2016

    Posted 28 Apr 2017 in reply to Nencho Link to this post

    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

  4. Nencho
    Admin
    Nencho avatar
    1871 posts

    Posted 02 May 2017 Link to this post

    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.
Back to Top