Edit exported file and enter letter grades using the spacebar to terminate typing of a letter grade (needed to cancel autocompletion in excel) - the grades are not allowed on input.

Description

When typing grades into a csv or xls or xlsx file, and using a space following a typed grade (e.g. to cancel excel autocompletion) the resulting saved gradefile evidently includes the space in the value uploaded. The gradebook import code does not trim trailing (leading?) blanks so it doesn't recognize that a "b " is the same as a "B" or a "b".

Environment

firefox and chrome WinXP Weighted Category/Letter Grades

Attachments

1

Activity

Show:

David Woods November 9, 2012 at 4:48 PM

QA Test

tested grades with leading and trailing spaces, with and without +/- characters.

All were excepted correctly.

QA Pass

Thomas Amsler November 8, 2012 at 4:16 PM

Jon Gorrono May 22, 2012 at 6:11 PM

added trim to all imported grades and stored trimmed value as original grade

resolving

Fixed

Details

Assignee

Reporter

QA Status

PASS

Components

Fix versions

Affects versions

Priority

Created May 22, 2012 at 4:19 PM
Updated November 15, 2012 at 2:15 PM
Resolved May 22, 2012 at 6:11 PM