Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Units for column widths in Excel
Message
De
05/11/2004 12:07:41
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Units for column widths in Excel
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Divers
Thread ID:
00958564
Message ID:
00958564
Vues:
46
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform