Uploaded image for project: 'Contrib: Gradebook2'
  1. Contrib: Gradebook2
  2. GRBK-408

Add .xlsx support to spreadsheet export/import

    Details

    • Type: Feature Request Feature Request
    • Status: 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.

        Gliffy Diagrams

          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: