View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
07998Bug reportsImport/Exportpublic2013-10-09 18:05
Reporterlucass Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07998: Problem with exporting "Array (numbers)" subqestions to .xls
Description

When there is underscore "_" character in <b>subqestion code</b> of "Array (numerical)" question, the subquestion string is not exported to .xls file. Instead of string value of this subqestion, there are these signs in spreadsheet: []

Probably the issue is the same with other special characters.

Steps To Reproduce

Use attached survey. Enter response, and try to export results to .xls file with default settings. Check that in column E and G there are strings: "Question 1 [Some example subquestion][]", with "[]" at the end, instead of string.

TagsNo tags attached.
Attached Files
export problem.lsa (2,891 bytes)
lime.patch (408 bytes)   
--- exportresults_helper.php.old	2013-08-08 09:52:20.010015017 +0200
+++ exportresults_helper.php	2013-08-07 14:47:16.196474343 +0200
@@ -1099,6 +1099,8 @@
                 break;
 
             case ':':
+	      $subHeading .= ' ['.$this->stripTagsFull($field['subquestion1']).']['.$this->stripTagsFull($field['subquestion2']).']';
+	      break;
             case ';':
 		//print_r($field); echo "\n";
 		
lime.patch (408 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)130708
I will donate to the project if issue is resolvedNo
BrowserFirefox 22, Opera 12
Database type & versionMysql 5.5.31.0.1
Server OS (if known)Debian 7.0
Webserver software & version (if known)Apache/2.2.22
PHP Version5.4.4.14.7.2

Users monitoring this issue

mfaber, lucass

Activities

lucass

lucass

2013-09-03 15:06

reporter   ~26144

In file 'lime.patch' there is a patch which resolves this issue. Please check it and include in regular LS distribution.

c_schmitz

c_schmitz

2013-09-27 18:11

administrator   ~26405

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

c_schmitz

c_schmitz

2013-09-27 18:11

administrator   ~26406

Thank you!

c_schmitz

c_schmitz

2013-09-29 15:27

administrator   ~26423

Version 2.00+ Build 130929 released

c_schmitz

c_schmitz

2013-10-09 18:05

administrator   ~26677

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

Related Changesets

LimeSurvey: master afa7e188

2013-09-27 16:10:12

c_schmitz

Details Diff
Fixed issue 07998: Underscore character in subqestion code breaks export of Array (numerical) questions - patch by lucass Affected Issues
07998
mod - application/helpers/admin/exportresults_helper.php Diff File

LimeSurvey: 2.05 af33002c

2013-10-09 15:40:04

c_schmitz

Details Diff
Fixed issue 07998: Underscore character in subqestion code breaks export of Array (numerical) questions Affected Issues
07998
mod - application/helpers/admin/export/Writer.php Diff File

Issue History

Date Modified Username Field Change
2013-07-12 12:01 lucass New Issue
2013-07-12 12:01 lucass File Added: export problem.lsa
2013-07-12 12:01 lucass Issue Monitored: lucass
2013-09-03 15:05 lucass File Added: lime.patch
2013-09-03 15:06 lucass Note Added: 26144
2013-09-27 18:08 c_schmitz Assigned To => c_schmitz
2013-09-27 18:08 c_schmitz Status new => assigned
2013-09-27 18:11 c_schmitz Changeset attached => LimeSurvey master afa7e188
2013-09-27 18:11 c_schmitz Note Added: 26405
2013-09-27 18:11 c_schmitz Resolution open => fixed
2013-09-27 18:11 c_schmitz Note Added: 26406
2013-09-27 18:11 c_schmitz Status assigned => resolved
2013-09-27 18:11 c_schmitz Fixed in Version => 2.00+
2013-09-28 22:54 mfaber Issue Monitored: mfaber
2013-09-29 15:27 c_schmitz Note Added: 26423
2013-09-29 15:27 c_schmitz Status resolved => closed
2013-10-09 18:05 c_schmitz Changeset attached => LimeSurvey 2.05 af33002c
2013-10-09 18:05 c_schmitz Note Added: 26677
2021-08-02 16:09 guest Bug heat 4 => 8