[SAK-43678] Assignments: Incorrect order in name column when downloading spreadsheet [XLSX] - Sakai

XML

Word

Printable

Test Plan:

Hide

1. As an instructor, log into a site with users with accents in their names

2. Go to Assignments

3. Go to Grade Report and then "Download Spreadsheet [XLSX]"

4. Ensure the order of the names in the spreadsheet's name column takes accents into account, as described in the description below.

Show
1. As an instructor, log into a site with users with accents in their names 2. Go to Assignments 3. Go to Grade Report and then "Download Spreadsheet [XLSX] " 4. Ensure the order of the names in the spreadsheet's name column takes accents into account, as described in the description below.

In a assignment, when download spreadsheet [XLSX], order of name column is not correct when name contains accents.

Example incorrect order:

Martin xxx, yyy

Martí zzz, www
Martínez iiiii, jjjjj

Example correct order:

Martí zzz, www
Martin xxx, yyy
Martínez iiiii, jjjjj

relates to

SAK-38526 Resources sorting is case-sensitive and doesn't respect international characters sorting

SAK-18301 student names in Assignment Download All csv file are not ordered