https://issues.apache.org/bugzilla/show_bug.cgi?id=52186
--- Comment #4 from vladk <[email protected]> --- Excel 2010 creates <cols> tag with the following content for: - Excel sheet with one column having custom width <cols> <col min="2" max="2" width="26.625" customWidth="1"/> </cols> - Excel sheet with one column having custom width. The column is part of a column group "2..4". The column group is expanded. <cols> <col min="2" max="2" width="26.625" customWidth="1" outlineLevel="1"/> <col min="3" max="4" width="11" outlineLevel="1"/> </cols> - Excel sheet with one column having custom width. The column is part of a column group "2..4". The column group is collapsed. <cols> <col min="2" max="2" width="26.625" hidden="1" customWidth="1" outlineLevel="1"/> <col min="3" max="4" width="0" hidden="1" customWidth="1" outlineLevel="1"/> <col min="5" max="5" width="11" collapsed="1"/> </cols> Excel 2010 never omits the "width" attribute in <col> tags. If the column width is not defined explicitly, it takes "0" for hidden columns and "11" for visible ones. "11" appears to be the default width. To behave like Excel 2010, the POI has to set "width" attribute whenever it creates a <col> tag. By the way, Excel 2010 and POI have different default widths: Excel 2010 - "11", POI - "8". Why "8"? May the XSSFSheet.getDefaultColumnWidth() method be modified, to return 11 instead of 8? -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
