"Gradebook Export" fails when worksheet titles are too long
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
SchoolTool Gradebook |
Fix Released
|
Critical
|
Douglas Cerna | ||
2.1 |
Fix Released
|
High
|
Gediminas Paulauskas |
Bug Description
When attempting to use the "Gradebook Export" I receive the following error. It happens to any teacher trying to export their gradebook using this sheet I deployed. I suspect that it is happening because the Worksheet Titles are too long, but that length is basically a necessity in my case. I am wondering what the maximum length is for worksheet names?
Exception
Exception: invalid worksheet name u'Social and Emotional Development'
Traceback
File "/usr/lib/
result = publication.
File "/usr/lib/
return mapply(ob, request.
File "/usr/lib/
return debug_call(obj, args)
Extra information: <bound method WorksheetsExpor
File "/usr/lib/
return obj(*args)
File "/usr/lib/
self.
File "/usr/lib/
ws = wb.add_
File "/usr/lib/
raise Exception("invalid worksheet name %r" % sheetname)
summary: |
- "Gradebook Export" Fails for all teachers and sections + "Gradebook Export" fails when worksheet titles are too long |
Changed in schooltool.gradebook: | |
assignee: | nobody → Douglas Cerna (replaceafill) |
importance: | Undecided → Critical |
Changed in schooltool.gradebook: | |
milestone: | none → 2.2.0 |
Changed in schooltool.gradebook: | |
status: | Fix Committed → Fix Released |
xlwt (the library we use to generate the XLS) only allows 31 chars for the sheet name. We need a length check either in the export or in the forms.