Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-76922

Upgrade PHPSpreadSheet to 1.28.0

    XMLWordPrintable

Details

    • MOODLE_402_STABLE
    • MOODLE_402_STABLE
    • MDL-76922-master
    • Hide

      Testing scenario 1

      1. Login as admin
      2. Go to http://yourmoodleurl/lib/tests/other/spreadsheettestpage.php and generate the Excel and ODS sample file.
      3. Review the server error logs to make sure there are no notices there.
      4. Open the Excel and ODS sample file in various office suites.
      5. Expected Result: Check the content is displayed as expected (Font colors, 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 and use the tertiary nav to select 'Export'
      5. Click 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.
      Show
      Testing scenario 1 Login as admin Go to  http://yourmoodleurl/lib/tests/other/spreadsheettestpage.php and generate the Excel and ODS sample file. Review the server error logs to make sure there are no notices there. Open the Excel and ODS sample file in various office suites. Expected Result: Check the content is displayed as expected (Font colors, 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 Login as admin. Create a course with some enrolled students and one graded activity for some of them (at least). Access to the course. Go to Grades and use the tertiary nav to select 'Export' Click the Download button 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.
    • 1
    • HQ 2023 Sprint i1.2 Moppies

    Description

      PhpSpreadsheet    lib/phpspreadsheet/    1.25.2  -->  1.28.0    https://github.com/PHPOffice/PhpSpreadsheet

      Attachments

        Issue Links

          Activity

            People

              sarjona Sara Arjona (@sarjona)
              sarjona Sara Arjona (@sarjona)
              Carlos Escobedo Carlos Escobedo
              Andrew Lyons Andrew Lyons
              Kim Jared Lucas Kim Jared Lucas
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                24/Apr/23

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 8 minutes
                  2h 8m