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

Excel export does not work with >31 character worksheet names

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.7, 1.9.11, 2.0.2
    • Fix Version/s: 1.9.12, 2.0.3
    • Component/s: Libraries
    • Labels:
    • Affected Branches:
      MOODLE_19_STABLE, MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      In latin 1 mode, the PEAR library throws an error when a sheet name is longer than 31 chars.

      In Unicode mode, the PEAR libarary thinks that longer sheet names will work, but we are getting errors when we try to open those files in Excel.

      I propose to truncate all worksheet names to 31 chars max in excellib.

      I am about to check this change into OU Moodle. please review and decide if you want it in 1.9 and or HEAD.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  5/May/11