I have an arrayCollection, I am adding different items during my app but I use one numeric field to sort the array.
When I display the data in my datagrid, the data shows in the correct sort order.
I am using an API to export data to excel, right before I use the API the arrayCollection is in the right order but when I use in the API the data is not in the sort order. The data shows in order at the sequence of adding the records.
How can I make the sort permanent, even after use any API tool?