Contrib: Gradebook2
  1. Contrib: Gradebook2
  2. GRBK-408

Add .xlsx support to spreadsheet export/import

    Details

    • Type: Feature Request Feature Request
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.6.0-rc1, 1.6.0
    • Component/s: Services
    • Labels:
      None
    • Target Version:
    • QA Status:
      PASS
    • Previous Issue Keys:

      Description

      Since Apache POI has released 3.5-FINAL which includes support for .xlsx, this JIRA is to implement reading in .xlsx files and exporting them.

      From reading the notes, 3.5 has a new generic API which should allow for both XLS97 and OOXML, so hopefully this just means changing some packages and minor adjustments.

        Issue Links

          Activity

          Hide
          David L. Woods added a comment -
          created GRBK-1086 to document tab name error in .xlsx file creation.
          Show
          David L. Woods added a comment - created GRBK-1086 to document tab name error in .xlsx file creation.
          Hide
          David L. Woods added a comment -
          That leaves the problem of not including the structure when 'Export' => 'Grades & Structure' => '.xlsx' is chosen. It looks like the 'Grades Only' code is being invoked instead.

          Still:

          QA Fail
          Show
          David L. Woods added a comment - That leaves the problem of not including the structure when 'Export' => 'Grades & Structure' => '.xlsx' is chosen. It looks like the 'Grades Only' code is being invoked instead. Still: QA Fail
          Hide
          Jon Gorrono added a comment -
          that's not been tagged yet (rc3)
          Show
          Jon Gorrono added a comment - that's not been tagged yet (rc3)
          Hide
          Thomas Amsler added a comment -
          I will deploy this in the morning of August 2, 2011 as part of gradebook2 1.6.0-rc1
          Show
          Thomas Amsler added a comment - I will deploy this in the morning of August 2, 2011 as part of gradebook2 1.6.0-rc1
          Hide
          David L. Woods added a comment -
          QA Test

          exported from all combinations of gradebook style and mode, as both "grades only" and "grades & structure". All appeared to export properly, including the structure for all for "grades & structure" and excluding the structure for all for "grades only".

          QA Pass
          Show
          David L. Woods added a comment - QA Test exported from all combinations of gradebook style and mode, as both "grades only" and "grades & structure". All appeared to export properly, including the structure for all for "grades & structure" and excluding the structure for all for "grades only". QA Pass

            People

            • Assignee:
              Jon Gorrono
              Reporter:
              Michael Wenk
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: