However, it appears that Excel is setting the column width in a manner that is independent of the font metrics anyway, so why does poi have to?
When playing around with fonts in a new sheet in excel, going from a fixed width to a variable width, changing size etc, the only thing that changed was the row height, but not the column width. It stayed at a default of "8.43 thingamajigs" (I don't know what unit excel uses for this).
I am just try to understand this, not trying to be argumentative. I am sure there is a perfectly rational explanation for all of this, despite it being a microsoft product :)
Chris
Avik Sengupta wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
