undefined | Better HN

0 pointswlesieutre1y ago0 comments

I still haven’t figured out how to export a copy of an excel sheet to csv without that csv becoming the document I have open afterward, and having to close it and reopen the xlsx file.

(note: desktop Excel 2016)

There's an "Export" section in the awkward full-window UI that they replaced the File menu with, but instead of exporting it's just another way around to add extra clicks (File -> Export -> Change File Type -> CSV -> Save As) and get to the same "Save As" dialog that makes the CSV file take over your window as the active file after you "export" it.

You can also get to that via Save As -> Browse and pick CSV in the "save as type" dropdown, which behaves how you expect Save As to work (where that copy should stay active in the window afterward, as opposed to Export where it shouldn't). But this spot is also stupid because now have to go File -> Save As -> Browse because somebody at Microsoft wanted to insert an extra page where they could default your location to OneDrive and make you click Browse to get a normal file browser.

I saw an article yesterday about how Microsoft is moving toward "user-centric design" and removing ads from Skype, but how about doing that in the products anybody gives a shit about?

0 comments

wlesieutreOP1y ago

Dumb as it is, the quickest way to get a CSV export is probably to make a new document and copy/paste the contents of the sheet into it, then save as CSV and close

j / k navigate · click thread line to collapse

0 pointswlesieutre1y ago0 comments

I still haven’t figured out how to export a copy of an excel sheet to csv without that csv becoming the document I have open afterward, and having to close it and reopen the xlsx file.

(note: desktop Excel 2016)

I saw an article yesterday about how Microsoft is moving toward "user-centric design" and removing ads from Skype, but how about doing that in the products anybody gives a shit about?