Grid Excel filtering in IE11

Sue W

Asked On February 21, 2019 09:47 AM UTC

Hi,

I am evaluating your grid control. We have a requirement for a grid with Excel filtering but need it to work in IE 11.

Looking at your demo site, all the grid filtering works in IE11 except for the Excel filtering where the drop down menu containing the Equal, Not Equal etc options becomes detached from the initial filter drop downand can't be used when you select e.g Text Filters from the initial drop down.

This drop down then stays on the screen even after the initial drop down is closed.

It works in Chrome, but we need it to work in IE11.

You state that the controls work in IE 11. Is there something that needs to be done to get it to work?

I have attached some screen shots.

Thanks

Sue

Attachment: Screenshots_9c959c57.7z

Reply | Reply with quote

Thavasianand Sankaranarayanan [Syncfusion]

Replied On February 22, 2019 10:13 AM UTC

Hi Sue,

Greetings from Syncfusion.

Based on your query we suspect that you want to show the row numbers in Grid. We can achieve your requirement using the queryCellInfo event of Grid.

Refer the below code example.

@Html.EJS().Grid("FlatGrid").DataSource((IEnumerable<object>)ViewBag.dataSource).QueryCellInfo("querycellinfo").Columns(col =>

{

col.HeaderText("Row Numer").Width("90").Add();

col.Field("EmployeeID").HeaderText("Employee ID").IsPrimaryKey(true).Width("120").Add();

col.Field("CustomerID").HeaderText("Customer Name").Width("150").Add();

col.Field("OrderDate").HeaderText("Order Date").Type("date").Width("110").Add();

col.Field("Freight").HeaderText("Freight").EditType("numericedit").Width("120").Add();

col.Field("ShipCountry").HeaderText("Ship Country").Width("150").Add();

}).AllowPaging().Render()

var count = 1;

function querycellinfo(args) {

if (args.column.headerText == "Row Numer") {

args.cell.innerHTML = count;

count++;

}

</script>

Refer the below screen shot.

Please let us know if you need further assistance on this.

Regards,

Thavasianand S.

Reply | Reply with quote

Sue W

Replied On February 22, 2019 10:29 AM UTC

Thanks for your reply.

However, you appear to have replied to a different question to that which was asked.

My question was about Excel filtering not working in IE11.

Have you put your response in the wrong thread?

If you could reply to my original query that would be great.

Thanks

Sue

Reply | Reply with quote

Thavasianand Sankaranarayanan [Syncfusion]

Replied On February 22, 2019 10:44 AM UTC

Hi Sue,

Sorry for the wrong update and we will update you the detail regarding your mentioned query shortly.

Regards,

Thavasianand S.

Reply | Reply with quote

Sue W

Replied On March 1, 2019 01:14 PM UTC

Hi,

It's been a week now and I'm still waiting for a response to my question.

We need to make a decision on the grid we are going to use soon and until we have an answer we are not doing any further evaluation of this grid and so it has been removed from our shortlist.

If you could respond to my original question that would be great and we may be able to add it to our list again.

Thanks

Sue

Reply | Reply with quote

Thavasianand Sankaranarayanan [Syncfusion]

Replied On March 4, 2019 10:45 AM UTC

Hi Sue,

Sorry for the inconvenience caused.

Query #1: This drop down then stays on the screen even after the initial drop down is closed.

We have already fixed this issue which was released a couple of weeks ago in the release version v16.4.54, so we suggest to check the updated version or the below provided sample for your reference.

Sample: https://stackblitz.com/edit/angular-af89iy-inxkd1?file=filter-menu.component.ts

Query #2: the drop down menu containing the Equal, Not Equal etc options becomes detached from the initial filter drop down

We have validated the defect you have initiated with us. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and including the defect fix in our subsequent patch release on Mar 20, 2019. If you wish to receive this fix in a specific prior release product version please contact Syncfusion Support (backwards compatibility subject to technological feasibility and our Support SLA) You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link https://www.syncfusion.com/feedback/5044/grid-excel-filter-sub-menutext-filter-is-misaligned-in-ie11-browser .

Regards,

Thavasianand S.

Reply | Reply with quote

Sue W

Replied On March 4, 2019 03:33 PM UTC

Thanks for the reply. I will await an update on the bug fix.

Sue

Reply | Reply with quote

Thavasianand Sankaranarayanan [Syncfusion]

Replied On March 5, 2019 04:15 AM UTC

Hi Sue,

Thanks for your update.

We will update the patch release details once it get released on March 20^th, 2019.

Regards,

Thavasianand S.

Reply | Reply with quote

Thavasianand Sankaranarayanan [Syncfusion]

Replied On April 2, 2019 12:27 PM UTC

Hi Sue,

We are glad to announce that our Essential Studio 2019 Volume 1 Release v17-1-0-38 is rolled out and is available for download under the following link.

https://www.syncfusion.com/forums/143619/essential-studio-2019-volume-1-release-v17-1-0-38-is-available-for-download

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.

Regards

Thavasianand S.

Reply | Reply with quote

Thread ID:	Created:	Updated:	Platform:	Replies:
142833	Feb 21,2019 09:47 AM UTC	Apr 2,2019 12:27 PM UTC	Angular - EJ 2	8

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US