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

Quiz Statistics Excel export file is corrupted

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 3.5.13
    • Quiz
    • None
    • MOODLE_35_STABLE

      Hello,

      If you download Quiz statistics report as .xlxs-file when there is submissions in the quiz Excel says the file is corrupted.

      Tried with local installation of Excel 2010 and online o365 Excel.

      Tested with Moodle Moodle 3.5.13+ (Build: 20200729)

      Steps to repeat:

      1. Create a quiz
      2. Create one true/false question (dog is an animal)
      3. As a teacher/manager or administrator open quiz -> statistics
      4. Under "Quiz information"-topic "Download full report as" and "Microsoft XLS(.xlxs)"
      5. Press download
      6. Open the file in Excel and notice how everything works
      7. Answer as a student to the quiz
      8. Repeat the process as teacher and notice how Excel claim that file is corrupt.

        1. corrupt.PNG
          16 kB
          Jari Vilkman
        2. corrupt2.PNG
          64 kB
          Jari Vilkman
        3. moodletukitesti-quiz 10.8-completestats (1).xlsx
          4 kB
          Jari Vilkman
        4. img-2022-03-16-11-47-02.png
          19 kB
          Lev Zadumkin

            timhunt Tim Hunt
            urpokarhu Jari Vilkman
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

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