Menu
17 years ago Hi, When you select and copy a table in Mozilla 9.9 and then paste it into MS Excel 2000, it all appears in one cell as plain text. However, if you first paste it into composer and then copy and paste into Excel 2000, it pastes correctly as a table into cells. This problem doesn't occur in Excel 97. For company intranets, its quite common for staff to pull out query results in html tables and copy and paste into excel.
This occurs on a Mac with macOS High Sierra beta and Excel 2016 for Mac Insider's Fast update. This should be resolved when the next Insider's Fast update is released. As a workaround, you can uninstall the Excel 2016 for Mac Insider Fast version and install the production version of Excel on your Mac. Question: Q: Paste table into Mail from Excel If I copy a small portion of a spreadsheet and paste into Mail it appears to the recipient as a single column. I know that I can Save As 'Text (tab delimited)' in Excel, and copy and paste the table portion correctly formatted into Mail.
Off topic - it would be a really great feature to be able to select and copy specific columns in navigator rather than just rows. Eg right click-select column as you can in composer. 17 years ago Created example of pasting problem I tried your example. When I 'Select All' and copy the whole page it does go into cells fine.
However the problem occurs if I select just the table, or just specific rows of the table (see attachment). It then pastes into only one cell (this happens whether I choose 'paste' or 'paste special'-html. Thanks for the tip on using Ctrl-Drag to select a column. I think the Table Select context menu in composer is very good though, and might be a nice option to add to the context menu of a table in navigator as well. Thanks for your help. 17 years ago to DOM to Text conversion. Note the following from: 'In IE, when you select the contents of a table and paste into another document, the cell row contents are separated with a tab.
![Mac not recognizing usb Mac not recognizing usb](https://images.tips.net/S22/Figs/T6258F1.png)
In Mozilla the cell row contents are separated with a space (I'm using Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-US; rv:1.2b) Gecko/20021009). 'The IE behavior is rather nice because when you are pasting data from an html table into a spreadsheet each cell from the html table ends up in a separate cell in the spreadsheet, the Mozilla behavior is less useful.everything ends up in the first column.' 16 years ago I think this is because when you select table contents in Mozilla and copy/paste it the receiver get: cell 1cell2.
There should probably be some and to make everyone happy. The patch in 173388 inserts TABs between cells and that make it possible to, in Excel, select 'Paste Special.' From the Edit menu and then select Unicode text, but that is probably to odd for most people to find out. I don't think this bug is in the right category, but I don't know which component is responsible for creating html from a user selection when copying.
Hi, I have a user that is working on a Vista Terminal Server with Excel 2010 on it. The user will copy a large amount of data in Excel 2010 and try to paste it into Excel 2010 on his local machine being Win 7 and Excel 2010. Sometimes it works, for example if the terminal server has just been rebooted, but then most of the time Excel locks up and throws this error 'Microsoft Excel cannot paste the data'. Has anyone ever had this problem and if so, have an answer for the problem?
Anyone have any suggestions? Could it possibly be the clipboard? Any help is greatly appreciated. I was having the same 'cannot paste' problem. I was combining large amounts data from different sheets into one sheet. When I tried to copy 59000 rows into the sheet I started to get the error. I discovered that I was copying into an XLS excel sheet in compatibility mode.
The problem is that using an xls sheet means that you have 65536 row maximum. I was trying to paste more rows into the sheet than is allowed. What I did was make sure to create a new worksheet(xlsx) and I copied in all the data I wanted with no problem. XLSX has up to a 1 million rows so you should be ok. I had a similar 'Excel cannot paste the data' issue, but mine was with copying cells from one workbook to another on the same machine. This was between two instances of Excel. It turns out pasting from one to the other copied all the Normal cell styles from one workbook to the other (I am assuming if the 'Normal' cell style from the source workbook doesn't match the destination workbook's Excel creates a copy on the destination one).
![Excel Excel](https://www.howtogeek.com/wp-content/uploads/2010/09/options-window.png)
As you copy back and forth the destination and source workbooks' style list grows exponentially. By the end of it, there were thousands of 'Normal 1', 'Normal 1 2' etc. Styles that needed to be deleted else they'd be copied from one to the other. Since Excel maxes out at 65,000 styles, once you get over 32,500 styles copying would ruin you if it tried to move all those styles.
I ended up running a macro that deleted all but the built-in styles and that resolved my problem. Macro is below.
Sub StyleKill Dim styT As Style Dim intRet As Integer On Error Resume Next For Each styT In ActiveWorkbook.Styles If Not styT.BuiltIn Then If styT.Name &.