Testing instructions copied from MDL-71720.

Verify lib version

1. Access to "Site administration / Development / Third party libraries".
2. Verify third-party lib versions for PHPSpreadsheet is 4.1.0.

Testing scenario 1

1. Login as admin
2. Go to http://yourmoodleurl/lib/tests/other/spreadsheettestpage.php and generate the Excel and ODS sample files.
3. Review the server error logs to make sure there are no notices there.
4. Open the Excel and ODS sample files in various office suites.
5. Expected Result: Check the content is displayed as expected (Font colours, headings etc.). You can download the ODS file and compare it with or download the Excel file without that patch. Alternatively, you can also compare to the [^moodletest_withoutpatch.ods] attached file (which was created without the patch).

Testing scenario 2

1. Login as admin.
2. Create a course with some enrolled students and one graded activity for some of them (at least).
3. Access to the course.
4. Go to Grades / Export / Excel spreadsheet
5. Click over the Download button
6. Expected Result: Check the file is downloaded and contains one row per user and, at least, the following columns:  "First name", "Surname", "ID number", "Institution", "Department", "Email address", "Course total", "Last downloaded from this course" and one column for each activity.

Code verified against automated checks.

Checked MDL-81664 using repository: https://github.com/andrewnicols/moodle.git

• main (0 errors / 0 warnings) [branch: MDL-81664-main | CI Job]

_{More information about this report}

Built on: Tue Mar 4 05:47:35 UTC 2025

Launching automatic jobs for branch MDL-81664-main

• https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/18386/ PHPUnit (sqlsrv)
• https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/62975/ Behat (NonJS - boost and classic)
• https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/62976/ Behat (Firefox - boost)
• https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/62977/ Behat (Firefox - classic)
• https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/62978/ App tests (stable app version)

Built on: Fri Feb 28 14:25:17 UTC 2025