Been doing a little digging and this problem is quite common. It appears as though there are lots of potential causes ranging from Excel rounding the columns widths to the display card of the machine, font metrics and even the printer driver. The easiest way to check to see if POI is at fault is to open the exact same file on the Windows 7 machine and on the XP machine. If the two displays differ, it can only be caused by some differences between the machines or the installations of Excel.
Looking at the pictures you posted, the problem seem to be exacerbated by the wrap on the contents of column D. Perhaps adding a fiddle factor to that columns width - make it slightly wider than it need be - may solve the problem. It may well also be the case that you will never get the two displays to look exactly the same and could be forced to opt for the least objectionable result. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Columns-generated-with-different-width-tp5711915p5711940.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
