11624: Zeros in Excel Export are formatted as text not as numbers

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

11624	Bug reports	Import/Export	public	2016-09-06 08:47	2016-09-08 12:27

Reporter	halliballi123	Assigned To	c_schmitz
Priority	none	Severity	minor
Status	closed	Resolution	fixed
Product Version	2.50.x
Fixed in Version	2.52.x

Summary	11624: Zeros in Excel Export are formatted as text not as numbers
Description	When exporting responses into Excel files, zero values are formatted as text cells not as number cells
Additional Information	I added a screenshot where you can see the different formatting
Tags	No tags attached.
Attached Files	nullen_in_excel.PNG (7,697 bytes) nullen_in_excel.PNG (7,697 bytes) nullen_in_excel_Bild2.PNG (6,763 bytes) nullen_in_excel_Bild2.PNG (6,763 bytes) limesurvey_survey_113169.lss (19,443 bytes)

Bug heat	6
Complete LimeSurvey version number (& build)	2.5 build 160804
I will donate to the project if issue is resolved	No
Browser	not relevant
Database type & version	not relevant
Server OS (if known)	gentoo linux
Webserver software & version (if known)	not relevant
PHP Version	not relevant

User List	halliballi123

c_schmitz 2016-09-06 12:55 administrator ~40694	Please add a 1-question sample .lsa survey demonstrating the issue. Thank you!

halliballi123 2016-09-06 13:09 reporter ~40696	I added : 1 ) a one question sample 2 ) excel screenshot with exported responses of the one question sample (zero values are highlighted

c_schmitz 2016-09-07 15:09 administrator ~40721	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=20427

c_schmitz 2016-09-07 15:10 administrator ~40722	Thank you!

c_schmitz 2016-09-08 12:27 administrator ~40727	Version 2.51.4 released.

Date Modified	Username	Field	Change
2016-09-06 08:47	halliballi123	New Issue
2016-09-06 08:47	halliballi123	File Added: nullen_in_excel.PNG
2016-09-06 12:55	c_schmitz	Note Added: 40694
2016-09-06 12:55	c_schmitz	Assigned To	=> c_schmitz
2016-09-06 12:55	c_schmitz	Status	new => feedback
2016-09-06 13:07	halliballi123	Issue Monitored: halliballi123
2016-09-06 13:08	halliballi123	File Added: nullen_in_excel_Bild2.PNG
2016-09-06 13:08	halliballi123	File Added: limesurvey_survey_113169.lss
2016-09-06 13:09	halliballi123	Note Added: 40696
2016-09-06 13:09	halliballi123	Status	feedback => assigned
2016-09-07 15:09	c_schmitz	Status	assigned => resolved
2016-09-07 15:09	c_schmitz	Fixed in Version	=> 2.52.x
2016-09-07 15:09	c_schmitz	Resolution	open => fixed
2016-09-07 15:09	c_schmitz	Changeset attached	=> LimeSurvey master 0e028509
2016-09-07 15:09	c_schmitz	Note Added: 40721
2016-09-07 15:10	c_schmitz	Note Added: 40722
2016-09-08 12:27	c_schmitz	Note Added: 40727
2016-09-08 12:27	c_schmitz	Status	resolved => closed
2021-08-04 02:02	guest	Bug heat	4 => 6

LimeSurvey: master 0e028509 2016-09-07 15:09 c_schmitz Details Diff	Fixed issue 11624: Zeros in Excel export are formatted as text not as numbers		Affected Issues 11624
	mod - application/third_party/xlsx_writer/xlsxwriter.class.php		Diff File