The two functions are different. Exporting works under all circumstances of which I am aware. Copy to clipboard only seems to work when pasting into Excel. And custom reports cannot be exported, only copied to the clipboard. See the bug report: Copy to clipboard button should support all spreadsheet programs - #2 by Joe91.