Hi Team,
We are using ignite grid and then we have exporting to excel functionality.
Case 1: When grid has 3 records:
Observation:
Browser Used – Internet Explorer (IE 11)
Result – On completion of exporting to excel, we get 3 options (Open/Save/Cancel). If user clicks on SAVE, file is saved in downloads folder.
Comment – Correct Behavior.
Case 2: When grid has 1787 records:
Browser User - Internet Explorer (IE 11)
Result – On completion of exporting to excel, if user click on SAVE button, file is saved in downloads folder but POPUP(asking to Open/Save/Cancel) is still in UI.
And if user clicks SAVE button for second time, file is downloaded again.
Comment – File is downloaded twice. Not a correct behavior.
Screenshots – I have attached a PDF file with this.ExportToExcelIssue.pdf
Can you please help on this issue?
Thanks
Hello,
Thank you for posting in our community.
I have created and attached a sample trying to reproduce your issue. On my side, everything works as expected. When the exporting is done the IE 11 dialog for saving the file is shown only once. If this is not an accurate demonstration of what you are trying to achieve please feel free to modify it and send it back to me.
Looking forward to hearing from you.
8358.Sample.zip
Hi,
Sample application is working fine and if we are using static data in our page then also its working fine but we are getting data from the database and then if we are exporting to excel, we are getting this issue .
We are using below code for export to excel in js file:
var exportingIndicator = $('<div>');
$('#exportButton').on('click', function () { var gridExcelExporter = new $.ig.GridExcelExporter(); var $grid = $('#csagrid'); gridExcelExporter.exportGrid($grid, { fileName: "CSAReport", gridStyling: "applied", columnsToSkip: ["ENTRY_DATE"] }, { exportStarting: function (e, args) { showExportingIndicator(args.grid, exportingIndicator); }, cellExported: function (e, args) { if (args.xlRow.index() == 0) { return; } i }, success: function () { hideExportingIndicator(exportingIndicator); }, }); });
function showExportingIndicator(grid, exportingIndicator) { var $gridContainer = $('#' + grid.attr('id') + '_container'); exportingIndicator.css({ "width": $gridContainer.outerWidth(), "height": $gridContainer.outerHeight() }).html('<span class="exporting-text">Exporting...</span>'); exportingIndicator.addClass("exporting-indicator"); $gridContainer.append(exportingIndicator);}
function hideExportingIndicator(exportingIndicator) { exportingIndicator.remove();}