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

Quiz grade report export to excel/ods doesn't work on quizes with quotes in name

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 3.4.1
    • Quiz
    • None
    • MOODLE_34_STABLE

      When quiz name contains quotes, xlsx/ods files, downloaded from grade report are invalid.

       

      Steps to reproduce:

      1. Create quiz with name <test with "quotes">.
      2. Make some attempts for it as student.
      3. Go to results -> grades and download report as excel or opendocument.
      4. Downloaded file is invalid.

       

      If you unzip ods file in content.xml  line 9 you can see something like this:

      </style:style></office:automatic-styles><office:body><office:spreadsheet><table:table table:style-name="ta1" table:name="TSTCRS test with "quotes""><table:table-column table:default-cell-style-name="ce1" ...

      table:name (sheet title?) tag isn't escaped.

            timhunt Tim Hunt
            ivan.viktorov Ivan Viktorov
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

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