Excel Internal Units

Excel uses its own internal units to store the coordinates of most things ,and FlexCel lets you work with the same units in order not to lose precision due to rounding errors.

Here we will show how to convert from those units to others that might be more useful to you.

Property	Excel Internal Unit	How to convert
Row Height	Stored as 1/20 of a point, where a point is 1/72 of an inch.	While it is not possible to convert directly to pixels because it depends on how much pixels per inch the monitor has, you can use the RowMult variable defined in UFlxMessages. RowMult * HeightInPixels = HeightInInternalUnits HeightInInternalUnits / RowMult = HeightInPixels.
Column Width	Stored as 1/256 of the width of character "0" in the default font.	ColMult * WidthInPixels = WidthInInternalUnits WidthInInternalUnits / ColMult = WidthInPixels.
dx for image placement. This is an offset specifying how much from the left of the column the image is placed.	1/1024 of a cell. 0 means totally at the left, 512 on half of the cell, 1024 means at the left of next cell.	Convert the column width to pixels, and then see how much of the column is used.
dy for image placement. This is an offset specifying how much from the top of the row the image is placed.	1/255 of a cell. 0 means totally at the top, 128 on half of the cell, 255 means at the top of next cell.	Convert the row to pixels, then apply the percentage.

What do you think about this topic? Send feedback!