3346552 - Export to Spreadsheet: Duplicated/missing rows due to incorrect server-side paging

This KBA is only suitable for server-side paging ($skiptoken). And the issue cannot be avoid if Client-Side Pagination ($top, $skip) is used.

Exported excel from list report contains duplicated and missing rows. And in the payloads of OData batch requests from http trace, you can see parameters like below:

request 1: &$skip=0&$top=10000

request 2: &$top=5000&$skiptoken=5000

request 3: &$skip=10000&$top=10000

request 4: &$top=5000&$skiptoken=5000

request 5: &$skip=20000&$top=10000

request 6: &$top=5000&$skiptoken=5000

…

SAP S/4HANA

paging size, __NEXT URL, Export to Spreadsheet , KBA , OPU-GW-COR , Framework , Problem