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

Quiz Statistics report export to Excel (xlsx) and OpenOffice (ods) failing

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 3.1.12, 3.2.9, 3.3.6, 3.4.3, 3.5, 3.6.6
    • Quiz
    • MOODLE_31_STABLE, MOODLE_32_STABLE, MOODLE_33_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE, MOODLE_36_STABLE
    • Hide

      As a work-around, use https://docs.moodle.org/35/en/Language_customisation to edit the following strings in the quiz_statistics lang file: analysisnovariant, analysisno, analysisvariant, analysisnameonly.

      REmove the " characters from those strings.

      Show
      As a work-around, use https://docs.moodle.org/35/en/Language_customisation to edit the following strings in the quiz_statistics lang file: analysisnovariant, analysisno, analysisvariant, analysisnameonly. REmove the " characters from those strings.

      In Moodle 3.1 and higher we see a strange error when exporting a Quiz Statistics Report to Excel (xlsx) or OpenOffice (ods).

      The multitable spreadsheet to be generated seems to break when the worksheets for the individual questions in the quiz are generated, as can be seen in the attached screenshot of the workbook.xml file we extracted from the exported spreadsheet:

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
      <workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
      {{ {{ <sheets>}}}}
      {{ {{ <sheet name="Testinformatie" sheetId="1" r:id="rIdSheet1"/>}}}}
      {{ {{ <sheet name="Analyse teststructuur" sheetId="2" r:id="rIdSheet2"/>}}}}
      {{ {{ <sheet name=""PE.01a"" sheetId="3" r:id="rIdSheet3"/>}}}}
      {{ {{ <sheet name=""PE.03"" sheetId="4" r:id="rIdSheet4"/>}}}}
      {{ {{ <sheet name=""PE.04"" sheetId="5" r:id="rIdSheet5"/>}}}}
      {{ {{ <sheet name=""PE.05"" sheetId="6" r:id="rIdSheet6"/>}}}}
      {{ {{ <sheet name=""PE.06"" sheetId="7" r:id="rIdSheet7"/>}}}}
      {{ {{ <sheet name=""PE.07"" sheetId="8" r:id="rIdSheet8"/>}}}}
      {{ {{ <sheet name=""PE.08"" sheetId="9" r:id="rIdSheet9"/>}}}}
      {{ {{ <sheet name=""PE.09"" sheetId="10" r:id="rIdSheet10"/>}}}}
      {{ {{ <sheet name=""PE.10"" sheetId="11" r:id="rIdSheet11"/>}}}}
      {{ {{ <sheet name=""PE.11"" sheetId="12" r:id="rIdSheet12"/>}}}}
      {{ {{ <sheet name=""PE.12"" sheetId="13" r:id="rIdSheet13"/>}}}}
      {{ {{ <sheet name=""PE.13"" sheetId="14" r:id="rIdSheet14"/>}}}}
      {{ {{ <sheet name=""PE.14"" sheetId="15" r:id="rIdSheet15"/>}}}}
      {{ {{ <sheet name=""PE.15"" sheetId="16" r:id="rIdSheet16"/>}}}}
      {{ {{ <sheet name=""PE.16"" sheetId="17" r:id="rIdSheet17"/>}}}}
      {{ {{ <sheet name=""PE.17"" sheetId="18" r:id="rIdSheet18"/>}}}}
      {{ {{ <sheet name=""PE.18"" sheetId="19" r:id="rIdSheet19"/>}}}}
      {{ {{ <sheet name=""PE.19"" sheetId="20" r:id="rIdSheet20"/>}}}}
      {{ {{ <sheet name=""PE.20"" sheetId="21" r:id="rIdSheet21"/>}}}}
      {{ {{ <sheet name=""PE.21"" sheetId="22" r:id="rIdSheet22"/>}}}}
      {{ {{ <sheet name=""PE.22"" sheetId="23" r:id="rIdSheet23"/>}}}}
      {{ {{ <sheet name=""PE.23"" sheetId="24" r:id="rIdSheet24"/>}}}}
      {{ {{ <sheet name=""PE.24"" sheetId="25" r:id="rIdSheet25"/>}}}}
      {{ {{ <sheet name=""PE.25"" sheetId="26" r:id="rIdSheet26"/>}}}}
      {{ {{ <sheet name=""PE.26"" sheetId="27" r:id="rIdSheet27"/>}}}}
      {{ {{ <sheet name=""PE.27"" sheetId="28" r:id="rIdSheet28"/>}}}}
      {{ {{ <sheet name=""PE.28"" sheetId="29" r:id="rIdSheet29"/>}}}}
      {{ {{ <sheet name=""PE.29"" sheetId="30" r:id="rIdSheet30"/>}}}}
      {{ {{ <sheet name=""PE.30"" sheetId="31" r:id="rIdSheet31"/>}}}}
      {{ {{ <sheet name=""PE.31"" sheetId="32" r:id="rIdSheet32"/>}}}}
      {{ {{ <sheet name=""PE.32"" sheetId="33" r:id="rIdSheet33"/>}}}}
      {{ {{ <sheet name=""PE.33"" sheetId="34" r:id="rIdSheet34"/>}}}}
      {{ {{ <sheet name=""PE.34"" sheetId="35" r:id="rIdSheet35"/>}}}}
      {{ {{ <sheet name=""PE.35"" sheetId="36" r:id="rIdSheet36"/>}}}}
      {{ {{ <sheet name=""PE.02"" sheetId="37" r:id="rIdSheet37"/>}}}}
      {{ {{ </sheets>}}}}
      </workbook>

      Please note the double double quotation marks for the name attribute. 

      To reproduce:

      • Create a quiz with a number of multiple choice questions
      • Generate some attempts to provide the statistics report with data
      • Go to Quiz > Results > Statistics and download the report as Excel (xslx) file
      • Open the file => An error notification stating that something went wrong and recovery should be attempted occurs
      • Extract the xml from the Excel file and check in the workbook.xml file whether the quotation marks for the name attribute are generated as can be seen in the example.

            Unassigned Unassigned
            jwelshoff Joost Elshoff
            Votes:
            4 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:

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