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 1/7/2016: New PCLinuxOS Magazine, Mageia 6 Close to Release

    Links for the day



  2. Ignoring the Bascom Hype and the Federal Circuit's Built-in Bias, Software Patents Still Dying in US Courts

    The trend which suggests software patents fade away in the United States, in spite of all the lobbying, remains largely uninterfered



  3. Battistelli's Destructive Actions Will Drive EPO Applicants Away to National Patent Offices, Putting at Risk the Whole EU-Wide (and Beyond) Project

    Battistelli's regressive policies and extremely bad behaviour increasingly motivate people to avoid the EPO, which serves to reinforce the observation that Battistelli has become an existential risk to the EPO with his huge spendings on self-glorification, militarisation, and dubious secret contracts



  4. As Expected, 'Team UPC' Continues Fighting for Its Project's Survival in Spite of 'Brexit'

    The desperate attempts to race to the bottom with the Unitary Patent Court and Battistelli's misguided effort to reduce patent quality and make up for it with greater patent quantity, in addition to increased fees (to discourage appeals, withdrawals etc.)



  5. Goodbye Halo, Hello Revisionism (or How Patent Profiteers Perfume a Terrible SCOTUS Decision That Helps Patent Trolls)

    A short review/overview of this past week's coverage regarding Halo (the Halo v Pulse case) -- a SCOTUS decision that will help patent trolls in the United States



  6. Realistic English Translation of EPO Announcement About Crushing of Patent Quality

    The EPO's statement which proves Eric Blair (George Orwell) right, carefully rewritten to better explain what Battistelli and his cronies have just done to bring the EPO's status to an all-time low



  7. Great News: The US Supreme Court Shoots Down Software Patents Again

    The outcome of the US Supreme Court refusing to intervene in the Sequenom v Ariosa case -- a case which would have put at risk the strongly-worded Alice and Mayo decisions (SCOTUS level)



  8. No Expectation of the US Patent System Getting Fixed Any Time Soon

    On the agenda of the supposedly 'liberal' side (hawkish and corporatist in practice) there's no reason for Hope of Change and new data suggests that patent practices are gradually ebbing away in the United States



  9. A System in Their Back Pockets: Protecting Large Corporations in High-Profile Patent Cases

    A couple of new examples of patent cases where the bigger company (with deeper pockets) wins, either by injunctions against small companies or by invalidating the patents of smaller companies



  10. The European Patent Organisation's Administrative Council Helps Benoît Battistelli Destroy Patent Quality for the Sake of 'Production'

    In secretive sessions behind closed doors Battistelli and the Administrative Council conspired to send the no-longer-independent boards of appeal to exile, assuring that patent quality will nosedive and make the Office akin to a registration/filing office



  11. At the European Patent Organisation the Administrative Council Does Not Care About Staff

    The Administrative Council (AC) of the European Patent Organisation continues to show carelessness and apathy if not complicity by maintaining a deeply heartless approach and blind support for a President with 0% approval ratings (among polled staff)



  12. Links 1/7/2016: Enlightenment 0.21.0, Peppermint 7, New Mint

    Links for the day



  13. EPO Leak: Administrative Council's Latest Meeting Report (Updated)

    The outcome of the Administrative Council's meeting, where Battistelli managed to avoid earthquakes and basically did just about everything he wanted, reinforcing the perception that there is no oversight



  14. Publicly-Available Information About the Meeting of the EPO's Administrative Council

    The EPO "crisis" -- as Board 28 called it -- lingers on because no substantial steps were taken towards Battistelli's removal from Office for his violation of Office rules (his own rules) among other laws that Eponia perceives itself as exempt from



  15. Battistelli's Last Moves Are Desperate Attempts to Crush the Messenger (SUEPO), Which Will Almost Certainly Backfire on (if Not Fire) Battistelli

    By implicitly declaring a war on those who speak truth to power or those who are associated with perceived truth-tellers, Battistelli reinforces the perception that he is protecting the bad people at all cost (even his very own career)



  16. EPO Staff Representative Jesus Areso Explains the Crisis to the Administrative Council

    An intervention by an EPO Central Staff Committee (CSC) member who is under gag orders from Battistelli's regime and cannot speak about his case, which apparently involves truly severe disciplinary actions for merely helping or contributing to a staff survey (not controlled by and paid for by Battistelli)



  17. Shadows of Alleged Criminality Over the European Patent Office (EPO)

    Cases against Željko Topić, a Vice-President at the European Patent Office, are moving forward in Croatia, where he still faces many criminal charges



  18. You Know That UPC is Quite Likely Dead (at Least in the UK) When Even Baroness Neville-Rolfe Dodges the Question (Updated)

    The UPC appears to be a dead end, much like Battistelli's career, not only in the UK but in Europe as a whole (it has been all along designed with London/England/UK in mind)



  19. Short Report From Today's EPO Protest in Munich

    A few noteworthy points about the staff protest which coincided with the Administrative Council's meeting earlier today in Munich



  20. Growing Consensus Even Among Patent Professionals That UPC is Dying Everywhere If Not Just in the UK

    The UPC continues to sink as more and more people come to grips with the complexity of the current situation, irrespective of what countries other than the UK do next



  21. Battistelli Attacks Not Only His Staff But Also Patents Themselves (Their Quality) and the Legal Legitimacy Surrounding the EPO

    Battistelli's EPO is having not only reputation problems but also staff retention problems, patent quality problems and problems pertaining to perception of fair trials or justice regarding patents



  22. Battistelli is Creating an Atmosphere of Terror at the EPO While Exploiting Terror Attacks to Garner Sympathy

    "As if Laurent were a terrorist, the Office has imposed a house arrest and has forbidden him to enter the EPO premises," according to SUEPO, writing about one of its members at The Hague who is "maliciously accused via a fabricated procedure"



  23. Rumours That EPO President Battistelli Got Sacked to be Replaced by Christoph Ernst Appear to be Baseless

    Dr. Christoph Ernst is claimed to be the successor (interim or permanent) of the notorious Battistelli, but these claims have little or no evidence to support them



  24. Links 29/6/2016: SteamOS 2.83 Beta, Alpine Linux 3.4.1

    Links for the day



  25. The EPO Has Become Battistelli's Circus and the Administrative Council Has Been Reduced to (Illegal) Circus Animals Controlled With 'Treats'

    Battistelli's attack on justice and on the rule of law is debated among insiders who have grown increasingly impatient with the Administrative Council's tolerance of Battistelli and sometimes even Kongstad's amazing complicity



  26. The Latest Lies About the Unitary Patent (UPC) Would Have Us Believe That It's Alive and Well

    How patents-centric sites (some of which are in bed with the EPO) have responded to the 'Brexit' vote and why they're not telling us the truth about the Unitary Patent scam (often created and promoted by the same people who run and/or fund such sites)



  27. EPO Management Bunker: “The Bailiff Who Came to Deliver the Subpoena was Escorted off the Property by Five Security Guards.”

    Battistelli has essentially turned the European Patent Office (EPO) into a barracks, where he continues to enjoy immunity from the rule of law and discourages those who wish to challenge this immunity



  28. Keeping the Guard and Securing Society From Software Patents

    The policies over which Indians and Europeans have kept guard are being 'stolen' by vested interests



  29. Benoît Battistelli Further Weaponises His EPO 'Stasi' With CA/52/16

    A glimpse at what Benoît Battistelli will shortly attempt to do to the EPO, in order to cement his power in the face of growing opposition from many directions



  30. EPO Caricature: Administrative Council Control of Benoît Battistelli

    Another new caricature regarding the President of the European Patent Office (EPO) and lack of effective oversight from the Administrative Council (European Patent Organisation)


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