Closed Bug 638439 Opened 14 years ago Closed 13 years ago

Copy/paste of a table from Firefox to Excel 2007 does not work as expected

Categories

(Firefox :: General, defect)

x86
Windows 7
defect
Not set
normal

Tracking

()

RESOLVED DUPLICATE of bug 137450

People

(Reporter: lambin, Assigned: bbondy)

Details

Attachments

(1 file)

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0b12) Gecko/20100101 Firefox/4.0b12 Build Identifier: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0b12) Gecko/20100101 Firefox/4.0b12 When copying a table from Firefox to Excel 2007, instead of actually copying the table correctly with rows & lines, Excel pastes all the date in one single cell. This is useful when copying data from phpmyadmin for example. Reproducible: Always Steps to Reproduce: 1. Select data in a HTML table 2. Copy 3. Paste into Excel Actual Results: All data are pasted into a single cell. Expected Results: The table should appear correctly in Excel. (it works that way when copying data from Chrome) When copy/pasting from Firefox to Notepad++, then from Notepad++ to Excel 2007, the data is correctly interpreted by Excel and the table is correctly pasted.
Can you provide and attach a Testcase showing the Issue? Did it work with past Firefox Versions? If yes, what is the last one?
Keywords: testcase-wanted
I did some more tests with the following page Http://www.w3schools.com/html/html_tables.asp Copy the table (bananas, apple, etc) Firefox 3.6.14 / Excel 2010 / Windows 7 x64 -> works, paste ok, keeps table & cells' style Firefox 3.6.14 / Excel 2007 / Windows 7 x86 -> incorrect paste (everything is pasted into one cell) paste to notepad, then copy/paste from notepad to Excel 2007 -> works, but does not keep table or cells' style Firefox 4b12 / Excel 2007 / Windows 7 x64 -> incorrect paste (everything is pasted into one cell) paste to notepad, then copy/paste from notepad to Excel 2007 -> works, but does not keep table or cells' style Those tests seem to show that the problem lies into Excel 2007... BUT : Chrome 9.0 / Excel 2007 / Windows 7 x64 -> works, paste ok, keeps table & cells' style
Is Firefox 4 + Excel 2010 okay too?
Also: Firefox 3.6.14 / Excel 2003 SP3 / Windows XP SP3 -> incorrect paste (everything is pasted into one cell) paste to notepad, then copy/paste from notepad to Excel 2003 -> works, but does not keep table or cells' style
This reproduces in FireFox 4b12. Go to about:support, select the Hardware Acceleration table at the bottom, press Ctrl+C, open Notepad, press Ctrl+V - One line of text with no spaces between the cells/new lines between the rows. Related/duplicated issues - https://bugzilla.mozilla.org/show_bug.cgi?id=572543 https://bugzilla.mozilla.org/show_bug.cgi?id=137450 https://bugzilla.mozilla.org/show_bug.cgi?id=237546 https://bugzilla.mozilla.org/show_bug.cgi?id=303736 https://bugzilla.mozilla.org/show_bug.cgi?id=515464
Status: UNCONFIRMED → NEW
Ever confirmed: true
The attached html file shows the results of a copy & paste using firefox/ms word and internet explorer/ms word. The data source (web page) is http://finance.yahoo.com/; specifically: the first line (Dow) of the US MARKET SUMMARY. The attached file shows the results for Word although I first noticed the issue (as already reported) in MS Excel. As already indicated, it appears that Firefox copies the data as a single character string, whereas Explorer copies it as 1 row x 4 cell tables.
Firefox Nightly / Excel 2010 / Windows 7 x64 - incorrect paste (everything is pasted into one cell).
A good testcase is about:support - just try to select any table (hold CTRL when selecting it).
Assignee: nobody → netzen
I provided a patch for this in Bug 137450. Marking this as a duplicate.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → DUPLICATE
Note: For "Cell style" which is talked about after the original report was posted, if I don't find any duplicates of cell style already I'll post a new clean ticket specifically for that.
Cell style comments are covered in Bug 237546
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: