Export to Excel does not export all SfGrid rows

[Oleg]

Given:

    <SfGrid @ref="grid"

            ID="grid_acct_authmer"

            TValue="MerchantAuthorizeModel"

            AllowExcelExport="true"

            AllowSorting="true"

            AllowFiltering="true"

            AllowMultiSorting="true"

            AllowReordering="true"

            AllowSelection="true"

            AllowGrouping="false"

            AllowResizing="true"

            AllowTextWrap="false"

            Height="580"

            EnableVirtualization="true">

define excel export function as:

  async Task ExportExcelClick()

  {

      if (Account != null)

      {

          var fname = "test.xlsx";

          var props = new ExcelExportProperties();

          props.DataSource = DataSource; // DataSource has 200 items

          props.FileName = fname;

          await grid.ExcelExport(props); // this will export only 1 visible page -- about 31 items

      }

  }

the export file will have only one page of data.

Another variation of the export function also does not export all rows:

  void ExportExcelClick()

  {

      var props = new ExcelExportProperties();

      props.ExportType = ExportType.AllPages;

      Task.FromResult(grid.ExcelExport(props)); // exports only one page

  }

-------------

What am I missing to export ALL datagrid rows?

[Jeevakanth Palaniappan]

Hi Oleg, 

Greetings from Syncfusion support. 

We have validated your query and we are able to reproduce the reported issue at our end. So we have considered it as a bug and logged the defect report “Unable to export all the records when virtualization is enabled” for the same. 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 upcoming patch release which is expected to be rolled out by the end of November 2020. 

    

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/18920/unable-to-export-all-records-when-virtualization-is-enabled  

Until then we appreciate your patience. 

Regards, 

Jeevakanth SP

[Younus Mahmood]

Hi, is there any update to this? Running into this on react where it only exports loaded rows and not all the data

"@syncfusion/ej2-base": "^22.1.38",

"@syncfusion/ej2-react-pivotview": "^22.1.39",

[Monisha Saravanan]

Hi Younus,

We have prepared a sample of Virtualization with 10k records and while exporting the Grid to Excel it returns all the data in the Excel document. Please refer the below sample for additional information. Kindly get back to us with detailed information if you still face the reported issue at your end.

Sample: https://stackblitz.com/edit/react-jngpnm-qyregb?file=index.js,data.js