Oct 30 2018 04:10 PM
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.