Excel Filter overflow cut off

Dear Sir or Madam,

the popup filter in the SfGrid is cut off. The basic layout is as follows:

<div class="container-fs">
    <div class="row m-0 p-0 max-height-fixed">
        <div class="col m-0 p-0">
     <SfGrid>
[...]
     </SfGrid>
</div>
    </div>
</div>
<style>
.container-fs {
    width: 100%;
    max-width: 1880px;
    padding-right: 10px;
    padding-left: 10px;
    margin-right: auto;
    margin-left: auto;
}
.max-height-fixed {
    height: 790px;
    overflow-y: auto;
}
</style>

When the screen is FHD the popup opens to the left as it is supposed to do:


example_overflow_working.png


But when the screen is larger (e.g. WHQ), the filter pops up to the right and therefore is cut off by the container. 

example overflow.png


How can I make the filter popup open on the left? 


7 Replies

JP Jeevakanth Palaniappan Syncfusion Team September 29, 2021 09:36 AM UTC

Hi Jens, 

Greetings from Syncfusion support. 

We have prepared a sample based on the provided code but unfortunately we are unable to reproduce the reported problem from our end. Please find the validated sample and the screenshot for your reference. 


 

Also suggest you to share us the below details which will be helpful for us to reproduce the issue from our end. 

  1. Share us the exact screen size in which the issue is reproduced.
  2. Share us the video demo showing the reported problem.
 
Regards, 
Jeevakanth SP. 



JL Jens Lange September 30, 2021 07:11 AM UTC

Hi  Jeevakanth SP. , 


thank you for your reply. I'm happy to give you some further details. 


I created a minimal working example by following the syncfusion documentation using your demo code. I further added excel like filtering as documented here. The code for the demo page is as follows:

@page "/test"

@using Syncfusion.Blazor.Grids

<div class="container-fs">

    <div class="row m-0 p-0 max-height-fixed">

        <div class="col m-0 p-0">

            <SfGrid DataSource="@Orders" AllowPaging="true" AllowSorting="true" AllowFiltering="true">

                <GridPageSettings PageSize="5"></GridPageSettings>

                <GridFilterSettings Type="Syncfusion.Blazor.Grids.FilterType.Excel"></GridFilterSettings>

                <GridColumns>

                    <GridColumn Field=@nameof(Order.OrderID) HeaderText="Order ID" TextAlign="TextAlign.Right" Width="120"></GridColumn>

                    <GridColumn Field=@nameof(Order.CustomerID) HeaderText="Customer Name" Width="150"></GridColumn>

                    <GridColumn Field=@nameof(Order.OrderDate) HeaderText=" Order Date" Format="d" Type="ColumnType.Date" TextAlign="TextAlign.Right" Width="130"></GridColumn>

                    <GridColumn Field=@nameof(Order.Freight) HeaderText="Freight" Format="C2" TextAlign="TextAlign.Right" Width="120"></GridColumn>

                </GridColumns>

            </SfGrid>

        </div>

    </div>

</div>

@code{

    public List<Order>

    Orders

    { get; set; }

    protected override void OnInitialized()

    {

        Orders = Enumerable.Range(1, 75).Select(x => new Order()

        {

            OrderID = 1000 + x,

            CustomerID = (new string[] { "ALFKI", "ANANTR", "ANTON", "BLONP", "BOLID" })[new Random().Next(5)],

            Freight = 2.1 * x,

            OrderDate = DateTime.Now.AddDays(-x),

        }).ToList();

    }

    public class Order

    {

        public int? OrderID { get; set; }

        public string CustomerID { get; set; }

        public DateTime? OrderDate { get; set; }

        public double? Freight { get; set; }

    }

}


Furthermore, I added the css classes as mentioned in my original post in the "site.css"


.container-fs {

    width: 100%;

    max-width: 1880px;

    padding-right: 10px;

    padding-left: 10px;

    margin-right: auto;

    margin-left: auto;

}

.max-height-fixed {

    height: 200px; /*Changed to 200 instead of 700 for demo*/

    overflow-y: auto;

}


Then I opened the demo page on my 2560 x 1440 monitor. The result was that the container had a size of 1880x200 and the main body had a width of 2310px (see screenshots below). Opening the filter of the "Freight" column and then hovering on the number filter, resulted in the over flow. If you need any further information please let me know! 

Best regards, 

Jens


container_small.png


main_small.png


overflow_small.png



JP Jeevakanth Palaniappan Syncfusion Team October 1, 2021 11:44 AM UTC

Hi Jens, 

Thanks for sharing the details. 

We are currently validating the reported problem from our end and so we will update the further details in two business days(on or before October 5, 2021). Until then we appreciate your patience. 

Regards, 
Jeevakanth SP. 



JL Jens Lange October 8, 2021 04:42 AM UTC

Hey Jeevakanth, 

any udpates yet? 


Best regards



JP Jeevakanth Palaniappan Syncfusion Team October 11, 2021 09:55 AM UTC

Hi Jens, 

Sorry for the delay in getting back to you. 

We have further validated the reported problem and found that it is reproducing only due to the customized styles. If we remove the below highlighted styles then it is not reproduced.  


   .max-height-fixed { 
        height: 200px; /*Changed to 200 instead of 700 for demo*/ 
        overflow-y: auto; 
    } 

So to proceed further, could you please let us know the reason/your requirement to set the above styles? 

Please find the validated sample below for your reference. 


Regards, 
Jeevakanth SP. 
 



JL Jens Lange October 12, 2021 06:34 AM UTC

Hey  Jeevakanth, 


thanks for the reply. 

I'm trying to combine scrolling with paging. The problem is, that leads to the undesired behaviour that the grid has an empty space, when not enough rows are displaced. 

What I want is give the a max-height to which it can expand. If the rows do not need that space, the footer moves up.

Problem:
grid_flaw.PNG



JP Jeevakanth Palaniappan Syncfusion Team October 13, 2021 06:53 AM UTC

Hi Jens, 

Query : Remove Useless space 

We suspect that you have defined both Enablepaging and Height property in your grid. We suggest you to calculate the number of records based on the height specified in the grid by using the below documentation to resolve your problem. 

Get back to us if you have any other queries. 

Regards, 
Jeevakanth SP. 


Loader.
Up arrow icon