Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Can I mark somehow fields that I don't want see in export

  • teksur
  • teksur's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 2 weeks ago #136840 by teksur
Can I mark somehow fields that I don't want see in export was created by teksur
I am using Version 2.50+ Build 160525.

Export to Excel. There are columns and I can take some away, but this I have to do every time. Can not save it. So, is any way to mark somewhere that I don't want some fields because they are just headers.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 2 weeks ago #136849 by holch
Replied by holch on topic Can I mark somehow fields that I don't want see in export
I don't think so.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
9 years 2 weeks ago #136871 by DenisChenu
Replied by DenisChenu on topic Can I mark somehow fields that I don't want see in export
Hi,

With 2.06 : i have a plugin framagit.org/SondagePro-LimeSurvey-plugin/quickSelectColumns but surely don't work in 2.50.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 2 weeks ago #136877 by tpartner
Replied by tpartner on topic Can I mark somehow fields that I don't want see in export
It should be fairly trivial to create a macro in Excel to remove the columns.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
More
9 years 2 weeks ago - 9 years 2 weeks ago #136885 by Ben_V
Replied by Ben_V on topic Can I mark somehow fields that I don't want see in export
Unfortunately LS is lacking XML export facilities for answers even if this format is intensively used elsewhere (.lss, lsg, .lsq, etc.).

For people using advanced Excel documents (styles, formulas, macros etc.) there is a lot of advantages to import (static/local or dynamic/online) XML files compare to XLS or CSV files... (for example this approach to manage unwanted columns ;) )

Loading XML files as data source is available in all Excel versions since 2007.
I'm talking about static local files. Using office 365 (and maybe recent desktop version I don't know) you can load online XML files... so if you can configure your own script to generate this file... you will pretty have nothing else to do further except opening your spreadsheet. Related post
Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last edit: 9 years 2 weeks ago by Ben_V.
The topic has been locked.
Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source