Problem in Excel: line breaks in textarea CCK fields lead to new data line when importing to Excel

Created on 13 November 2012, about 12 years ago
Updated 8 March 2023, almost 2 years ago

Hi,

a customer uses Excel and after some trouble we found out now that there are problems when a CSV export is imported to Excel: line breaks within these textarea fields lead to a break in import as if there were a new data line. The csv has the "*" as a seperator and the " for text identifier. In the exports cck fields are exported and those of type textarea make the trouble. They use the latest Excel version as I know.

My only way to solve this problem was to strip all line breaks by a custom views php field.

Best,
Tobias

πŸ’¬ Support request
Status

Closed: outdated

Version

1.1

Component

Views Export

Created by

πŸ‡©πŸ‡ͺGermany tobiberlin Berlin, Germany

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024