Report export to excel mixing up data?

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hi guys,

I created a report that when exported in pdf format or displayed in onscreen is fantastic. but I try and export it by clicking on export and the follow happens?

I get data from one cell put in a different cell randomly.

for example

date 19/10/2014
location 68 farm lane, London. me8 5jd
Agent john tenner

When I export it, the following happens??

date London. me8 5jd
location 68 farm lane, john tenner
Agent 19/10/2014

If you could help, that would be fantastic as I have no idea what to do. database is usless if I cant export the data.

thanks

Kevin

2

Hi there,

Can you show a screen shot of the report(detail view) and of the export? It could be due to your delimiter set in your user preferences, that the CSV is splitting.

Thanks,

Will.

3

Hi Will,

Thanks for your prompt Reply.

I have sorted it now. There might have been an easier way but I posted this as a response.

https://suitecrm.com/forum/suitecrm-7-0-discussion/2826-major-problem-with-excel-export

Thanks again!

1 Like