Assignments: Submission export breaks on big data set

Description

When exporting submissions to an excel file on a site with a lot of student’s and/or assignments an empty file will be exported. The critical amount of data is a bit below 10.000 rows - (64000 styled cells). The issue happens due to an illegal number of style definitions on the excel file, due to the same style being created for each cell - the style is created and added to the style while looping through the entries. A proposed solution would be to move the creation of the style out of the loops and only add it to the cell within the loop. This should also improve performance on smaller data sets where the the download does not “blow up”.

The sakai property timesheet.sites.allowed=all should be set to be able to use the download on Assignments by students.
Details:

Activity

Show:

Automation for Jira April 25, 2024 at 11:54 AM

A pull request has been created, "SAK-49987 Assignments: Submission export breaks on big data set", you can see it at https://github.com/sakaiproject/sakai/pull/12544

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Created April 22, 2024 at 10:21 AM
Updated April 26, 2024 at 5:19 PM
Resolved April 26, 2024 at 5:19 PM