Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Save to EXCEL does not work after Col IV (col # 265)

Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #75542

  • protscheid
  • protscheid's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
When i Try to save my Survey to Excel its cuts off at Col IV :huh:

Please advice.

Peet
The administrator has disabled public write access.

Re: Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #75544

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
1. Which Limesurvey version do you use?

2. How many data sets are there at the survey (roughly)?

3. What happens when using CSV export?

4. Please switch on debug mode by adding the following line to your config.php file:
$debug = '1';

Are there any additional errors reported on top of the page?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #75547

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2950
  • Thank you received: 377
  • Karma: 124
I assume that you are using either an old version of Limesurvey or an old version of Excel, where the columns were limited to 256.

So please inform your version of Limesurvey and your version of Excel.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re: Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #75768

  • protscheid
  • protscheid's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
i am using Version 1.92 RC4 Build 12453
i have 5 open surveys with average 11 groups with each group average 20 questions.
when i am using CVS i have the same result, it cuts off

both EXCEL 07 and 10 gives me the same results.

thanks

Peter
The administrator has disabled public write access.

Re: Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #75777

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 819
  • Thank you received: 116
  • Karma: 93
The reason is that the LimeSUrvey Excel export only exports a relatively old format which only supports up to 255 columns.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.
The following user(s) said Thank You: protscheid

Re: Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #75781

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
I think the best workaround is to use CSV export and import that file at Excel. Shouldn't make much difference.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #76365

  • protscheid
  • protscheid's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
I have the same result using CVS, I think the export function dont pass the 256 collums: (Exportresults.php ==>

if ($afieldcount > 255)[/color] {
$exportoutput .= "\t<img src='$imageurl/help.gif' alt='".$clang->gT("Help")."' onclick='javascript:alert(\""
.$clang->gT("Your survey contains more than 255 columns of responses. Spreadsheet applications such as Excel are limited to loading no more than 255. Select the columns you wish to export in the list below.","js")
."\")' />";
The administrator has disabled public write access.

Re: Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #76370

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 819
  • Thank you received: 116
  • Karma: 93
If you are exporting to CSV you actually need to mark all columns. By default only the first 255 columns are marked.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.
The following user(s) said Thank You: protscheid

Re: Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #76371

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
c_schmitz wrote:
If you are exporting to CSV you actually need to mark all columns. By default only the first 255 columns are marked.
Note added at docs.limesurvey.org/Exporting+results#CS...aults_to_255_columns

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
The following user(s) said Thank You: protscheid

Re: Save to EXCEL does not work after Col IV (col # 265) 2 years 8 months ago #76380

  • protscheid
  • protscheid's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 4
  • Karma: 0
Super Thanks Guys this works great for me.
Love this product.

Thanks

Peter
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.187 seconds
Donation Image