View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
07922Bug reportsResponse browsingpublic2013-06-13 00:102013-07-08 13:50
Reporterwlodarczyk Assigned Tomdekker  
PriorityhighSeveritytweak 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07922: "Export results" suggests that unanswered multiple choice questions as having been answered
Description

When one "exports results" and opts to use "full answers", a multiple choice question that was skipped or otherwise not answered will show "No" for all of its options in those exported results, even though the question was not actually answered. This is confusing to individuals who review an export of results, as "No" implies that the question was answered and the respondent actively chose not to check those options, which is very different from a question being skipped, or not seen/answered at all. My expectation is that multiple choice questions which are not answered would show blanks in the exported results instead of "No". I only expect to see "No" where the question was actually answered (i.e. it was presented to the respondent and the respondent clicked "Next" or "Submit" to continue past it).

Steps To Reproduce
  1. Import the attached survey
  2. Activate the survey
  3. Take ("Test") the survey
  4. Answer question 1 with any answer
  5. Stop there. Do not answer question 2. Do not click the "submit" button
  6. Go to Lime Survey admin console
  7. Go to "Responses & statistics"
  8. Choose "Export results to application"
  9. Export using these settings:
  • General: All responses
  • Headings: Full question text
  • Responses: Full answers
  • Format: Microsoft Excel (all charsets)
  • Column control: Select all columns (the default)

In the Excel export that is generated, "No" is reported as the answer for all of the options for question 2, even though question 2 was not actually answered.

If one exports using "Answer codes" instead of "Full answers", the Excel export shows blanks for all question 2 options, which is as expected, since the question was not actually answered.

TagsNo tags attached.
Attached Files
limesurvey_survey_531154.lss (14,707 bytes)
Bug heat10
Complete LimeSurvey version number (& build)130129
I will donate to the project if issue is resolvedYes
Browser
Database type & versionMySQL 5
Server OS (if known)Debian Squeeze
Webserver software & version (if known)Apache 2
PHP Version5.3.3-7

Users monitoring this issue

DenisChenu, mfaber

Activities

mdekker

mdekker

2013-06-17 11:40

reporter   ~25565

It seems that when not answered due to relevance (the question was not presented) the database holds a null value, compared to empty string for presented but unchecked box. This case is not picked up correctly at the export class.
mdekker

mdekker

2013-06-17 11:41

reporter   ~25566

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=12610
mdekker

mdekker

2013-06-17 11:57

reporter   ~25568

Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=12612
mdekker

mdekker

2013-06-17 11:58

reporter   ~25569

Null values for the checkbox now get N/A instead of No
DenisChenu

DenisChenu

2013-06-17 12:15

developer   ~25571

mdekker : did this test is in for "text question" type too ?

Think it's the same:
If user don't get to the page OR question his hidden by relevance : database have NULL value.
If user don't answer : empty string.

Maybe have to check other question too for 2.05 ?
( Can take a part).

Did N/A is good for SPSS/R export too ?
mdekker

mdekker

2013-06-17 12:34

reporter   ~25573

I only changed the checkbox, but will have a look at handling null values in general for 2.05

I want to make spss/r use the same classes in 2.05 or 2.1 so no more exceptions in the way values are handled. Will keep it on my to do list.
c_schmitz

c_schmitz

2013-07-08 13:50

administrator   ~25726

2.00+ Build 130708 released.

Related Changesets

LimeSurvey: master d38a1af7

2013-06-17 09:41:36

mdekker

Details Diff 		fixed 07922: "Export results" suggests that unanswered multiple choice questions as having been answered Affected Issues
07922
mod - application/helpers/admin/exportresults_helper.php Diff File

LimeSurvey: 2.05 0a13815c

2013-06-17 09:41:36

mdekker

Details Diff 		fixed 07922: "Export results" suggests that unanswered multiple choice questions as having been answered Affected Issues
07922
mod - application/helpers/admin/export/SurveyObj.php Diff File

Issue History

Date Modified Username Field Change
2013-06-13 00:10 wlodarczyk New Issue
2013-06-13 00:10 wlodarczyk File Added: limesurvey_survey_531154.lss
2013-06-13 06:56 mfaber Issue Monitored: mfaber
2013-06-15 09:45 DenisChenu Issue Monitored: DenisChenu
2013-06-17 11:09 mdekker Assigned To => mdekker
2013-06-17 11:09 mdekker Status new => assigned
2013-06-17 11:40 mdekker Note Added: 25565
2013-06-17 11:41 mdekker Changeset attached => LimeSurvey master d38a1af7
2013-06-17 11:41 mdekker Note Added: 25566
2013-06-17 11:41 mdekker Resolution open => fixed
2013-06-17 11:57 mdekker Changeset attached => LimeSurvey 2.05 0a13815c
2013-06-17 11:57 mdekker Note Added: 25568
2013-06-17 11:58 mdekker Note Added: 25569
2013-06-17 11:58 mdekker Status assigned => resolved
2013-06-17 11:58 mdekker Fixed in Version => 2.00+
2013-06-17 12:15 DenisChenu Note Added: 25571
2013-06-17 12:34 mdekker Note Added: 25573
2013-07-08 13:50 c_schmitz Note Added: 25726
2013-07-08 13:50 c_schmitz Status resolved => closed
2021-08-05 10:01 guest Bug heat 6 => 10