This is the second in a series of screen-casts that will show all the ins and outs of SpreadsheetML. My goal is to present all of the most commonly used features of spreadsheets and how they are represented in SpreadsheetML. I will not be including any code examples in this series, but many of my other blog posts contain detailed code examples.
Return to the Table of Contents of this screen-cast series. If you are not that familiar with the Open Packaging Conventions (OPC), then you may want to take a look at Eric White's two-part series (Part 1 and Part 2). Eric also has some excellent screen-casts that explain how to find and use Open XML development tools that I use in this screen-cast. In particular, the Open XMLPackage Editor Power Tool for Visual Studio is invaluable.
In this second part, I look at the representation of formulas for cells, conditional formatting and data validations.