When trying to export grades from an assignment using a marking guide or rubric, there are several issues with the downloaded .xlsx file:

• It includes entries for all non-students enrolled in the course;
• It does not include the overall feedback comments;
• When debugging is on, the downloaded xlsx file is corrupted and cannot be opened;
• When using 'No groups' from the course settings, the 'Groups' column on the spreadsheet is missing and all the following column headers are shifted by one to the left. The data below these headers is not shifted though and there is a mismatch between the column header and the actual value below it. The first 'Score' column displays the word 'empty' for all users and the 'Graded by' and 'Time graded' columns are empty as well.

Here are the steps to reproduce the bugs described above:

1. Log in as a teacher.
2. Create a new course;
3. From the course settings page, navigate to the Groups section and set the Group mode to Separate groups or Visible groups;
4. Enrol one student and one teacher in this course;
5. Create two assignment activities;
6. On the first assignment navigate to the Advanced grading tab and set the grading method to Rubric. Choose a rubric template or create a new one if there are none available to use;
7. On the second assignment navigate to the Advanced grading tab and set the grading method to Marking guide. Choose a rubric template or create a new one if there are none available to use;
8. Log in as the student and make a submission to both assignments;
9. Log back in as the teacher and grade both submissions made by the student (using the rubric for the former and marking guide for the latter);
10. Within the first assignment, download the grades spreadsheet by clicking the Export rubric grades tab;
11. The downloaded .xlsx file will include entries for both the student and the teacher (regardless if the assignment is anonymous or not). It should only list students;
12. The downloaded .xlsx file will not include the closing Feedback comments for the submission. It should include them;
13. Within the second assignment, download the grades spreadsheet by clicking the Export marking guide grades tab;
14. Notice the same observations from points 11 and 12 above;
15. Go back to the course settings page, navigate to the Groups section and set the Group mode to No groups;
16. Go back to the first assignment and download the grades spreadsheet by clicking the Export rubric grades tab;
17. The downloaded .xlsx file will be missing the Groups column header and all the following column headers will be shifted by one to the left. However, the data below these headers will not be shifted by one and there will be a mismatch between the column header and the actual value below it. The first 'Score' column will display the word 'empty' for all users and the 'Graded by' and 'Time graded' columns will be empty as well.
18. Go back to the second assignment and download the grades spreadsheet by clicking the Export marking guide grades tab;
19. Notice the same observation from point 17 above;
20. Turn debugging on in your site (eg set $CFG->debug = '1'; in the config.php file);
21. Go back to either of the above assignments and download the grades spreadsheet;
22. When trying to open the downloaded .xlsx file, the open will fail and the following pop-up will be displayed: "Excel cannot open the file '<filename>.xlsx'. because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."