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 - -
Gewysig op
Gekose oplossing
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.
Lees dié antwoord in konteks 👍 2All Replies (2)
Gekose oplossing
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.
Gewysig op
Thank You jscher2000 for your prompt reply and guiding me to the required add-on. It works well with minor modifications.
Thanks again.