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

Excel export still sometimes generates an invalid sheet names

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.9
    • Fix Version/s: 2.8.9, 2.9.3
    • Component/s: Quiz
    • Labels:
    • Testing Instructions:
      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.)
    • Affected Branches:
      MOODLE_29_STABLE
    • Fixed Branches:
      MOODLE_28_STABLE, MOODLE_29_STABLE
    • Pull from Repository:
    • Pull Master Branch:
    • Pull Master Diff URL:

      Description

      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()

        Attachments

          Issue Links

          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-36845 Export cloned quiz report not working properly in IE

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-52983 Excel export can still generates an invalid sheet names

          • Minor - Minor loss of function where workaround is possible
          • Closed

            Activity

              People

              Assignee:
              timhunt Tim Hunt
              Reporter:
              jlanz Jonas Lanz
              Peer reviewer:
              Rajesh Taneja Rajesh Taneja
              Integrator:
              Dan Poltawski Dan Poltawski
              Tester:
              Simey Lameze Simey Lameze
              Participants:
              Component watchers:
              Tim Hunt, Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                9/Nov/15