To add my own anecdote, I've needed to use a lot of spreadsheets the last couple weeks and quickly became annoyed that different cells could have different fonts (which would sometimes happen when I was pasting in data). Of course I quickly learned to just paste in everything unformatted, but I thought to myself "why would anyone want to set fonts per cell?" I guess I just don't get out enough.
I hate it so much... some programs are even worse, they don't take ctrl shift v to get rid of the garbage. I've made it a habit to first paste stuff in a text editor, copy it again, and then paste it into programs like outlook so the formatting won't be all messed up...
Still don't know of a single case where the "feature" was useful.
Paste with source formatting or theme, I can't recall the exact name right now, rules. It means being able to mooch slides from any file and use them with no real fuss.
An alternative is to turn the slide into a bitmap.
I’ve wondered about it for years; why is the ‘paste’ command not ‘paste without style’ by default? A system level option to change this would be a vast improvement.
I’ve seen all sorts of gross workarounds. The URL bar is my go to these days, mainly because that works on mobile.
I think you are in good company. I’ve used excel extensively, and I’ve never even conceived of that number of fonts specifically being needed. Let alone breaking excel on fonts.