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. French Politician Richard Yung Tells the Government About Abuses at the European Patent Office (EPO)

    The subject of EPO scandals has once again landed in French politics, just a couple of months since it last happened



  2. The Sickness of the EPO – Part II: Background Information and Insights

    With a privatised, in-house (sometimes outsourced and for-profit) force for surveillance, policing, justice, public relations and now medical assessment (mere vassals or marionettes of the management) the EPO serves to show that it has become indistinguishable from North Korea, where the Supreme Leader gets to control every single aspect (absolutely no separation of powers)



  3. EPO Cartoon/Caricature by KrewinkelKrijst

    A new rendition by Dutch cartoonist and illustrator KrewinkelKrijst



  4. Inverting Narratives: IAM 'Magazine' Paints Massive Patent Bully Microsoft (Preying on the Weak) as a Defender of the Powerless

    Selective coverage and deliberate misinterpretation of Microsoft's tactics (patent settlement under threat, disguised as "pre-installation of some of the US company’s software products") as seen in IAM almost every week these days



  5. The Sickness of the EPO – Part I: Motivation for New Series of Articles

    An introduction or prelude to a long series of upcoming posts, whose purpose is to show governance by coercion, pressure, retribution and tribalism rather than professional relationship between human beings at the European Patent Office (EPO)



  6. Insensitivity at the EPO’s Management – Part VII: EPO Hypocrisy on Cancer and Lack of Feedback to and From ECPC

    The European Cancer Patient Coalition (ECPC), which calls itself "the largest European cancer patients' umbrella organisation," fails to fulfill its duties, says a source of ours, and the EPO makes things even worse



  7. Links 21/2/2017: KDE Plasma 5.9.2 in Chakra GNU/Linux, pfSense 2.3.3

    Links for the day



  8. EPO Caricature: Battistelli's Wall

    Battistelli's solution to everything at the EPO is exclusion and barriers



  9. The 'New' Microsoft is Still Acting Like a Dangerous Cult in an Effort to Hijack and/or Undermine All Free/Open Source Software

    In an effort to combat any large deployment of non-Microsoft software, the company goes personal and attempts to overthrow even management that is not receptive to Microsoft's agenda



  10. PTAB Petitioned to Help Against Patent Troll InfoGation Corp., Which Goes After Linux/Android OEMs in China

    A new example of software patents against Free software, or trolls against companies that are distributing freedom-respecting software from a country where these patents are not even potent (they don't exist there)



  11. Links 20/2/2017: Linux 4.10, LineageOS Milestone

    Links for the day



  12. No, Doing Mathematical Operations on a Processor Does Not Make Algorithms Patent-Eligible

    Old and familiar tricks -- a method for tricking examiners into the idea that algorithms are actual machines -- are being peddled by Watchtroll again



  13. Paid-for UPC Proponent, IAM 'Magazine', Debunked on UPC Again

    The impact of the corrupted (by EPO money) media goes further than one might expect and even 'borrows' out-of-date news in order to promote the UPC



  14. Lack of Justice in and Around the EPO Drawing Scrutiny

    The status of the EPO as an entity above the law (in Germany, the Netherlands, Switzerland and so on) is becoming the subject of press reports and staff is leaving in large numbers



  15. Links 19/2/2017: GParted 0.28.1, LibreOffice Donations Record

    Links for the day



  16. The EPO is Becoming an Embarrassment to Europe and a Growing Threat to the European Union

    The increasingly pathetic moves by Battistelli and the ever-declining image/status of the EPO (only 0% of polled stakeholders approve Battistelli's management) is causing damage to the reputation of the European Union, even if the EPO is not a European Union organ but an international one



  17. Patent Misconceptions Promoted by the Patent Meta-Industry

    Cherry-picking one's way into the perception of patent eligibility for software and the misguided belief that without patents there will be no innovation



  18. As the United States Shuts Its Door on Low-Quality Patents the Patent Trolls Move to Asia

    Disintegration of Intellectual Ventures (further shrinkage after losing software patents at CAFC), China's massive patent bubble, and Singapore's implicit invitation/facilitation of patent trolls (bubble economy)



  19. Links 17/2/2017: Wine 2.2, New Ubuntu LTS

    Links for the day



  20. Bad Advice From Mintz Levin and Bejin Bieneman PLC Would Have People Believe That Software Patents Are Still Worth Pursuing

    The latest examples of misleading articles which, in spite of the avalanche of software patents in the United States, continue to promote these



  21. Patents Are Not Property, They Are a Monopoly, and They Are Not Owned But Temporarily Granted

    Patent maximalism and distortion of concepts associated with patents tackled again, for terminology is being hijacked by those who turned patents into their "milking cows"



  22. SoftBank Group, New Owner of ARM, Could Potentially Become (in Part) a Patent Troll or an Aggressor Like Qualcomm

    SoftBank grabbed headlines (in the West at least) when it bought ARM, but will it soon grab headlines for going after practicing companies using a bunch of patents that it got from Inventergy, ARM, and beyond?



  23. Technicolor, Having Turned Into a Patent Troll, Attacks Android/Tizen/Linux With Patents in Europe

    Technicolor, which a lot of the media portrayed as a patent troll in previous years (especially after it had sued Apple, HTC and Samsung), is now taking action against Samsung in Europe (Paris, Dusseldorf and Mannheim)



  24. Michelle Lee is Still “in Charge” of the US Patent System

    Contrary to a malicious whispering campaign against Lee (a coup attempt, courtesy of patent maximalists who make a living from mass litigation), she is still in charge of the USPTO



  25. Our Assessment: EPO Wants a Lot of Low-Quality Patents and Low-Paid Staff With UPC (Prosecution Galore)

    The European Patent Office seems to be less interested in examination and more interested in facilitating overzealous prosecution all across Europe and beyond; The Administrative Council has shown no signs that it is interested in profound changes, except those proposed by Battistelli in the face of growing resistance from staff and from ordinary stakeholders



  26. Links 16/2/2017: HITMAN for GNU/Linux, Go 1.8

    Links for the day



  27. Yet More Complaints About the European Patent Office in the Bavarian Regional Government

    Some German politicians do care about the welfare of EPO staff, a lot more so than the EPO's management that is actively crushing this staff



  28. EPO Staff Representatives to Escalate Complaint About Severe Injustices to the EPO's Secretive Board 28

    In a new letter to President Benoît Battistelli it is made abundantly apparent -- however politely -- that Battistelli's gross abuses could further complicate things for Battistelli, who is already embroiled in a fight with his predecessor, Roland Grossenbacher



  29. New Survey Reveals That High Patent Quality, or Elimination of Bad Patents, is Desirable to Patent Holders

    A new survey from Bloomberg BNA and AIPLA reveals that the Patent Trial and Appeal Board (PTAB), which still grows in prominence, is supported by people who have themselves gotten patents (not those who are in the bureaucracy of patents and self-serving politics)



  30. Open Patent Office is Not the Solution; Ending Software Patents is the Solution

    Our remarks about the goals and methods of the newly-established Open Patent Office and what is instead needed in order to combat the menace that threatens software development


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