Ok, here is my understanding, with all the usual disclaimers :) When we write out an excel file, what we have to do is actually give the column a physical width. It is NOT the case that we can set a flag on the column saying "AutoFit", AFAIK. So we have to calculate the width within POI, which depends on the content in the cell, which in turn depends on the font size and weight, which is where the fort metrics come in. (Font metrics, simply put, is the physical width of each character for a particular font) The trouble with the classes in java that provide font metrics are that they are dependent on X, and thus cant be run from an unix terminal. We therefore need an implementation of font metrics that does not depend on any graphics classes.
Does that help? Regards - Avik On Wed, 2003-05-28 at 21:07, Chris Cheshire wrote: > I have a question on this, which will show my lack of understanding on > the subject. The archives say this needs to be implemented in a manner > that is not dependant on font metrics. Fair enough. I took this answer > for granted a while ago. However I have noticed something when playing > around in excel - if I change the font and size of a column under excel, > the column width never changes. If the width is dependant on font > metrics, wouldn't the width of the column change as the font (and thus > the metrics) change? What am I missing here? > > Chris > > Avik Sengupta wrote: > > >Cant be done yet, read the archives to understand why! > > > >On Wed, 2003-05-28 at 17:09, Shailesh Ligade wrote: > > > > > >>Hello, > >> > >>I am not able to figure out how to use column Format AutoFit. Can any > >>one able to help me here? > >> > >>SL > >> > >> > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
