At last I have put together an example that shows the full range of cell style options available in SpreadsheetML. This example will show how to apply a huge variety of styles using very simple code. The video explains how to use the code and also how...

When sending a presentation to customers or others outside of your organization, you often want to remove speaker notes. It is easy enough to use PowerPoint automation to remove the speaker notes , but if you are processing presentations server-side,...

Eric and I have created a version of PowerTools that includes only the core code, without the cmdlet code. The C# project also includes several examples of how to use the core code from a C# program. You can get this project from the PowerTools CodePlex...

This will probably be the final installment of this series. In this example, I complete the pivot table creation process by configuring the fields that will appear in the rows, columns, filters and data values. This example builds upon the earlier examples...

For the last couple of months, I have been exploring the contents of formulas in SpreadsheetML. Formulas can include functions, cell ranges, external references, references to other sheets in the same workbook, and a variety of operators. In fact, formulas...

I recently received a question about the use of the glossary document. In a nutshell, in DOCX, it is used for the placeholder text for content controls. In DOTX, it is used for the content for quick parts. The following 3 minute video demonstrates these...

One of the interesting characteristics of LINQ to XML as implemented in the .NET framework is that it uses atomized XNamespace and XName objects, and this means that LINQ to XML has very good performance for many common scenarios. The Ltxml.js library...

In Memory of Jim Durkin Jim Durkin was a highly valued member of our team at Microsoft and the owner of Open XML marketing for Microsoft. While a member of the team for a short time, he was instrumental in making some significant strides with Open XML...

Sometimes you need to calculate the cell sizes (in pixels) exactly in an Open XML spreadsheet. The most common use case is when placing graphics on a worksheet. You also need cell sizes in pixels when placing controls. In addition, understanding exactly...

This screen-cast continues the introduction to WordprocessingML, introducing annotations, which include comments, bookmarks, proofing errors, range permissions, and revision tracking markup. The screen-cast contains some best-practice pointers for each...

In an earlier screen-cast, I discussed some utility methods and classes in PowerTools for Open XML that are not specific to Open XML. They are useful to anyone doing functional programming (or even object-oriented programming). In this screen-cast, I...

This is the ninth screen-cast in a series on writing Recursive Pure Functional Transformations of XML. This screen-cast and the next screen-cast discuss the semantics of XML in detail. In order to discuss recursive pure functional transformations, it...

This is the tenth screen-cast in a series on writing Recursive Pure Functional Transformations of XML. This screen-cast and the previous screen-cast discuss the semantics of XML in detail. In order to discuss recursive pure functional transformations...

On June 20, 2011 (two days ago), I posted an update to DocumentBuilder . After more extensive testing, I found and fixed a few bugs in less common scenarios, including if comments in multiple sources contain images, multiple sources contain endnotes with...

This is the eleventh screen-cast in a series on writing Recursive Pure Functional Transformations of XML. This screen-cast and the following two screen-casts discuss the semantics of LINQ to XML in detail. We are going to make use of some interesting...