Hi,

thank you for your quick reply and sorry for being vague. The error message does not appear on screen, no matter what debug mode is set to. It appears at the beginning of the Excel-file.

I get access denied when trying to view bug report 1921 and I can not find 4171 or 4200.

As I wrote before, I am not an expert, but this might not be an actual bug. The main problem, I think, is my host not allowing me to change open_basedir. Worksheet.php uses the tempfile-function which really doesn't seem to care what $tempdir is set to. Instead it tries to write to open_basedir and fails.

I will try and ask my host for support again and then report back here.

Unfortunately, my earlier suspicions were correct. There is nothing wrong with the script, the problem is the open_basedir restriction, set by my host. I uploaded the script to another host who did not have any open_basedir restriction and exporting to Excel works just fine there.

I'm not sure about the rules concerning editing the script but I came up with a workaround for my problem.

In Worksheet.php:

1. Set $this->_using_tmpfile = false;

For some reason this isn't enough, you also need to:

2. Comment out this call /** $this->_initialize();
*/

Doing this makes exporting to Excel work using a host with an open_basedir restriction. At least for me. Note! As it says in the script, data gets temporarily stored to memory instead of to a tempfile. Exporting large surveys may take a while. I hope this was helpful. Thank you very much for LimeSurvey. I couldn't have done my thesis without it!

Hi, thx for sharing your experience; I talked to our project leader Carsten Schmitz about your solution and I think it will make it into one of our next releases.

I posted it as a bugreport:
bugs.limesurvey.org/view.php?id=1960