Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel column width
Message
From
23/12/2001 13:21:37
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
23/12/2001 11:25:46
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00597816
Message ID:
00597824
Views:
16
>Excel shows column width when we are resizing column. Excel uses units and pixels to show width. when I use Automation width property shows something else (I think). So a column 80 pixels width has width property equal 48. Is ther a way to find out pixels?

It's probably using some other units, depending on the font in use (foxels ? :). Short of digging through Office help, you may run a few tests setting different font sizes and using some tool like VFP TextWidth() and FontMetric() functions - could be Excel has something similar.

The whole thing seems to be annoying, actually - I've seen pixels, foxels, twips, RTF halfpoints and other incongruent units of measure. Probably because all these tools come from several competing companies which couldn't agree on a standard (MS, MS and MS).

We could establish an exchange rate website somewhere... "twip is down .023 pixels this morning" :)

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform