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.
  • Digg
  • del.icio.us
  • Reddit
  • co.mments
  • DZone
  • email
  • Google Bookmarks
  • LinkedIn
  • NewsVine
  • Print
  • Technorati
  • TwitThis
  • Facebook

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. The United Kingdom Should Dump Microsoft For the Sake of National Security

    The UK has issues of Microsoft dependency and Windows viruses; its migration to Free software and GNU/Linux is not fast enough to guard its autonomy in the age of digital imperialism<



  2. CBS Hires Even More Microsoft Staff to Cover Microsoft Matters

    CBS continues to be infested with Microsoft staff past and present (this time Dave Johnson) and the bias in output is quite revealing



  3. Microsoft Has Just Killed Minecraft for GNU/Linux and the Possibility of Free/Open Source Releases

    Persson sells out to Microsoft and lets the abusive monopolist destroy the popular cross-platform game that a community has been built around



  4. Another Reason to Boycott Intel UEFI

    More anti-competitive aspects are revealed inside UEFI, which helps merginalise GNU/Linux



  5. Quick Mention: Novell and SUSE Passed to Microsoft's 'Partner of the Year', Microsoft Focus

    Novell is changing hands again, and falling into the hands of even more Microsoft-friendly actors



  6. Links 16/9/2014: Linux 3.17 RC5, KDE Frameworks 5.2.0

    Links for the day



  7. Željko Topić, Benoît Battistelli, and the European Patent Office (EPO): Part II

    Part II of our look into the EPO appointment of Željko Topić and other matters showing the dubious integrity of the EPO



  8. Links 14/9/2014: Android-based Watches Earn Optimism

    Links for the day



  9. Links 14/9/2014: Eucalyptus Devoured

    Links for the day



  10. Links 11/9/2014: Linux Toilet Project, Linux-Based Wheelchair Project

    Links for the day



  11. Links 10/9/2014: Brian Stevens in Google, Ubuntu 14.10 Expectations

    Links for the day



  12. Links 9/9/2014: Hating/Loving Linux, Android Aplenty

    Links for the day



  13. Links 8/9/2014: Linux 3.17 RC 4, Switzerland Welcoming Snowden

    Links for the day



  14. Suspicion of High-Level Corruption at the European Patent Office (EPO): Part I

    The European Patent Office (EPO) Vice-President has a background of corruption and his appointment to the EPO too is believed to be reliant on systemic corruption



  15. Links 6/9/2014: Core OS at DigitalOcean, Women in Xorg

    Links for the day



  16. Software Patents 'Quality' Debated in Courts, Microsoft's Biggest Patent Troll Still a Chronic Liar

    Intellectual Ventures, Microsoft's and Bill Gates' largest patent proxy, continues to spread lies about its motivations, claiming that patent assessment is among the goals when in fact only the courts and patent offices do this



  17. New Article Explains How Bill Gates Prevents Schools From Moving to GNU/Linux and Free Software

    A new article from Al Jazeera provides details about the role of so-called 'charities' of billionaires inside school systems



  18. Microsoft Sued for Large-scale Copyright Abuses

    Microsoft reveals its disregard for copyright law which it loves so much to wield as a weapon against its competition and clients



  19. Links 5/9/2014: New WordPress, Systemd Debate Continues

    Links for the day



  20. 'Embrace and Extend' at Microsoft: The New Generation

    Some of the latest examples of Microsoft's predatory acts against Free software and against competition in general, disguised as acts of friendliness



  21. Bill Gates' God Complex: Common Core a One-Man Campaign of Greed and Control

    The push for Common Core is overwhelmingly dominated by Bill Gates, who intimidates and even resorts to retribution against critics while bribing those who help him accomplish the goal of privatised (for his private profit) indoctrination in US schools



  22. Bill Gates Investments Harm the World, Not Improve the World, Based on New Exclusive Piece of Investigative Journalism at The Nation

    The Gates Foundation's profiteering efforts and lack of ethics outlined in a new report that many sites around the Web find fascinating and mostly irrefutable



  23. Links 3/9/2014: Android Gadgets, New Tails OS

    Links for the day



  24. Linus Torvalds DebConf Talk

    Torvalds' latest talk which got media attention earlier this month



  25. Microsoft Should Not be Considered Too Big to Jail

    Microsoft continues to use dumping as a strategy which revolves around starving the competition, not beating the competition



  26. Pro-Software Patents Voices Finally Acknowledge the Demise of Software Patents in the United States

    A milestone is reached as even the most zealous supporters of patents on algorithms (or computer-implemented inventions, or software patents) are admitting that the era of software patents may be over



  27. New Lies About Microsoft 'Privacy' and New FUD Against the GPL Comes From 'Former' Microsoft Staff at Black Duck

    More AstroTurfing by sites that are run by Microsoft MVPs and firms which were created by people from Microsoft



  28. Links 2/9/2014: GNU/Linux in BBC, Calls Against systemd

    Links for the day



  29. Links 1/9/2014: Poettering on systemd, ITNews on DBMSs

    Links for the day



  30. Moving Away From Windows to GNU/Linux and the Abandonment of Windows as the Modest Proposal These Days

    Morale of GNU/Linux and an embrace of GNU/Linux is very high, despite recent propaganda from Microsoft MVPs and boosters (primarily security-themed and Munich-themed FUD)


CoPilotCo

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

CoPilotCo

Recent Posts