Ok, this used to work.
The old behavior when pasting it would past as an image. Not bad if you didnt care about the pixelization.
you could create a single cell table, click into that table then paste data from Excel. When doing this, it would paste the formatting and then show just fine when backing out to the normal work space.
It will not paste an image when coping from Excel. It will just past a table. When clicking into this table it will show the same formatting as excel, background colors, etc. But, when backing out it does not show any of this formatting, just black text. Click back into the table and it will show it, back out and it’s gone again.
WTF!!! How do I make it show the formatting? Also, WHY!!! Why you guys keep changing things and not giving us options to revert back to the old way of doing it. So frustrating!!1
Please tell me how to get formatting back!