Check out the LimeSurvey source code on GitHub!

Is it possible to extend >256 columns in exporting

More
6 years 1 month ago #53938 by nicoladie01
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?

Please Log in to join the conversation.

More
6 years 1 month ago #53949 by holch
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 | Workarounds

Please Log in to join the conversation.

More
6 years 1 month ago #53950 by Mazi
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)survey-consulting.com'"

Please Log in to join the conversation.

More
6 years 1 month ago #53989 by nicoladie01
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?

Please Log in to join the conversation.

More
6 years 1 month ago #54002 by Mazi
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)survey-consulting.com'"

Please Log in to join the conversation.

More
6 years 1 month ago #54008 by holch
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 | Workarounds

Please Log in to join the conversation.

More
6 years 1 month ago #54281 by Telekia
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

Please Log in to join the conversation.

More
6 years 4 weeks ago #54338 by DenisChenu
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 .

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form