Hey Jim,
I just released the 1.0.0 final release of the Export Manager module, and included this fix. So here's how to fix the problem on your site:
1. Upgrade your Export Manager module to the new release. To do this, just go to Settings -> Main tab in your Form Tools admin section and click on "Check for Updates".
2. After upgrading, edit the "table format" Excel option type. There, look for these lines (near the bottom):
And just tweak it to this:
nl2br_excel is a new modifier I added in 1.0.0 to get around the newline problem.
Let me know how it goes!
- Ben
I just released the 1.0.0 final release of the Export Manager module, and included this fix. So here's how to fix the problem on your site:
1. Upgrade your Export Manager module to the new release. To do this, just go to Settings -> Main tab in your Form Tools admin section and click on "Check for Updates".
2. After upgrading, edit the "table format" Excel option type. There, look for these lines (near the bottom):
Code:
{elseif $field_type == "textarea"}
{$value|nl2br}
{else}
{$value}
{/if}
And just tweak it to this:
Code:
{elseif $field_type == "textarea"}
{$value|nl2br_excel}
{else}
{$value}
{/if}
nl2br_excel is a new modifier I added in 1.0.0 to get around the newline problem.
Let me know how it goes!
- Ben