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

Upgrade PHPSpreadSheet to 1.25.2

XMLWordPrintable

    • MOODLE_401_STABLE
    • MOODLE_401_STABLE
    • MDL-75484-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.
    • 2
    • Team Hedgehog 4.1 sprint 0 rev

      PhpSpreadsheet  (  lib/phpspreadsheet/ )    1.21.0  -->  1.25.2    :    https://github.com/PHPOffice/PhpSpreadsheet

        1. moodletest_withoutpatch.xlsx
          12 kB
          Huong Nguyen
        2. moodletest_withoutpatch.ods
          6 kB
          Huong Nguyen
        3. MDL-75484_test 2.png
          103 kB
          Angelia Dela Cruz
        4. MDL-75484_test 1_xlsx.webm
          979 kB
          Angelia Dela Cruz
        5. MDL-75484_test 1_ods.webm
          1.58 MB
          Angelia Dela Cruz

            david.woloszyn@moodle.com David Woloszyn
            sarjona Sara Arjona (@sarjona)
            Huong Nguyen Huong Nguyen
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Angelia Dela Cruz Angelia Dela Cruz
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 5 hours Original Estimate - 5 hours
                5h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 6 hours, 20 minutes
                6h 20m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.