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

Replace PHPExcel with PHPSpreadsheet

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.8
    • Fix Version/s: 3.8
    • Component/s: Libraries
    • Labels:
    • Testing Instructions:
      Hide

      Testing scenario 1

      1. Login as admin
      2. Go to http://yourmoodleurl/lib/tests/other/spreadsheettestpage.php and generate the Excel sample file.
      3. Review the server error logs to make sure there are no notices there.
      4. Open the Excel sample file in various office suites.
      5. CHECK the content is displayed as expected. You can download the ODS file and compare with it or download the Excel file without that patch. Alternatively, you can also compare to the moodletest_withoutthepatch.xlsx 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 Participants.
      5. Select all users and in the "With selected users" list choose "Download table data as Microsoft Excel (.xslx)".
      6. CHECK the file is downloaded and contains one row per user and, at least, the following columns:  "First name", "Surname" and "Email address".
      7. Go to Grades / Export / Excel spreadsheet
      8. Click over the Download button
      9. 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 sample file. Review the server error logs to make sure there are no notices there. Open the Excel sample file in various office suites. CHECK the content is displayed as expected. You can download the ODS file and compare with it or download the Excel file without that patch. Alternatively, you can also compare to the moodletest_withoutthepatch.xlsx  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 Participants. Select all users and in the "With selected users" list choose "Download table data as Microsoft Excel (.xslx)". CHECK the file is downloaded and contains one row per user and, at least, the following columns:  "First name", "Surname" and "Email address". Go to Grades / Export / Excel spreadsheet Click over the Download button 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.
    • Affected Branches:
      MOODLE_38_STABLE
    • Fixed Branches:
      MOODLE_38_STABLE
    • Epic Link:
    • Pull from Repository:
    • Pull Master Branch:
      MDL-65741-master
    • Story Points:
      3
    • Sprint:
      Moppies Moodle 3.8 Sprint 1, Moppies Moodle 3.8 Sprint 2

      Attachments

      1. MDL-65741.jpg
        MDL-65741.jpg
        50 kB
      2. MDL-65741 (2).jpg
        MDL-65741 (2).jpg
        103 kB
      3. moodletest_withoutthepatch.xlsx
        12 kB

        Issue Links

          Activity

            People

            Assignee:
            sarjona Sara Arjona (@sarjona)
            Reporter:
            dobedobedoh Andrew Nicols
            Peer reviewer:
            Bas Brands
            Integrator:
            Andrew Nicols
            Tester:
            Anna Carissa Sadia
            Participants:
            Component watchers:
            Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              18/Nov/19

                Time Tracking

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