EditorsAbout the SiteComes vs. MicrosoftUsing This Web SiteSite ArchivesCredibility IndexOOXMLOpenDocumentPatentsNovellNews DigestSite NewsRSS

01.11.07

Proprietary Open XML Extensions (Already!)

Posted in Apple, Deception, ECMA, Formats, Interoperability, Microsoft, Novell, Office Suites, Open XML, OpenDocument, Standard, VBA at 12:03 am by Shane Coyle

As you are likely aware, Excel 2007 includes a new file format for storing data, well actually it has a few new file formats apparently. And, none of them are OpenDocument, in case you were wondering.

Rob Weir takes Office 2007 for a spin, and has some interesting things to report regarding the file formats being used by Excel 2007.

In addition to the default Open XML file format (.xlsx) that has been added to Office 2007, there is also an additional format called the Excel Macro-Enabled Workbook (.xlsxm) which contains binary-only data not specified in the ECMA standard. There is also an all-new binary-only format (.xlsb), which Microsoft says provides "optimal performance and backward compatibility" (wasn’t that the point of Open XML?).

The “Excel Macro-Enabled Workbook” option saves as an “xlsxm” extension. It is OOXML plus proprietary Microsoft extensions. These extensions, in the form of binary blob called vbaProject.bin, represent the source code of the macros. This part of the format is not described in the OOXML specification. It does not appear to be a compiled version of the macro. I could reload the document in Excel and restore the original text of my macro, including whitespace and comments. So source code appears to be stored, but in an opaque format that defied my attempts at deciphering it.

(What’s so hard about storing a macro, guys? It’s frickin’ text. How could you you[sic] screw it up? )

This has some interesting consequences. It is effectively a container for source code that not only requires Office to run it, but requires Office to even read it. So you could have your intellectual property in the form of extensive macros that you have written, and if Microsoft one day decides that your copy of Office is not “genuine” you could effectively be locked out of your own source code.

There is also a method to add in additional file formats for saving to, including PDF and Microsoft’s XPS, but there is no native ODF support yet.

Overall, Rob’s experience was a bit buggy, and there was an incident where trying to save to Open XML prompted a message about incompatible features (so much for backward compatibility, hey try the new binary-only format…).

I wonder how Novell OpenOffice.org’s VBA support is going to handle the new binary information in the macro-enabled workbook? Still better than the next MS Office for Mac, I suppose.

Share this post: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Reddit
  • email
  • Google Bookmarks

If you liked this post, consider subscribing to the RSS feed or join us now at the IRC channels.

Pages that cross-reference this one

5 Comments

  1. Stephane Rodriguez said,

    January 23, 2007 at 12:27 pm

    Gravatar

    I am a new visitor. While I find your blog instructive (subscribed), I’d like to shed some light on a confusion here.

    VBA projects are encoded in bin parts in the new Office 2007 file formats, whether it’s Word, Excel or Powerpoint. Those parts are the actual VBA streams that we find in older versions of the corresponding applications. That’s a direct extraction.

    There are other binary parts, such as printer settings parts and OLE objects parts.

    The new XLSB file format pushes XLSM even further by making the important XML parts encoded in much the same way than BIFF used to do with older versions. Actually, those bin parts are christened as BIFF12. BIFF12 is undocumented right now.

    I have written an article on the subject here :
    http://www.codeproject.com/useritems/office2007bin.asp

  2. Roy Schestowitz said,

    January 23, 2007 at 12:47 pm

    Gravatar

    Thank you for the information, Stephane. For the record, I notice that you are among the Open XML team members:

    http://openxmldeveloper.org/members/Stephane+Rodriguez.aspx

    Also, yesterday’s news indicate that Microsoft pays people to “bring balance” to content which speaks about Open XML. I just hope you are not being paid to post here.

    In any event, your comment does not invalidate the fact that Open XML has undocumented, binary parts.

  3. Stephane Rodriguez said,

    January 23, 2007 at 1:41 pm

    Gravatar

    If you think I may be a paid shill, take a look at this : http://xlsgen.arstdesign.com/special/OOXML_objections.pdf

    (this is on my website)

    The OOXML specs are so bad I had to develop my own tool, called “diffopc”, to make any progress in my product (an Excel file format component which recently added partial support for Excel 2007).

  4. shane said,

    January 23, 2007 at 1:52 pm

    Gravatar

    Thank you, Stephane. We’ve had a huge influx of trolling as of the last few days, and perhaps are a bit on edge. There is no doubt from your first linked article (I didn’t read the pdf yet) that you are well versed in the OOXML spec.

    I love the fact that we do have discussions on the site, and want to encourage further discussion and corrections. I want our arguments to withstand scrutiny, and encourage any readers to question or comment on our premises.

    Let’s all just keep it mature, and there is no reason to post using pseudonyms folks, just type in "anonymous" or "i disagree". I still do not intend to censor any non-spam comments, nor shut down commenting after x number of days on an article, since many are still actively being viewed and linked to.

  5. Michael said,

    September 12, 2007 at 9:10 am

    Gravatar

    Thanks for the nice post!

