View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
13237 | Bug reports | Import/Export | public | 2018-01-24 10:37 | 2018-01-25 12:33 |
Reporter | rob040 | Assigned To | c_schmitz | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.0.x | ||||
Fixed in Version | 3.1.x | ||||
Summary | 13237: Problem with opening Excel export | ||||
Description | When opening an export of the responses in Excel 2016 the following error message pops up: "Excel cannot open the file 'filename.xlsx' because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." Editing the file in Notepad++ shows white lines at the start of the file and missing closing tags at the end of the file. Removing the white line at the start of the file results in Excel trying to repair the file (which eventually works). | ||||
Steps To Reproduce | In a survey go to Responses > Responses & Statistics > Export > Export responses. Select Microsoft Excel and click on Export. Open the file in Excel. Then the error message pops up. | ||||
Tags | No tags attached. | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 3.0.5+180118 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | MySQL 5.5.59 | ||||
Server OS (if known) | CentOS 6.9 | ||||
Webserver software & version (if known) | Apache/2.2.15 | ||||
PHP Version | 5.6.33 | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2018-01-24 10:37 | rob040 | New Issue | |
2018-01-24 16:27 | c_schmitz | Assigned To | => c_schmitz |
2018-01-24 16:27 | c_schmitz | Status | new => feedback |
2018-01-24 16:27 | c_schmitz | Note Added: 46025 | |
2018-01-25 11:05 | rob040 | Note Added: 46079 | |
2018-01-25 11:05 | rob040 | Status | feedback => assigned |
2018-01-25 11:05 | rob040 | Issue Monitored: rob040 | |
2018-01-25 12:33 | c_schmitz | Status | assigned => closed |
2018-01-25 12:33 | c_schmitz | Resolution | open => fixed |
2018-01-25 12:33 | c_schmitz | Fixed in Version | => 3.1.x |
2021-08-11 12:51 | guest | Bug heat | 4 => 6 |