News for hackers. Stuff that matters.

A comment on The .zip file specification is flawed. Parent comment

Re:The .zip file specification is flawed by alogray on Tuesday December 13, 2016 @07:24PM (#13172687)
IIRC, it was not fixed at release for Excel for Mac 2016 but there is now an option to Save As a "CSV UTF-8 (Comma Separated)".
[ Parent | on HN ]
Re:The .zip file specification is flawed by rspeer on Wednesday December 14, 2016 @01:56AM (#13174329)
That's amazing. Finally.

I don't suppose I should get my hopes up too much that that option is going to be more prominent than the terrible default of saving as Mac OS Roman, right? (Whoever decided that Excel on OS X should export CSVs in an obsolete encoding for Mac OS Classic must have been trying to hurt Mac users.)

[ Parent | on HN ]
Re:The .zip file specification is flawed by fnord123 on Wednesday December 14, 2016 @04:59PM (#13180044)
I tried it out on Office 2016/365/15.25 whatever on OS X. It works when writing data out. That's great news! And they also put it high up in the possible formats to output.

Unfortunately, to open the UTF-8 file again, it doesn't work ("北京市"). You have to make a new workbook and then import the csv in, specifying UTF-8 csv. It's pretty messed up but at least it's possible now.

[ Parent | on HN ]