Indeed. Every time I opened a .csv and had Excel courteously convert all UPCs into scientific notation, I wondered "Who would ever want that to happen?" Finally there is a way to avoid this.

I just want it to auto size cols when I paste data instead of rows

I'd like the scrollbar to work sensibly, and not race ahead uncontrollably to show me the hundreds of empty rows below the spreadsheet.

Import CSVs into excel; don't double click to open. Been telling this to colleagues since excel 2007 days; still have never managed to get anyone to follow this advice.

It's not really fixed at all.