Hi Paul,
Query: it appears to sort by capital letters first followed by
lower case.
For Grid:
Based on your query, we understand that
you are facing issues with the grid sorting by capital letters first followed
by lower case letters. To avoid this issue, we suggest you set enableLocalizedSort API
as ‘true’
And we have already discussed a same for
this in our Knowledge Base documentation. Please refer to the below KB
documentation, it will help you to enable non-case-sensitive grid sorting.
Please refer to the below KB
documentation,
https://www.syncfusion.com/kb/2978/how-to-enable-non-case-sensitive-grid-sorting
For Pivot Grid:
We are currently validating this issue using Pivot Grid,
and we will update you shortly with the solution.
Regards,
Pon selva