View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
08075Bug reportsResponse browsingpublic2013-08-04 13:27
Reporterwlodarczyk Assigned ToDenisChenu  
PrioritynormalSeverityminor 
Status closedResolutionno change required 
Product Version2.00+ 
Summary08075: OpenOffice treats LS generated XLS files as Excel 5.0
Description

The XLS files generated by LS when exporting survey results or statistics are interpreted by OpenOffice as being Excel 5.0. The result is that if one naively saves one of these files via OpenOffice without specifically changing the file type in the OpenOffice save dialog, issues such as data truncation may occur. While this is perhaps not technically a bug, it is a "gotcha" that makes the system more difficult to use.

Steps To Reproduce
  • Use any survey
  • Go to "Responses & Statistics"
  • Go to "Export results to application"
  • Choose "Microsoft Excel" as the format
  • Save results
  • Open results XLS in OpenOffice
  • In OpenOffice, select File -> Save As; Note file type in that dialog is set to "Microsoft Excel 5.0 (.xls)"
TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130708
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMySQL 5
Server OS (if known)Debian Squeeze
Webserver software & version (if known)Apache 2
PHP Version5.3.3-7
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2013-08-04 13:27

developer   ~25914

Last edited: 2013-08-04 13:27

Use CSV for OOo/LibreOffice.

XLS is for excel2003

Issue History

Date Modified Username Field Change
2013-08-01 19:09 wlodarczyk New Issue
2013-08-04 13:27 DenisChenu Note Added: 25914
2013-08-04 13:27 DenisChenu Note Edited: 25914
2013-08-04 13:27 DenisChenu Status new => closed
2013-08-04 13:27 DenisChenu Assigned To => DenisChenu
2013-08-04 13:27 DenisChenu Resolution open => no change required