Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-37287 import latest 3rd party libs into 2.5dev META
  3. MDL-35356

Replace Excel_Writer with PHPExcel and improve ODS export

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.3.2
    • Fix Version/s: 2.5
    • Component/s: Libraries
    • Labels:
    • Testing Instructions:
      Hide

      1/ use http://127.0.0.1/lib/tests/other/spreadsheettestpage.php to generate the test files
      2/ open the files in various office suites (alternatively use the attached samples)
      3/ test existing excel/ods export in moodle
      4/ test it using different browsers (IE, FF, Safari, ignore Chrome, lol, not really).

      Show
      1/ use http://127.0.0.1/lib/tests/other/spreadsheettestpage.php to generate the test files 2/ open the files in various office suites (alternatively use the attached samples) 3/ test existing excel/ods export in moodle 4/ test it using different browsers (IE, FF, Safari, ignore Chrome, lol, not really).
    • Affected Branches:
      MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_25_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w51_MDL-35356_m25_excel
    • Pull Master Diff URL:

      Description

      The Excel_Writer library has been failing to produce reliable output for some time. We have been considering dropping Excel support altogether.

      However it may be worth considering a new alternative called PHPExcel.

        Attachments

        1. moodletest.ods
          6 kB
        2. moodletest.xls
          10 kB
        3. moodletest.xlsx
          12 kB

          Issue Links

          has been marked as being related by

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-28070 Review Excel writer package

          • Major - Major loss of function, incorrect output
          • Closed
          is duplicated by

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-37204 Look for a replacement for pear/excel library...

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

          Improvement - An enhancement to an existing Moodle feature. MDL-32259 reimplement CSV and Excel import/export support

          • Minor - Minor loss of function where workaround is possible
          • Closed
          will help resolve

          Improvement - An enhancement to an existing Moodle feature. MDL-40484 Implement Excel import for the gradebook

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

            Activity

              People

              Assignee:
              skodak Petr Skoda
              Reporter:
              salvetore Michael de Raadt
              Integrator:
              Eloy Lafuente (stronk7)
              Tester:
              David Monllaó
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona)
              Votes:
              5 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                14/May/13