View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
11624Bug reportsImport/Exportpublic2016-09-06 08:472016-09-08 12:27
Reporterhalliballi123 Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.50.x 
Fixed in Version2.52.x 
Summary11624: 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

TagsNo 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 heat6
Complete LimeSurvey version number (& build)2.5 build 160804
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionnot relevant
Server OS (if known)gentoo linux
Webserver software & version (if known)not relevant
PHP Versionnot relevant

Users monitoring this issue

halliballi123

Activities

c_schmitz

c_schmitz

2016-09-06 12:55

administrator   ~40694

Please add a 1-question sample .lsa survey demonstrating the issue. Thank you!
halliballi123

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

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

c_schmitz

2016-09-07 15:10

administrator   ~40722

Thank you!
c_schmitz

c_schmitz

2016-09-08 12:27

administrator   ~40727

Version 2.51.4 released.

Related Changesets

LimeSurvey: master 0e028509

2016-09-07 13:09:40

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

Issue History

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