Line breaks in exported survey results

[BonnieHellevig]

WHen exporting survey results as a spreadsheet, line breaks entered by the respondent appear as little squares and no longer act like lines breaks.

How can these be preserved or converted into line breaks? Tabs has the same problem.

Thank you,
Bonnie

[pwiesner]

We do not alter tab characters in anyway which makes me believe that the problem is likely caused by Excel opening the export with the wrong encoding. How did you open the file? In our documentation section (http://www.checkbox.com/support/documentation.asp) of our website there is a guide entitled "Using Excel to View Multi-Language Response Exports" that walks through the process of opening exported results.

You did not indicated what version of the product you are using but in recent releases it is possible to control how line breaks are handled in the export. The default behavior is to remove them all together. This can be changed by updating the NewLineReplacement application setting. The following SQL will ensure that new lines are not altered. You can change NEW_LINE to another value if you would prefer they be replaced with a special character.

--BEGIN
EXEC ckbx_Install_UpSertSetting 'NewLineReplacement ', 'NEW_LINE'
--END