Sorting is ignored when exporting from a DataGrid

[KremnevDmitry]

Environment

Jmix version: 2.3.999-SNAPSHOT

Bug Description

If you enable sorting on a DataGrid and then export, the data will not be sorted.
See related: #3316

Steps To Reproduce

1. Open an attached project
2. Open TestEntitiesListView
3. Sort by the number column
4. Export all rows

Current Behavior

Expected Behavior

UI:

Sample Project

test.zip

[gorbunkov]

Default all records exporting uses the "keyset" pagination strategy (records are always sorted by a primary key). So it ignores the sorting defined on the screen.

However, in Jmix 2.3, an additional "limit-offset" exporting strategy has been introduced. See the issue #3001.

If you set this new strategy, then sorting will be kept in the resulting excel file:

jmix.gridexport.export-all-pagination-strategy = limit-offset