News for hackers. Stuff that matters.
Re:Excel will allow certain auto data conversions to be turn... by TMWNN on Monday October 23, 2023 @03:14AM (#37982457)
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.
Re:Excel will allow certain auto data conversions to be turn... by hypercube33 on Monday October 23, 2023 @03:27AM (#37982533)
I just want it to auto size cols when I paste data instead of rows
Re:Excel will allow certain auto data conversions to be turn... by rwmj on Monday October 23, 2023 @06:05AM (#37983613)
I'd like the scrollbar to work sensibly, and not race ahead uncontrollably to show me the hundreds of empty rows below the spreadsheet.
Re:Excel will allow certain auto data conversions to be turn... by vegetable on Monday October 23, 2023 @09:22AM (#37985213)
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.