I don't doubt the methods are all wrong. Please correct them as you find true and supply unit tests and I'll apply them. The Excel docs are confused on this issue so I tried. I have magic formulas to do it in the serializer....if you can find a rational correlation in this, please do!
------------------------------------------------------------------------------------ OK will do. I am trying at the moment to focus on the viewing functionality. I want to add correct column and row widths to the viewer. I have a problem at the moment that I am unsure about. Firstly, I think that the units of measurement for the column widths and default column widths need to be standardized. The java doc currently states that the HSSFSheet.getColumnWidth ie 1/256th of a character, the HSSFSheet.getDefaultColumnWidth is in characters and even worse the Sheet.getColumnWidth is in twips. Note: The HSSFSheet.getColumnWidth calls directly to Sheet.getColumnWidth so one of those javadoc comments on the return value units is WRONG. But I dont know which one is ;-) Secondly, there seems to be a problem with the decoding of column widths. The statetax2.xls example that I have been using (which came with the original viewer code but attached for convienence) the column widths (as reported by the HSSFSheet.getColumnWidth) are: 9106, 4644, 8, 8, 8, 8, 8 Looking at the file in excel the first column is larger (about twice the size) but the rest are very much the same. I think that the 8's are actually referring to default column widths. Could it be that what should be returned by these calls is: 9106, 4644, 4644, 4644, 4644, 4644, 4644 In which case there is either a bug in the decoding of the column widths, or the Sheet.getColumnWidth call. Jason -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
