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

Excel export still sometimes generates an invalid sheet names

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.8.9, 2.9.3
    • 2.9
    • Quiz
    • MOODLE_29_STABLE
    • MOODLE_28_STABLE, MOODLE_29_STABLE
    • Hide
      1. Create a quiz with one true-false question.
      2. Attempt the quiz as two different students
      3. Set your Moodle (or just that course) to German.
      4. Go to Quiz -> Results -> Statistics, and choose to export the entire report at Excel format.
      5. Very that the export file is written with no errors. (Since it is a binary file download, you probably need to look for errors in the PHP logs.)
      Show
      Create a quiz with one true-false question. Attempt the quiz as two different students Set your Moodle (or just that course) to German. Go to Quiz -> Results -> Statistics, and choose to export the entire report at Excel format. Very that the export file is written with no errors. (Since it is a binary file download, you probably need to look for errors in the PHP logs.)

      Exporting statistics test results as an excel-file in german fails.

      Fehler: Invalid character found in sheet code name

      Weitere Informationen über diesen Fehler

      Debug info:
      Error code: generalexceptionmessage
      Stack trace:
      line 445 of /lib/phpexcel/PHPExcel/Worksheet.php: PHPExcel_Exception thrown
      line 2859 of /lib/phpexcel/PHPExcel/Worksheet.php: call to PHPExcel_Worksheet::_checkSheetCodeName()
      line 347 of /lib/phpexcel/PHPExcel/Worksheet.php: call to PHPExcel_Worksheet->setCodeName()
      line 172 of /lib/excellib.class.php: call to PHPExcel_Worksheet->__construct()
      line 77 of /lib/excellib.class.php: call to MoodleExcelWorksheet->__construct()
      line 1640 of /lib/tablelib.php: call to MoodleExcelWorkbook->add_worksheet()
      line 408 of /mod/quiz/report/statistics/report.php: call to table_spreadsheet_export_format_parent->start_table()
      line 807 of /mod/quiz/report/statistics/report.php: call to quiz_statistics_report->output_individual_question_response_analysis()
      line 194 of /mod/quiz/report/statistics/report.php: call to quiz_statistics_report->output_all_question_response_analysis()
      line 96 of /mod/quiz/report.php: call to quiz_statistics_report->display()

            timhunt Tim Hunt
            jlanz Jonas Lanz
            Rajesh Taneja Rajesh Taneja
            Dan Poltawski Dan Poltawski
            Simey Lameze Simey Lameze
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

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