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 how column widths and row heights work can help when
generating spreadsheets. You can create
spreadsheets that look exactly as you want.
The following screen-cast walks through the markup that
controls column widths and row heights.
It discusses the exact algorithm to calculate pixel dimensions. If you are an Open XML spreadsheet developer,
you will want to know how this markup works.
In the next screen-cast, I’ll show how to precisely place
images on a worksheet.
I have attached the code to this post.