Remember the Approval Process for OOXML?
Rupert wrote:
"That means the tooling wrapped around the spec has to account for proprietary dependencies that get smuggled in, such as fonts. It also means actively and continuously tracking the ground truth of Microsoft's evolving products and services."
It's worth noting a little bit of the history around the adoption of OOXML and it's acceptance by ECMA and the more heated battles when it became the ISO/IE 29500 Standard in 2008.
In September 2005, the Commonwealth of Massachusetts announced that it would migrate all documents to an open document standard (specifically declaring the intent to move to ODF). Microsoft had been flat-out refusing requests from large customers to do this - and they reversed course just weeks after the Commonwealth made their policy announcement.
Microsoft responded by writing OOXML as a "Standard" ... and depending on which version you consider, the resultant specification spans between 6,000 and 7,229 pages. By comparison, ODF 1.4 covers a total of 1,057 pages, split across 4 discrete parts:-
Part 1 - Introduction (8 Pages)
Part 2 - Packages (34 Pages)
Part 3 - Schema (802 Pages)
Part 4 - Recalculated Formula (213 Pages)
Within the OOXML Standard itself there are many "BLOB" structures, which Microsoft initially claimed were required to support legacy file formats and structures from older versions of their Office products, but which experience has shown actually build reliance (lock-in) on native Windows-specific API elements, system-level font-metrics and graphic-rendering logic (such as GDI coordinates, for example).
None of this is by accident - Microsoft produced something that was a "standard in name only" and then seemed to have relied upon the creation of a document specification that spanned 7,000 pages in order to bamboozle reviewers and obfuscate that what they had done was create a lock-in dependency on proprietary API's and rendering logic provided by Windows. Microsoft did the exact same thing when governments demanded that Internet Explorer be split from Windows - they simply moved the browser's logic in to OS-level DLLs as API calls and claimed that the browser was thus inseperable from the OS.
However, there's a deeper concern hidden in those 7,000 pages of weeds... and it concerns integrated macro logic. Unless you're doing something very (*very*) simplistic with your office suite, your spreadsheet is going to include more complex structures, including formulae, graphs, macros and charts. These have proven to be a minefield for portability, because Microsoft didn't even pretend to support these outside those proprietary BLOBs - and the relevant Standards Committees turned a blind eye. Translation of VBA, in particular, seems to still be a struggle [if attempted at all] and that might be the reason why there is no real alternative to Access. The closest still seems to be LibreOffice Base, but that product can't handle the forms or macros written in Access.
Only one thing is going to change this - which is for a nation somewhere to have national government agencies standardize on LibreOffice.
Do you remember what happened when Munich, Germany made the declaration that they would move approx 15,000 municipal desktop PCs to Debian and OpenOffice? It started out so well:-
https://www.omgubuntu.co.uk/2014/07/munich-city-saves-millions-going-open-source
Then Microsoft went on the offensive:-
https://www.omgubuntu.co.uk/2014/08/munich-city-linux-switching-back-windows
What is less obvious from the historic record about the goings-on with Munich is the way that Microsoft played dirty [because they could afford to]. So, for example, when it became apparent that Munich might be the first domino to fall, they immediately announced plans to relocate their German HQ to Munich - and completed that within 2 years. Just a coincidence, nothing to worry about.
That history is going to rinse-repeat unless or until a much stronger insistence on a 100% open and transparent standard is set and enforced. Which is a tall order, especially given macros and Access and the current lack of equivalence in the open source world.
On the other hand, the sophistication and polish of the FOSS ecosystem has transformed beyond all recognition over the last 10 years. Over the same time period, the only significant change from Microsoft is that their products have become more bloated and slower, making them more expensive to run.
Maybe the time is right for a lean, clean competitor to come in and shake things up - as long as there is a 100% level playing field, that is.