I develope a Java aplication, and try to export some data in MS Excel format using POI...
I set HSSFCellStyle borders styles... generate the MS Excel but when I try to open Format Cell dlg (in MS Excell offcourse) that doesn't open... if I don't set border style, no problemo Another problem... is I set on HSSFCellStyle fill pattern to SOLID_FOREGROUND (for solid color on background cell), cell become black, even the color is red or green or wherever you want... for any other fill patern works fine... Here is the code: hssf_cell_style_header = hssf_workbook.createCellStyle(); hssf_cell_style_header.setFont(hssf_font_bold); hssf_cell_style_header.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); hssf_cell_style_header.setFillBackgroundColor(new HSSFColor.GREY_25_PERCENT().getIndex()); hssf_cell_style_header.setBorderTop(HSSFCellStyle.BORDER_THIN); hssf_cell_style_header.setBorderLeft(HSSFCellStyle.BORDER_THIN); hssf_cell_style_header.setBorderBottom(HSSFCellStyle.BORDER_THIN); hssf_cell_style_header.setBorderRight(HSSFCellStyle.BORDER_THIN); Version POI: how can I know the version? this is? (I found somewhere in hpsf package) author Rainer Klute ([EMAIL PROTECTED]) @version $Id: package.html,v 1.3 2002/03/10 17:03:41 acoliver Exp $ @since 2002-02-09 -- View this message in context: http://www.nabble.com/HSSFCellStyle-problems...-border-style...-background-color...-tf3439670.html#a9590896 Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
