Home

Notes about sorting (NRC template)

Excel functions like LOOKUP require rows to be sorted in a specific order to function correctly. Therefore, Bulk Load must sort rows (e.g., in the metadata sheet) according to the same sorting policy. While typical JavaScript or Lodash sorting uses ASCII order, which differs from the sorting order in Excel or LibreOffice, we have not yet implemented any special handling.

ASCII sorting is generally sufficient, but this discrepancy may cause issues with certain dataElement or categoryOption names, and we'll monitor for any problems.

Demo: test-sorting.xlsx