DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17494>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17494 probelem re: creating a cell with borders on a template that was read in Summary: probelem re: creating a cell with borders on a template that was read in Product: POI Version: 1.5.1 Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Major Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] In 1.5.1 final: I read in an xls file that was previously created in Excel. I add several cells with values, and then I add several rows of cells that have a style with borders on three sides (I am creating a table with bordered cells). I am using a style repeatedly, which is created via this code: private static void constructExcelShadedCellStyleAX() { excelShadedCellStyleAX = wb.createCellStyle(); HSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 10); excelShadedCellStyleAX.setFont(f); excelShadedCellStyleAX.setFillForegroundColor(HSSFColor.PALE_BLUE.index); excelShadedCellStyleAX.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); excelShadedCellStyleAX.setBorderLeft(HSSFCellStyle.BORDER_THIN); excelShadedCellStyleAX.setBorderRight(HSSFCellStyle.BORDER_THIN); excelShadedCellStyleAX.setBorderBottom(HSSFCellStyle.BORDER_THIN); } After modifying the file, I write it out to an xls file. Then I open it in Excel. When I use a style WITHOUT BORDERS, it works fine. When I use the above style, WITH BORDERS, when I open the new Excel file, and put the cursor in any cell that touches one of the cells where I have set the border, and then do from the Excel menu: Format...Cells Nothing happens at all. I do NOT get the normal "Format Cells" dialog box. For other cells, it works normally. After trying several cells, the Format...Cells function starts to work properly -- except that it still does not work for those cells directly above and directly below the cells that were formatted with a border. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
