View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
04306Bug reportsImport/Exportpublic2010-05-05 18:472010-05-21 19:05
Reporterfabiin Assigned Tolemeur  
PriorityhighSeverityblock 
Status closedResolutionfixed 
Product Version1.87+ 
Fixed in Version1.90RC1 
Summary04306: Excel export bug when result seems to be an Excel formula
Description

I've got apache "Internal server error" when trying to export survey in Excel format.

The error occure when a result in a text field start with "=" char and contain impossible math expression

Steps To Reproduce
  1. Create survey
  2. Create single group
  3. Create single ask (format : long text field)
  4. Activate survey
  5. Run survey
  6. Write exactelly the text field :

=(lme alu(j+1) x coeff alu x %alu)-décote (fonction de la teneur en alu variable entre 45 et 70 % d'alu))

  1. Finish the survey
  2. Go to result, and try to export all results in Excel format

The loading time take 20 sec on my server, then crash with "Internal server error" message.

In appache error log file Just one line : "Premature end of script headers"

Additional Information

Sorry for my bad english.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)8374
I will donate to the project if issue is resolved
BrowserFirefox 3.6.3
Database type & versionMySQL: 5.0.44
Server OS (if known)Gentoo 2.6.21.5
Webserver software & version (if known)Apache 2.0.59
PHP VersionPHP 5.2.5

Users monitoring this issue

lemeur

Activities

lemeur

lemeur

2010-05-09 14:54

developer   ~11734

I confirm the bug.
It might be related to a bug in the Excel library we're using.

I set priority to high since I feel like this may cause server crashes/Deny of servces or worse...

Thibault
lemeur

lemeur

2010-05-09 15:19

developer   ~11735

Fixed in rev 8703: now all fields beginning by an "=" char are enclosed in double quotes in Excel export.

Thibault
lemeur

lemeur

2010-05-21 19:05

developer   ~11933

1.90 beta3 release

Issue History

Date Modified Username Field Change
2010-05-05 18:47 fabiin New Issue
2010-05-06 10:27 c_schmitz Category Import / Export => (No Category)
2010-05-09 14:51 lemeur Issue Monitored: lemeur
2010-05-09 14:52 lemeur Priority normal => urgent
2010-05-09 14:52 lemeur Category (No Category) => Import/Export
2010-05-09 14:52 lemeur Assigned To => c_schmitz
2010-05-09 14:52 lemeur Status new => assigned
2010-05-09 14:54 lemeur Note Added: 11734
2010-05-09 14:54 lemeur Status assigned => confirmed
2010-05-09 14:54 lemeur Priority urgent => high
2010-05-09 15:17 lemeur Assigned To c_schmitz => lemeur
2010-05-09 15:17 lemeur Status confirmed => assigned
2010-05-09 15:19 lemeur Note Added: 11735
2010-05-09 15:19 lemeur Status assigned => resolved
2010-05-09 15:19 lemeur Fixed in Version => 1.90RC1
2010-05-09 15:19 lemeur Resolution open => fixed
2010-05-21 19:05 lemeur Note Added: 11933
2010-05-21 19:05 lemeur Status resolved => closed
2021-08-02 17:49 guest Bug heat 2 => 4