View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 20
IDProjectCategoryView StatusDate SubmittedLast Update
11285Bug reportsStatisticspublic2016-05-27 15:132017-03-07 23:41
ReporterMPBMWI16 Assigned Toc_schmitz  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.50.x 
Fixed in Version2.50.x 
Summary11285: Export results to MS-Excel not working
Description

When trying to export the survey results to MS-Excel (2010) the xlsx-document is not readable/empty.

Steps To Reproduce
  • Export
  • Export results to application
  • Export format: Microsoft Excel
  • Export
Additional Information

Worked fine under 160525.
Error came up after update to 160526

TagsNo tags attached.
Bug heat20
Complete LimeSurvey version number (& build)Version 2.50+ Build 160526
I will donate to the project if issue is resolvedNo
BrowserFirefox, IE, Chrome
Database type & versionMySQL 5
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.0 20051115
PHP Version5.5

Relationships

Relationship GraphDependency Graph
has duplicate 11360 closedc_schmitz Bug when exporting survey results to excel xlsx 
has duplicate 12175 closedDenisChenu Open base dir restriction disable export of xlsx 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2016-05-27 16:46

developer   ~38976

Looking at date : seems related to xlsx, no ?
c_schmitz

c_schmitz

2016-05-27 20:45

administrator   ~38978

Please attach the exported file.
Also attach the survey as .lsa file. Thank you!
The bug is switched to private so nobody else will be able to see your files.
MPBMWI16

MPBMWI16

2016-06-03 09:22

reporter   ~39119

Reminder sent to: c_schmitz

Dear Mr Schmitz,
is there a solution for the xlsx-export?
Best regards,
C. Otto
c_schmitz

c_schmitz

2016-06-09 12:37

administrator   ~39343

I think it is some specific to your server configuration - I can export your data just fine here.
c_schmitz

c_schmitz

2016-06-09 12:54

administrator   ~39347

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

c_schmitz

2016-06-09 12:55

administrator   ~39348

Please try the attached patch and let us know if it works.
MPBMWI16

MPBMWI16

2016-06-09 13:49

reporter   ~39351

I changed the two files according to your patch and it works fine!
Thank you very much!!!
c_schmitz

c_schmitz

2016-06-09 13:51

administrator   ~39353

Great - you are welcome!
Jelle_S

Jelle_S

2016-06-10 15:42

reporter   ~39427

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

c_schmitz

2016-06-13 12:26

administrator   ~39483

Version 2.50 Build 160613 released

Related Changesets

LimeSurvey: master c0f3001e

2016-06-09 10:54:19

c_schmitz

Details Diff 		Fixed issue 11285: Export results to .xslx not working under certain server environments Affected Issues
11285
mod - application/helpers/admin/export/ExcelWriter.php Diff File
mod - application/third_party/xlsx_writer/xlsxwriter.class.php Diff File

Issue History

Date Modified Username Field Change
2016-05-27 15:13 MPBMWI16 New Issue
2016-05-27 16:46 DenisChenu Assigned To => c_schmitz
2016-05-27 16:46 DenisChenu Status new => assigned
2016-05-27 16:46 DenisChenu Note Added: 38976
2016-05-27 20:44 c_schmitz View Status public => private
2016-05-27 20:45 c_schmitz Note Added: 38978
2016-05-27 20:45 c_schmitz Status assigned => feedback
2016-05-27 21:14 MPBMWI16 File Added: survey_archive_341275.lsa
2016-05-27 21:14 MPBMWI16 File Added: results-survey341275.xlsx
2016-05-27 21:20 MPBMWI16 Status feedback => assigned
2016-06-03 09:22 MPBMWI16 Note Added: 39119
2016-06-09 12:32 c_schmitz Relationship added has duplicate 11360
2016-06-09 12:37 c_schmitz Note Added: 39343
2016-06-09 12:53 c_schmitz File Deleted: survey_archive_341275.lsa
2016-06-09 12:53 c_schmitz File Deleted: results-survey341275.xlsx
2016-06-09 12:53 c_schmitz View Status private => public
2016-06-09 12:54 c_schmitz Changeset attached => LimeSurvey master c0f3001e
2016-06-09 12:54 c_schmitz Note Added: 39347
2016-06-09 12:54 c_schmitz Resolution open => fixed
2016-06-09 12:55 c_schmitz Note Added: 39348
2016-06-09 12:55 c_schmitz Status assigned => resolved
2016-06-09 12:55 c_schmitz Fixed in Version => 2.5
2016-06-09 13:49 MPBMWI16 Note Added: 39351
2016-06-09 13:51 c_schmitz Note Added: 39353
2016-06-10 15:42 Jelle_S Changeset attached => LimeSurvey master 3065832d
2016-06-10 15:42 Jelle_S Note Added: 39427
2016-06-10 15:49 c_schmitz Changeset removed LimeSurvey master 3065832d =>
2016-06-13 12:26 c_schmitz Note Added: 39483
2016-06-13 12:26 c_schmitz Status resolved => closed
2017-03-07 23:41 DenisChenu Relationship added has duplicate 12175