Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - Using an IMAC to access QlikView and I've found that when I copy and paste to Excel the columns are not lining up properly. Called my work Helpdesk and we tried 3 different browsers (Safari, Chrome and Firefox) and none of them worked (though they all pasted differently).
He thinks it's the integration between the Mac and Excel (via Office 360) possibly. Anyone got any ideas what I can try?
thanks
Verify your values are all the same, numeric or alpha-numeric, I suspect you have a mix so some things are right and others are left justified. You would need to use Num() or Text() functions on Qlik side to lock those into those formats. Only thing of which I can think, need further information otherwise to try to help further.
Regards,
Brett
What happens when you use the Export or Send to Excel functions? Do they open Excel with proper formatting?
It sounds like you are using the copy table data function, but what about the export functions above?