What Else is New


  1. IRC Proceedings: Thursday, July 09, 2020

    IRC logs for Thursday, July 09, 2020



  2. Racism in Technology (and Who Typically Lectures Us About the Subject)

    Racism is a real problem; some approaches to tackling racism, however, can also be problematic and those who take the lead 'on behalf' of victims tend to be opportunistic and privileged few (piggybacking others' grievances to further advance their financial agenda)



  3. Links 10/7/2020: Debian 8 Long Term Support EOL, Mobian Project, Mesa 20.1.3

    Links for the day



  4. [Humour] COVID-19 is Very, Very Afraid of Human Beings Making More Monopolies Instead of Fighting Together

    The European Patent Office (EPO) to the rescue! Fighting a dangerous pandemic one profitable monopoly at a time!



  5. The News is Never 'Slow', It's Just Journalism That's Slowing Down (and Investigative Journalism Coming Under Attack)

    A mix of censorship and subtle mind control contribute to misinformed societies that shape their perception or misunderstanding of the world based on false measures of authority (where money can determine what is true and what is untrue); many topics remain completely untouched, leading to apathy in a vacuum; it's very much applicable to international organisations, which are presumed benign by virtue of being multi-national or supranational



  6. Social Control Media is About Social Control and If It Doesn't Ban You It'll Shut Down Everyone's Account (One Day)

    It’s time to leave the ‘Internet rot’ which is social control media well behind us; blogging and RSS/XML may seem like a thing of the past, but they may as well become the future (again; if we make the correct and informed choices)



  7. Microsoft's Fingers in Every Pie: The Cult Mentality That Society Needs to Become Wary of

    Microsoft and its co-founder (pretending to do his for-profit 'charity' via the Gates Foundation) are trying to control the world; in the process they've moved to control even their most potent competitor, according to Gates himself, which is GNU/Linux



  8. Links 9/7/2020: Google’s Open Usage Commons, GNOME 3.36.4, Neptune 6.5

    Links for the day



  9. IRC Proceedings: Wednesday, July 08, 2020

    IRC logs for Wednesday, July 08, 2020



  10. Links 8/7/2020: SUSE to Acquire Rancher Labs, Btrfs as Default in Fedora, Qt Creator 4.12.4

    Links for the day



  11. Yes, Master

    When the Linux Foundation tells us to tone down our language we ought to remember what kind of hypocritical stance these people have (note: the above have nothing to do with slavery, either)



  12. Fraunhofer is Again Evergreening Software Patents to Maintain Its Codecs Cartel, Forcing Everyone to Pay to View/Stream Multimedia Files

    The roller-coaster of software patents on multimedia isn't stopping; we know the culprits who can be named for perpetuating this injustice



  13. [Humour/Meme] Focusing on the Bombings and Who's Included in the Bombings

    Supremacist agenda disguised as "tolerant and inclusive" is still objectionable supremacist agenda



  14. Manners Are a Good Thing. The Yardstick or the Standard of Manners Changes Over Time.

    Entirely legitimate grievances of African-Americans are being exploited by people who aren’t even African-American (and usually don’t speak for African-Americans) to warp the debate from one about software ethics and technical issues, not to mention war crimes of companies that employ many programmers, to something which is unlikely to really help African-Americans (also, they don't employ any African-Americans)



  15. IRC Proceedings: Tuesday, July 07, 2020

    IRC logs for Tuesday, July 07, 2020



  16. Links 8/7/2020: Huawei’s GNU/Linux PC, Sparky 5.12, and Endless OS 3.8.4 Released

    Links for the day



  17. [Humour] Television Channels That Don't Speak of Real Looting But Participate in Looting

    People may need to look beyond (or outside) the television screen to grasp what's going on



  18. (Software) Freedom is Elusive Without the Ability to Concentrate

    Software is consuming people's minds; to make matters worse, people have become so attached to such software that they're unable to see it and get away from it (they associate that software with "social life")



  19. Monopolies Erode Freedom, Freedom Erodes Monopolies

    "There are so many reasons that GitHub makes projects less free."



  20. Links 7/7/2020: NomadBSD 1.3.2, Clonezilla Live 2.6.7 and DRM Comes to Cars

    Links for the day



  21. [Humour] IAM Ranked Top for Quality of EPO Propaganda

    Contrary to what the European Patent Office (EPO) keeps saying, patent quality is slipping very fast in Europe (based on the EPO's own analysis!) but patent trolls-funded publishers deny that



  22. When They're Done With Patents on Foods and Recipes They'll Have Patents on Fashion, Taste and Smell

    The mental dysfunction — an infectious condition — that says everything in the world must be patented should be resisted; it overlooks the fact that patents were introduced to protect/promote actual invention, not thoughts, feelings, nature and art



  23. [Humour/Meme] IBM's Money is Unhealthy to the Free Software Foundation (FSF)

    IBM will never be happy as long as RMS (Richard Stallman) has a say in the FSF — directly or indirectly — or even in the GNU Project, both of which he himself created back when IBM was the biggest monopolist



  24. IRC Proceedings: Monday, July 06, 2020

    IRC logs for Monday, July 06, 2020



  25. Never Let IBM/Red Hat Lecture Us on Morality

    Ethics and morality should not be taught by those who themselves need a lesson; in the meantime we're losing the courage to speak freely and those who commit atrocious acts like it a lot better that way



  26. [Humour/Meme] Wear the Red Hat as the Open Org Becomes Openwash

    IBM is changing Red Hat and not for the better; sooner or later IBM will become another Microsoft and changing from one to the other will be like swapping 'masters'



  27. IBM is Imposing Non-Free, Privacy-Infringing Tools and Patent Tolls on Red Hat Staff

    There are signs that Red Hat under IBM will be more like assimilation to IBM, not IBM assimilating to the 'Red Hat way' or the so-called 'open org'



  28. They Tell the Free Software Community That It is Racist While Saying Nothing at All About Trump's Racism (Because He Gives Them Government and Military Contracts)

    While their president compares 'foreign' people to a virus (using innuendo, dog whistles and racist rhetoric reminiscent of the Nazi era) the big US corporations (American surveillance giants) turn their attention to rather innocuous words inside people's code (which almost nobody sees anyway)



  29. LibreOffice 'Personal Edition' Seems Like a Marketing and Communication Fluke

    Had LibreOffice developers (and the Document Foundation) communicated these changes more openly, they would have averted/avoided some of the FUD



  30. It Almost Feels Like Microsoft Has Already 'Bought' Canonical

    Canonical's disturbing trajectory and betrayal of the community continue unabated; one can easily get the impression that Ubuntu exists to help Microsoft at some level


RSS 64x64RSS Feed: subscribe to the RSS feed for regular updates

Home iconSite Wiki: You can improve this site by helping the extension of the site's content

Home iconSite Home: Background about the site and some key features in the front page

Chat iconIRC Channel: Come and chat with us in real time

Recent Posts