Displaced cells in Excel when exporting tests with random questions
GENERAL
TESTING
GENERAL
TESTING
Description
Attachments
1
- 13 Nov 2024, 11:05 AM
Activity
Show:
Wasi Khan December 26, 2024 at 10:35 AM
Verified on trunk. All responses are correctly exported, and item analysis is correctly imported as well.
Server Information
Sakai Version: 25-SNAPSHOT
Server Time: Dec 26, 2024 5:34:54 AM EST
Server: ip-172-31-7-189
Build Info: daf88146
Automation for Jira November 14, 2024 at 9:50 AM
A pull request has been created, "SAK-50683 - Displaced cells in Excel exported from test with random q…", you can see it at https://github.com/sakaiproject/sakai/pull/13021
Fixed
Details
Details
Priority
Affects versions
Fix versions
Components
Assignee
Daniel Merino
Daniel MerinoReporter
Daniel Merino
Daniel MerinoCreated November 13, 2024 at 11:04 AM
Updated December 26, 2024 at 10:35 AM
Resolved November 15, 2024 at 2:24 PM
When a test is configured to use some number of random questions from a pool, the excel file exported from it has every question in the pool, filling the cells where each student has answered questions.
However, when one student hasn’t answered a question, the question text’s cell is filled with an hyphen, but the response’s cell is not filled and all the next cells are displaced one position to left, so response is filled with points, etc. Look the uploaded image for clarification.