LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2012, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 17 Apr 2012 09:15:08 -0500
Reply-To:   Joe Matise <snoopy369@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Joe Matise <snoopy369@GMAIL.COM>
Subject:   Re: For the Excelxp experts out there
Comments:   To: Jeff Kroll <>
In-Reply-To:   <>
Content-Type:   text/plain; charset=ISO-8859-1

I believe it's usually 1/11th of the pixel width; usually I run it once, see what Excel tells me is right, then add a bit for fuzzing and divide by 11. Different fonts have different kerning and character widths, in addition to proportional fonts having very different widths depending on the characters. It would be theoretically possible to determine an appropriate width for a particular font (or at least fairly close), but definitely not trivial.


On Tue, Apr 17, 2012 at 7:36 AM, Jeff Kroll <>wrote:

> Ive been using the Excelxp tagset more and more lately. The one issue Ive > been having is with the absolute_column_width option. I spend way too much > time trying to figure out what the values for each column should be. Is > there a formula that can be used to determine what the values should be > based > upon the size of the font being used? Has anyone come up with any tricks > for > deriving these values? Thanks in advance for your help. >

Back to: Top of message | Previous page | Main SAS-L page