How Excel apply scale (zoom level) to grid ?

Copper Contributor

Hello,

I'm developing a project using Interop.
My code work perfectly with excel spreadsheet without scale (zoom level) applied.


But it goes wrong with Excel spreadsheet with zoom different from 100%.

Because Interop gives me measurments (cells/rows/cols heights and widths...) without applying zoom on the grid.

I need to detect some cells by comparing the printed version (A4) with the excel grid version, so first I have to transform (convert) the returned heights and widths using the specified zoom level to get scaled grid.

So I need to know the way Excel go from normal grid to scaled one.

If anyone has idea about this, please help.

Thank you.

0 Replies