Welcome, Guest
Username: Password: Remember me

TOPIC: Is it possible to extend >256 columns in exporting

Is it possible to extend >256 columns in exporting 4 years 8 months ago #53938

  • nicoladie
  • nicoladie's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 12
  • Karma: 0
When exporting, it truncates <256 columns, not just in .xls or .doc but also in .csv but why limit it to .csv too? New MS .xlsx and .docx does not limit to <256 columns.

Is there any way to export more than >256 columns of data?
The administrator has disabled public write access.

Is it possible to extend >256 columns in exporting 4 years 8 months ago #53949

  • holch
  • holch's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 3706
  • Thank you received: 501
  • Karma: 162
For CSV I think you can simply mark more than 256 columns and export them.
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.

Is it possible to extend >256 columns in exporting 4 years 8 months ago #53950

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5725
  • Thank you received: 334
  • Karma: 255
Is this really limited to 256 columns?

If so, add this as a feature request at our feature tracker . Please describe your idea as detailed as possible and try to outline a suitable solution/implementation aswell.

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.

Is it possible to extend >256 columns in exporting 4 years 8 months ago #53989

  • nicoladie
  • nicoladie's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 12
  • Karma: 0
Ok, I have to re-select the column to all, then it exports >256 columns to .csv (It selected 256 by default).

Is there any plans to export to .xlsx or .docx?
The administrator has disabled public write access.

Is it possible to extend >256 columns in exporting 4 years 8 months ago #54002

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5725
  • Thank you received: 334
  • Karma: 255
You should be able to open both (.xls and .doc) at the latest Office versions?!

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.

Is it possible to extend >256 columns in exporting 4 years 8 months ago #54008

  • holch
  • holch's Avatar
  • Online
  • LimeSurvey Team
  • Posts: 3706
  • Thank you received: 501
  • Karma: 162
I think he/she refers to export for the new versions, because the limits for columns is a lot higher than 256. So an export to xlsx would have the advantage, that there is no limit of 256 columns, but of 16.384 columns.
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.

Is it possible to extend >256 columns in exporting 4 years 8 months ago #54281

  • Telekia
  • Telekia's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
Hi

First export it to CSV, I think there is no such 256 columns limit and then:

support.microsoft.com/kb/272729/en-us

Best regards from Canary Islands

jdD
The administrator has disabled public write access.

Is it possible to extend >256 columns in exporting 4 years 8 months ago #54338

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 7506
  • Thank you received: 1024
  • Karma: 297
No need office 2007, OpenOffice.org Calc have more than 256 column before MS-Office Excel.
And i never work to make a xslx export (maybe an ODS, but CSV is suffiscient)
And openoffice open CSV too.

Maybe we can remove the default 256 column maximum for CSV .
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.153 seconds