Easter Sale 2025

  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Form Export content breaks lines in Excel

Form Export content breaks lines in Excel 15 years 11 months ago #7243

We use forms that have several values for checkbox selections; these appear fine when displayed in the RSForm Pro backend administrator, but when exported as CSV file, line breaks occur after each item.

Ugghh! Makes for tough hand editing to get it right for dozens of submissions.

Makes me wonder if the item separator within the field is LF or CR instead of comma and that is the culprit?

Anybody else a frequent CSV exporter that can share some hints?

BTW, really like RSForm PRO and considering the RSEvents
The administrator has disabled public write access.

Re:Form Export content breaks lines in Excel 15 years 11 months ago #7252

  • matt
  • matt's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 136
  • Thank you received: 14
Hi!

I also had a the same problem. But it works fine for me to open the file if I at the export of data enters a blankstep in the delimiter field. I have just tested to open the csv-file in OpenOffice not in Excel.

Matt
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!