CSV/Excel Export
Erik van der Gaag
New Zealand
Hello,
We are having an issue with exporting to csv and excel.
One of our frxMemo's has stretch on so that the text will wrap around onto multiple lines, but when this is exported, we end up with blank lines under the lines that wrapped.
This is quite annoying for the user who has to then go through and manually remove the blank lines in the csv/excel file.
Why does this do this? ? Is there any way to fix this issue.
Regards,
Erik.
We are having an issue with exporting to csv and excel.
One of our frxMemo's has stretch on so that the text will wrap around onto multiple lines, but when this is exported, we end up with blank lines under the lines that wrapped.
This is quite annoying for the user who has to then go through and manually remove the blank lines in the csv/excel file.
Why does this do this? ? Is there any way to fix this issue.
Regards,
Erik.
Comments
I had some similar issues and the only workaround for this (although not very elegant) was to use a narrow font like Universe Condensed of size 2. If the wrapped text is not too long it should fit on a single line using a such small font size.
As long as you don't care about the page size (you export it to CSV anyway) you can use a page size A3, A2, A1 in landscape mode so your memo fields can be wider.
Unfortunately this report is also for viewing on screen and printing. So this solution won't help for us.
Thanks for your reply.