On Macs, Copy to Clipboard adds 1470 zero bytes at the end

[Lenny P. Robert]

When you select the Copy to Clipboard option, 1470 bytes with value zero get added to the Latex code. In text editors that can display invisible characters these zero bytes show up invalid characters (in TextWrangler as inverted red questions marks, in SubEthaEdit as large red diamond). Pasting this into a .tex file and compiling it, one obtains an invalid character error. Deleting all text before the invalid characters and opening the file in Hex editor, one sees 1470 zeros.

The current workaround is to simply delete the last line of what one is pasting. I have tested that with three different text editors

This problem of Excel2Latex (on Macs) has existed for at least five if not ten years.

[Kirill Müller (krlmlr)]

Well, it's slightly more than one year since I have taken over the project, and I don't own a Mac. That said, I'm going to verify the problem as soon as I can get my hands on a Mac, but I'm not sure if I'll be able to find a solution for this other than disabling the button in Mac.

Have you tried the "Save to file" option, or the new "Stored tables" feature? Store your table definitions once (this includes a target file name), then convert all table definitions with just one click.

[Kirill Müller (krlmlr)]

This seems to be a problem in the DataObject used by the "copy to clipboard" function:

http://www.excelbanter.com/showthread.php?t=282307

http://www.textndata.com/forums/putinclipboard-method-errors-mac-24928.html

This means that we have to wait for Microsoft to fix this. In the meantime, please use "Save to file" or "stored tables".

[Naser Nikandish (n-nikandish)]

This problem still exists and the suggested solution works just fine
https://bugs.launchpad.net/excel2latex/+bug/1071992