While copying table of text from webpage and pasting in notepad or MS-Word, the format gets disrupted
for example, select and copy text from [webpage] and paste in Notepad or Word. The cells that contain the value as "-" gets an extra carriage return.
The sample from Notepad or Word is as under:
(2) Public 1 112,618,796 112,600,896
-
3.44
-
-
Sub Total 1 112,618,796 112,600,896
-
3.44
-
-
However, it should look like (in notepad or Word):
(2) Public 1 112,618,796 112,600,896 - 3.44 - -
Sub Total 1 112,618,796 112,600,896 - 3.44 - -
Total (A)+(B)+(C) 3,406,107 3,271,059,340 3,188,897,616 - 100.00 - -
השתנתה ב־ על־ידי nileshsoni
פתרון נבחר
Yes, it's a weak point. Internet Explorer detects that you are copying part of a table and places additional HTML code on the clipboard to preserve the overall structure. IE also includes a link to the page's style sheet for applications such as MS Word that can read them. Firefox just copies what you selected, so when viewed out of context, the receiving program cannot reconstruct the original appearance.
(If you copy enough of the page to include the entire table, then you will get the correct layout, and you can copy the desired rows from within MS Word and then dump the rest of the table. An extra step.)
There is an add-on to help copy tables. I haven't tried it myself. If you try it, please let us know whether it helps.
Dafizilla Table2Clipboard :: Add-ons for Firefox
In searching, I noticed another add-on that includes a copy feature as well as many other features that might or might not be of interest: TableTools2 - Copy/Sort/Chart/Filter Table&More! :: Add-ons for Firefox. I also have not tried that one.
Read this answer in context 👍 2כל התגובות (2)
פתרון נבחר
Yes, it's a weak point. Internet Explorer detects that you are copying part of a table and places additional HTML code on the clipboard to preserve the overall structure. IE also includes a link to the page's style sheet for applications such as MS Word that can read them. Firefox just copies what you selected, so when viewed out of context, the receiving program cannot reconstruct the original appearance.
(If you copy enough of the page to include the entire table, then you will get the correct layout, and you can copy the desired rows from within MS Word and then dump the rest of the table. An extra step.)
There is an add-on to help copy tables. I haven't tried it myself. If you try it, please let us know whether it helps.
Dafizilla Table2Clipboard :: Add-ons for Firefox
In searching, I noticed another add-on that includes a copy feature as well as many other features that might or might not be of interest: TableTools2 - Copy/Sort/Chart/Filter Table&More! :: Add-ons for Firefox. I also have not tried that one.
השתנתה ב־ על־ידי jscher2000 - Support Volunteer
Thank You jscher2000 for your prompt reply and guiding me to the required add-on. It works well with minor modifications.
Thanks again.