andrea
Posts: 18
|
Posted: 10/17/2011, 11:24 AM |
|
Tested with PHP+MySql.
When exporting to Excel from a table containing TEXT fields, following the example from CCS Example Pack, every carriage return + line feed is converted to a <br>. This forces Excel to a new row.
To have your text in a single cell add in the <head> section:
<style>
br {mso-data-placement:same-cell;}
</style>
Hope it helps.
Andrea
|
|
|
datadoit
|
Posted: 10/17/2011, 5:50 PM |
|
Awesome. Thanks for sharing.
|
|
|
kirchaj
Posts: 215
|
Posted: 10/18/2011, 6:30 AM |
|
Andrea,
I had this very problem earlier this week. I will try with Postgres and report the outcome.
Thanks for sharing.
TK
Works like a charm with Postgres too ;)
|
|
|
andrea
Posts: 18
|
Posted: 10/18/2011, 9:50 AM |
|
Good to know!
|
|
|
|