Hi, time for another RTFM question! It seems that I have asked this question before... I downloaded the new binaries and tried some different suff and everything seems fine to me. But I still cant set a solid backround color, and the solid foreground color always results in a black foreground no matter what color I choose.
//Always black xlsDoc = new HSSFWorkbook(); HSSFCellStyle redStyle = xlsDoc.createCellStyle(); redStyle.setFillBackgroundColor(HSSFCellStyle.RED); redStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); //No color xlsDoc = new HSSFWorkbook(); HSSFCellStyle redStyle = xlsDoc.createCellStyle(); redStyle.setFillBackgroundColor(HSSFCellStyle.RED); redStyle.setFillPattern(HSSFCellStyle.AUTOMATIC); //Color OK but the data is hard to read thorugh the pattern xlsDoc = new HSSFWorkbook(); HSSFCellStyle redStyle = xlsDoc.createCellStyle(); redStyle.setFillBackgroundColor(HSSFCellStyle.RED); redStyle.setFillPattern(HSSFCellStyle.SPARSE_DOTS); / marcus _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com
