Last Week on My Mac: Why is it so hard to open a document? (opens in new tab)

Double-clicking a document to open it in its editor is quintessentially Mac, yet for the last nearly 7 years it could result in a bizarre dialog and refusal. Does any of this make sense?