Jump to content

What happened with the pasting of spreadsheets?


Recommended Posts

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.

Link to comment
  • Level 5*
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

Link to comment
  • 4 months later...

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. 

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...