Closed
Bug 504671
Opened 15 years ago
Closed 15 years ago
copied table text nolonger pastes into Excel (new as of 3.5)
Categories
(Firefox :: General, defect)
Tracking
()
RESOLVED
DUPLICATE
of bug 137450
People
(Reporter: paul.bailey, Unassigned)
References
()
Details
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1) Gecko/20090624 Firefox/3.5
Build Identifier: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1) Gecko/20090624 Firefox/3.5
When I copy a portion of a table, or the entire table, I used to be able to paste this into excel (version "X" in this case) the specific error given is "Microsoft Excel cannot paste the data." This is a regression, this did not used to be a problem.
Reproducible: Always
Steps to Reproduce:
1. Open http://tsp.gov/rates/share-prices.html
2. copy some cells
3. open a new excel document
4. select a cell and hit command=V
5. read the error and cry
Actual Results:
me crying at the error, "Microsoft Excel cannot paste the data.""
Expected Results:
That it just paste into cells correctly.
Again, this has worked in every version of FF up to 3.5. Being able to play nice with other highly used software for functions as basic as copy and paste is a must, so I marked this "Major."
Reporter | ||
Comment 1•15 years ago
|
||
I imagine the problem relates to metadata regarding the copied text. I would imagine it used to just appear to be tab delimited text (which excel can gobble), but now it is marked as .html which it might not realize it can gobble.
Comment 2•15 years ago
|
||
see bug 470384 comment 13 for rational of duping to such an old bug
Status: UNCONFIRMED → RESOLVED
Closed: 15 years ago
Resolution: --- → DUPLICATE
Reporter | ||
Comment 3•15 years ago
|
||
I am not sure I agree. (1) this is a digression. (2) Are you sure that this isn't related related to a change in how the meta data for a copy and paste is handled in OS X.
Reporter | ||
Comment 4•15 years ago
|
||
Okay, I did some looking and yes, this bug might be able to be resolved by resolving bug 137450, but this bug could be resolved on its own.
Since FF3, 3.5 has had added the following types to the clipboard when copying tables (and all of the time? I don't know.)
public.html
Apple HTML pasteboard type
This appears to be the problem. Not doing this would resolve this bug.
Steps to reproduce:
1. Open http://tsp.gov/rates/share-prices.html
2. copy some cells
3. open a new excel document
4. select a cell
5. select the "edit" file menu, select "paste special..."
if you copied the text from FF 3 the only option will be "text" which will paste fine. If you copied from FF 3.5 there will first be a "HTML" option that will not work and then a "text" option that will work fine.
Simply removing the broken "HTML" type from what FF 3.5 moves to the clipboard will resolve this bug.
Status: RESOLVED → UNCONFIRMED
Resolution: DUPLICATE → ---
Comment 5•15 years ago
|
||
Paul, I think the problem described in bug 137450 is the same as this one, so I will dupe to that. Your approach to solving the problem is different, and it could be taken into consideration in fixing the above.
Status: UNCONFIRMED → RESOLVED
Closed: 15 years ago → 15 years ago
Resolution: --- → DUPLICATE
Comment 6•15 years ago
|
||
Major Bummer on the latest upgrade 3.5.5.
Prior to upgrading I could copy a multi-column of html page data and paste it into MS Office v.X Excel for the Mac. Excel would parcel the data in the same multi columns.
Now Excel states "Microsoft Excel cannot paste the data."
Word Accepts the data.
Reporter | ||
Comment 7•15 years ago
|
||
I think the point is that FF used to do A, now it does B which is broken. The question is this: why not make FF do A until B is not broken? This is a regression and there is no reason for FF to do broken B when it could just do A like it used to.
A = copy and past tables as text by default
B = copy and paste tables as HTML by default
Status: RESOLVED → UNCONFIRMED
Resolution: DUPLICATE → ---
Comment 8•15 years ago
|
||
This is still a dupe. The fix that caused this is bug 428096 Clipboard and drag-and-drop don't interoperate with formatted text (e.g. HTML) on OS X. This change makes Firefox copy styling info and the text. Excel strips the table fragment Firefox sends to the clipboard when using the default paste.
Till Excel can handle pasting partial table data or code is written to fix bug 137450 use one of the following.
* ctrl + click on the outer edge of the table to select the entire table
* use Excel's paste special, choose plain text
* use Open Office's Calc which handles tables smoothly
* or Table2Clipboard https://addons.mozilla.org/en-US/firefox/addon/1852
Status: UNCONFIRMED → RESOLVED
Closed: 15 years ago → 15 years ago
Resolution: --- → DUPLICATE
Reporter | ||
Comment 9•15 years ago
|
||
in OS X on a laptop:
* ctl + click = right click. This breaks (1) and (4)
* OOO is not ready for prime time on mac (still uses X)
I think it would be more honest to close this as wontfix rather than duplicate. My point is there is a regression, your point is "Excel is broken." I would point out that other OS X browsers know how to play nice. I can drag and drop from Safari AND paste to Excel this means FF is broken in it's own private way and you just don't want to make it work.
Status: RESOLVED → UNCONFIRMED
Resolution: DUPLICATE → ---
This is still a duplicate; please stop un-marking it as such.
Status: UNCONFIRMED → RESOLVED
Closed: 15 years ago → 15 years ago
Resolution: --- → DUPLICATE
You need to log in
before you can comment on or make changes to this bug.
Description
•