Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Units for column widths in Excel
Message
From
05/11/2004 12:07:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Units for column widths in Excel
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Miscellaneous
Thread ID:
00958564
Message ID:
00958564
Views:
45
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
Next
Reply
Map
View

Click here to load this message in the networking platform