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. Links 30/4/2017: Linux 4.11 Ready Shortly, Unreal Engine 4.16 Preview, Kirigami 2.1 is Out

    Links for the day



  2. High Courts in the United States Still Neither Grappling/Interfering With PTAB Nor Overturning <em>Alice</em>

    In spite of unprecedented pressure from Watchtroll, Dennis Crouch and other prominent elements of the patent microcosm in the United States, software patents continue to enjoy no backing from the courts while the Patent Trial and Appeal Board (PTAB) accelerates its crackdown on such patents



  3. Hailo and Qualcomm Both Want to Profit From Software Patents Rather Than Actual Products

    The (mis)use of software patents for "easy money" is being challenged and it does not look particularly encouraging to those who rely on such patents in 2017



  4. “Spectator” and “The Patent Scam” (New Site/Movie) Tackle the Patent Trolls Epidemic

    The mainstream criticism of patent trolls, culminating even in movies like "The Patent Scam" and others, might be enough to sway public opinion on the subject



  5. Unified Patent Propaganda Courtesy of a Cabal of Firms That Constructed the UPC

    The Unified Patent Court (UPC), a proposed patent litigation system which would harm European industry for the benefit of law firms and their largest clients (abroad), is only being boosted by few selfish and patently dishonest stakeholders, including/enjoying the EPO's massive PR/lobbying budget (FTI Consulting)



  6. Twitter Shadowbans Critics of the EPO Now?

    Criticise the EPO's European Inventor Award 2017 (in a way that becomes visible), get shadowbanned by Twitter (rendering this criticism invisible)



  7. RecogniCorp v Nintendo is Another Nail in the Coffin of Software Patents in the United States

    A precedential new decision against software patents is terrible news for the patent microcosm -- something for them to spin or moan about for a long time to come



  8. Battistelli is Busy Securing the Vote of Countries Whose Support and Tickets Are Easy to 'Buy'

    Battistelli’s banana republic politics and tricks are viewed as his ticket to endless ‘leadership’ (domination by sheer force) of a sinking patent office, whose rules he repeatedly breaks (including lack of eligibility to run it, for multiple reasons)



  9. Patent Snake Oil From Brunel University London and PatentDive

    The ludicrous notion of replacing patent examiners (or searches by humans) with machines is seriously considered by some who should know better... but don't



  10. This is How 'Independent' the Boards of Appeal Are Under Battistelli

    A rather revealing new factoid about the interview that never happened (potentially contradicting a previous one with Battistelli), or why it did not happen



  11. Links 29/4/2017: Endless OS, Pinebook, and New Mozilla Foundation Board Members

    Links for the day



  12. Links 28/4/2017: Subsurface 4.6.4, GNOME Shell & Mutter 3.25.1

    Links for the day



  13. Kather Augenstein and Bristows Shift Attention to Germany in an Effort to Ram the Dying UPC Down Everyone's Throats

    Down the throat, hopes Team UPC, the Unitary Patent system will go, even though Britain cannot ratify, throwing the whole thing into grave uncertainty



  14. United for Patent Reform Defends USPTO Director Michelle Lee From Attacks by the Patent Microcosm

    Michelle Lee is finally (if not belatedly) shielded by a bunch of large technology companies; The deep-pocketed industry finally steps in line with our position, which is usually when things turn out the way we advocate for



  15. Team UPC and CIPA Are Lobbying, Publishing Puff Pieces, and Rewriting the Law for Unitary Patent (UPC) Behind Closed Doors

    A collection of the latest news and views on the UPC, which is being lied about by those who stand to benefit from it and is probably going nowhere because Brexit means that the UK stays out, in which case it must be reset and pertinent ratifications done all over again



  16. China's Suffering From Patent Maximalism Has Europe Forewarned

    The parasitic elements inside China -- those that just want lots of litigation (even if from patent trolls) -- are winning over, much to the detriment of the Chinese economy, and Team UPC threatens to do the same in Europe with help from Battistelli



  17. Links 27/4/2017: Mesa 17.0.5 RC1, Git 2.13.0 RC1, and Linkerd 1.0

    Links for the day



  18. The Latest Expensive PR Blitz of the EPO, Led by Jana Mittermaier and Rainer Osterwalder Under the 'European Inventor Award' Banner

    The PR agencies of the Corsican in Chief, who appears to be buying political support rather than earning any, are very busy this week, as yet another reputation laundering campaign kicks off



  19. Links 26/4/2017: SMPlayer 17.4.2, Libreboot Wants to Rejoin GNU

    Links for the day



  20. PatentShield is Not the Solution and It Won't Protect Google/Android From Patent Trolls Like Microsoft's

    A new initiative called "PatentShield" is launched, but it's yet another one of those many initiatives (Peer-to-Patent and the likes of it, LOT Network, OIN, PAX etc.) that serve to distract from the real and much simpler solutions



  21. Patent Quality Crisis and Unprecedented Trouble at the European Patent Office (EPO) Negatively Affect Legitimate Companies in the US As Well

    The granting en masse of questionable patents by the EPO (patent maximalism) is becoming a liability and growing risk to companies which operate not only in Europe but also elsewhere



  22. Blog 'Takeovers' by Bristows and Then Censorship: Now This Firm Lies About the Unitary Patent (UPC) and Then Deletes Comments That Point Out the Errors

    Not only are Bristows employees grabbing the mic in various high-profile IP blogs for the purpose of UPC promotion (by distortion of facts); they also actively suppress critics of the UPC



  23. Links 25/4/2017: Kali Linux 2017.1 Released, NSA Back Doors in Windows Cause Chaos

    Links for the day



  24. Astoundingly, IP Kat Has Become a Leading Source of UPC and Battistelli Propaganda

    The pro-UPC outlets, which enjoy EPO budget (i.e. stakeholders' money), are becoming mere amplifiers of Benoît Battistelli and his right-hand UPC woman Margot Fröhlinger, irrespective of actual facts



  25. EPO Fiasco to be Discussed in German Local Authority (Bavarian Parliament) Some Time Today as the Institution Continues Its Avoidable Collapse

    Conflict between management and staff -- a result of truly destructive strategies and violations of the law by Benoît Battistelli -- continues to escalate and threatens to altogether dismantle the European Patent Office (EPO)



  26. In the US and Elsewhere, Qualcomm's Software Patents Are a Significant Tax Everyone Must Pay

    The state of the mobile market when companies such as Qualcomm, which don't really produce anything, take a large piece of the revenue pie



  27. In South Asia, Old Myths to Promote Patent Maximalism, Courtesy of the Patent Microcosm

    The latest example of software patents advocacy and patent 'parades' in India, as well as something from IPOS in Singapore



  28. Links 24/4/2017: Linux 4.11 RC8, MPV 0.25

    Links for the day



  29. Why Authorities in the Netherlands Need to Strip the EPO of Immunity and Investigate Fire Safety Violations

    How intimidation and crackdown on the staff representatives at the EPO may have led to lack of awareness (and action) about lack of compliance with fire safety standards



  30. Insensitivity at the EPO’s Management – Part IX: Testament to the Fear of an Autocratic Regime

    A return to the crucial observation and a reminder of the fact that at the EPO it takes great courage to say the truth nowadays


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