Allow bigger (1 MEEELLION rows) spreadsheets from reporter output

Bug #1351355 reported by Mike Rylander
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Wishlist
Unassigned

Bug Description

We've always used Spreadsheet::WriteExcel::Big to generate Excel output from reports. That module has a limitation of 64k rows, imposed by the binary Excel format. Recently, the Excel::Writer::XLSX module has become feature-complete enough that we can use that instead, and the XML format files that it writes are now supported by the majority of installed versions of Excel (and OpenOffice) -- the format arrived with Excel 2007, released in 2006 (8 years ago). So, let's switch to that!

Branch forthcoming...

Tags: pullrequest
Revision history for this message
Mike Rylander (mrylander) wrote :
tags: added: pullrequest
Revision history for this message
Ben Shum (bshum) wrote :

Based on discussions on IRC, I changed the makefile for ubuntu-trusty to use the package libexcel-writer-xlsx-perl. And then I added a release note. Pushed to master, thanks Mike! I think this feature will be well received by many report runners.

Changed in evergreen:
status: New → Fix Committed
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.