What happened with the pasting of spreadsheets?

[kfreels 31]

For a long time I could copy the cells in an excel spreadsheet and paste them into a note and it looked pretty much mostly like the spreadsheet. It kept the cells, the lines, and even the colors.

Now when I go to paste the same thing from the same file, instead I get just plain text. Formatted scrunched up and otherwise a mess.

This is annoying. Why do I want to do this? I keep the spreedsheet embedded in the note so I can open it in excel and edit it as needed IF I HAVE TIME TO DO ALL OF THAT.

But often I just want to glance at it to look at something. Account numbers, phone numbers, business prospects, etc. So basically while at the PC I will open the spreadsheet itself, do any edits, save it, and copy the cells and paste them into the note as well for quick reference on my phone when needed rather than having to launch excel for a quick piece of information.

[DTLow 5,749]

20 minutes ago, kfreels said:

For a long time I could copy the cells in an excel spreadsheet and paste them into a note and it looked pretty much mostly like the spreadsheet. It kept the cells, the lines, and even the colors.

I'm on a Mac with ancient versions of Word & Excel; I have the same problem

Excel > Evernote does not preserve the table format

I noticed   Word > Evernote does preserve the table format

My workaround is to use Word as an in between step
Excel > Word > Evernote    the table format is preserved

[kfreels 31]

Thanks for the tip. I tried this and it does work somewhat. But the pasted portion is cut off on the right and I have to click the + sign in the top left to make it wider although there is plenty of room to the right. If I copy an extra column on the right, paste into word, copy from word, and paste into evernote, then it looks right. Bizarre way to go about it. A real PITA that doesn't need to be there. But hey, thanks for finding a workaround. 

Since then it's gotten a little better I think. Hard to be certain. I just don't get why the change was made in the first place. Before, I could paste cells from excel with no problem. Now I do so but I lose a lot of formatting and the colors.