What is the unit of measure for column widths in Excel? On my machine, it appears that column widths are in multiples of 1/7 (how odd!), and that one inch on a printed page corresponds to 12 units.
Are thes values constant? If not, is it possible to determine what these values are?
I ask because I have an application with lots of grids, and I print them by exporting them to Excel and printing from there. The preference is to print them in Portrait,
unless all the columns across do not fit on one page, but would fit if they were printed in Landscape.
So, as I set the margins before printing, the real question is: How can I tell if all my columns will not fit if printed portrait, but will print if printed landscape?
P.S.: Based upon user choices, there can be a variable number of columns in all my grids, and the user can change the column widths as well, so the determination of the actual printing width must be done at print time.
Jim Nelson
Newbury Park, CA