This topic is locked

Excel Export Carriage Return Line Feed Problem

8/28/2010 9:01:40 PM
PHPRunner General questions
M
MikeB941 author

Version 5.0 - Build 766
If you export a text area field (not HTML or rich text editor) to Excel (not Word) that has multiple lines, it appears the carriage return/line feed is replaced with a space during the export and the entire field runs together within the Excel cell.
Changing the field to HTML and using the rich text editor is NOT a solution as this causes a NEW ROW to be created for each line in the text field.
Is there a way to export a text area field which contains multiple lines (carriage return/line feed) to Excel (not Word) and have those multiple lines preserved within a single Excel cell/row?
I'm using Excel from Office 2000 in case the version is an issue.
Thanks so much for any help. Take Care... Mike.

Admin 8/30/2010

Mike,
I don't think you can fix this in version 5.0.
In version 5.2 you can use 'Before Export Record' event to convert carriage returns to
so Excel understands it.