| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 19477 | Bug reports | Import/Export | public | 2024-03-13 13:21 | 2024-03-18 17:10 |
| Reporter | YolandaJolly | Assigned To | DenisChenu | ||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | duplicate | ||
| Product Version | 6.4.x | ||||
| Summary | 19477: Error exporting questions of type YES/NO/No Answer to excel. | ||||
| Description | Exporting to Excel a survey with YES/NO questions (with the "No answer" option), if I select the options "Answer codes" , "Convert Y to 1" and "Convert N to 2", in Excel file the N/A answers is 2 like the NO answers. and there is no difference between negative answer and No answer. If I put "Convert N to 3", in the answer N/A also appear 3. | ||||
| Steps To Reproduce | Steps to reproduceSurvey with questions Yes/No (and "No answer option) Responses-> Export -> Export responses -> Microsoft Excel -> Answer codes, "Convert Y to 1" and "Convert N to 2" Expected resultAnswers "No answer", blank space in Excel file Actual resultAnswers "No answer", are 2: the same number that the NO answer. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | Version 6.4.5+240205 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | MySQL 8 | ||||
| Server OS (if known) | |||||
| Webserver software & version (if known) | |||||
| PHP Version | PHP 8.0.30 | ||||
- Anonymous
