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

Add .xlsx support to spreadsheet export/import

    Details

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

      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

          Attachments

            Issue Links

              Activity

              Hide
              davwoods David L. Woods added a comment -

              created GRBK-1086 to document tab name error in .xlsx file creation.

              Show
              davwoods David L. Woods added a comment - created GRBK-1086 to document tab name error in .xlsx file creation.
              Hide
              davwoods 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
              davwoods 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
              ccjon Jon Gorrono added a comment -

              that's not been tagged yet (rc3)

              Show
              ccjon Jon Gorrono added a comment - that's not been tagged yet (rc3)
              Hide
              tamsler 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
              tamsler 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
              davwoods 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
              davwoods 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:
                  ccjon Jon Gorrono
                  Reporter:
                  mjwenk@ucdavis.edu Michael Wenk
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: