Hi, this is Romain from France. Just bought access to your web application, congratulations it seems fantastic...except regarding export to Excel (I use excel 2007) :
I have a big problem regarding line-breaks due to multi-line inputs (textarea) in my form It really breaks the format of the CSV and I really cannot use it because these data are displayed on separate lines but also on columns different from the correponding field
=> Therefore I do not see how to use the CSV. Is it possible to fix this so that the whole textarea content is kept in a single cell
Otherwise, maybe you have tips to deal with such a situation ?
Unfortunately this a known bug in how Excel handles CSV. I had thought '07 had it fixed. First try the method described here: http://app.formassembly.com/pages/support/troubleshooting#excel (the import method described gives better results than simply opening the csv file)
If that fails for you, you can also try importing the CSV to Google Docs, and exporting to XLS. Google Docs has a very good custom binary XLS exporter, and it seems to be able to make Excel behave.
I had already tried the import method with Excel, without success But damn it ! I had not a clue about Google docs and you are right : it works perfectly, better than Excel ! I just have to check one more time behavior with more realistic data but It seems to be solved
The funny part is that it proves our CSV export is correct, as if it were incorrect Google Docs would refuse to import it. http://www.pcreview.co.uk/forums/thread-2574533.php As I recall, this has been broken in Excel since forever.