Copy and paste html text with quotes in Calc

I try to copy and paste html text from Calc cells and paste into text editor. Anything with quotes (") ended up with double quotes (""). And strangely some html text without quotes but after paste into text editor quotes appears. I don’t have this problem in OpenOfiice and I can’t find any settings that’s affecting it. Please help.


<a href="">Google</a>
<a href="""">Google</a>


It would help to know what text editor and what operating system you are using. I cannot duplicate the problem placing your HTML samples above in a Calc cell and then copy and pasting them into TextEdit on a Mac.

Sorry. I realize it only happens when the HTML code is very long. I upload an example xls file to dropbox. You can download it, copy and paste everything into text editor. You will see the problem then.