Displaced cells in Excel when exporting tests with random questions

Description

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.

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

Priority

Fix versions

Assignee

Reporter

Created November 13, 2024 at 11:04 AM
Updated December 26, 2024 at 10:35 AM
Resolved November 15, 2024 at 2:24 PM

Flag notifications