xls importer needs to handle integer data
Bug #362014 reported by
Jason Straw
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
SchoolTool |
Fix Released
|
High
|
Gediminas Paulauskas |
Bug Description
spreadsheet programs hate making numbers into text (see below) and therefore xldr thinks they are numbers (and therefore floats). Given that 1200 != 1200.0 you get a KeyError on importing if your usernames are integers and you try to add them to a group.
17:57:44 < ignas> yes
17:58:03 < ignas> did not expect gnumeric and oocalc not handling the "This is
17:59:19 < ignas> ok
17:59:26 < ignas> excel does not do that properly too
17:59:41 < ignas> they seem over cautious about treating numbers as text
Changed in schooltool: | |
status: | Triaged → Fix Committed |
Changed in schooltool: | |
assignee: | Alan Elkner (aelkner) → Douglas Cerna (replaceafill) |
Changed in schooltool: | |
status: | New → Triaged |
Changed in schooltool: | |
status: | Triaged → Fix Released |
status: | Fix Released → Triaged |
Changed in schooltool: | |
status: | Fix Committed → Triaged |
assignee: | Douglas Cerna (replaceafill) → Gediminas Paulauskas (menesis) |
Changed in schooltool: | |
status: | Triaged → In Progress |
Changed in schooltool: | |
status: | In Progress → Fix Committed |
Changed in schooltool: | |
milestone: | next → 1.9.3 |
To post a comment you must log in.
Probably the best thing is profuse warnings on the import form and the spreadsheet itself.