Akuini
Well-known Member
- Joined
- Feb 1, 2016
- Messages
- 5,274
- Office Version
- 365
- Platform
- Windows
Thank you.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
XenForo
- Thread starter shg
- Start date
smozgur
BatCoder
- Joined
- Feb 28, 2002
- Messages
- 2,674
Let me share my thoughts on this "copy & paste & Edge issue" (and also Safari in Mac as it acts like Edge) - as I can understand what/how it is happening.
When the editor is BB Code toggled on, it is basically not using JavaScript but only an ordinary text box (TEXTAREA element actually). So if what you have in clipboard has partial text, only the text content will be pasted and the rest will be ignored as it won't be able to be processed as a clipboard data object. This is for sure. Pasting on Toggle On mode will absolutely not work.
When you switch toggle off, it is kind of WYSIWYG rich text box powered by JavaScript (it is actually not even a text box but a DIV wrapper in this mode). So pasted content (clipboard data) can be detected and processed as a table (or image, plain text...), and resulted with necessary tags to generate an HTML table what we see in Chrome and FireFox. This is done by the editor's JavaScript functions (similar to VBA's DataObject and GetFromClipboard / GetText method instead it is getting more information that is not revealed by VBA functions).
About Edge acting different than Chrome and FireFox - it should be about how Edge understands copied Excel object in clipboard, so it takes it as an image since the editor has no other option as it can't read that info as table by using the same JavaScript functions. Complicated, right? It is to me but it also makes sense as all browsers have their JavaScript engine and they simply don’t act same for everything even with same function names. Of course third party editor is considering this and even using different functions by detecting the browser but in this case, it doesn't look it is completely working.
In Edge, Excel range must be being considered somehow different, and the relying third party editor likely couldn’t have found a solution to make this work. I debugged its code partially without going too much detail and it is definitely taking the pasted data as image/png in Edge.
However, if you copy and paste the range into Word and then copy the just pasted table in Word and paste into editor then it will do it right. This tells me that clipboard data coming from Word can be understood by the editor in Edge.
I will check this at the editor side for further info - this is my quick response so far as much as in my understanding.
When the editor is BB Code toggled on, it is basically not using JavaScript but only an ordinary text box (TEXTAREA element actually). So if what you have in clipboard has partial text, only the text content will be pasted and the rest will be ignored as it won't be able to be processed as a clipboard data object. This is for sure. Pasting on Toggle On mode will absolutely not work.
When you switch toggle off, it is kind of WYSIWYG rich text box powered by JavaScript (it is actually not even a text box but a DIV wrapper in this mode). So pasted content (clipboard data) can be detected and processed as a table (or image, plain text...), and resulted with necessary tags to generate an HTML table what we see in Chrome and FireFox. This is done by the editor's JavaScript functions (similar to VBA's DataObject and GetFromClipboard / GetText method instead it is getting more information that is not revealed by VBA functions).
About Edge acting different than Chrome and FireFox - it should be about how Edge understands copied Excel object in clipboard, so it takes it as an image since the editor has no other option as it can't read that info as table by using the same JavaScript functions. Complicated, right? It is to me but it also makes sense as all browsers have their JavaScript engine and they simply don’t act same for everything even with same function names. Of course third party editor is considering this and even using different functions by detecting the browser but in this case, it doesn't look it is completely working.
In Edge, Excel range must be being considered somehow different, and the relying third party editor likely couldn’t have found a solution to make this work. I debugged its code partially without going too much detail and it is definitely taking the pasted data as image/png in Edge.
However, if you copy and paste the range into Word and then copy the just pasted table in Word and paste into editor then it will do it right. This tells me that clipboard data coming from Word can be understood by the editor in Edge.
I will check this at the editor side for further info - this is my quick response so far as much as in my understanding.
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,372
- Office Version
- 365
- Platform
- Windows
Sure is!
