The spreadsheet I am generating has some cellls that will be shaded with a background color, while other uise the default (white) background. I've been playing around witht eh shadding patterns, and find that most of them distort the text within the cell. From Excel I know that I can choose a cell and set it's background to a solid color, which does not distort the text. Is it possible to achieve this from within HSSF? On HSSFCellStyle, I see that there is an option (SOLID_FOREGROUND) to fill the cell with a solid foreground color, but no corresponding option ofr the background. SPARSE_DOTS gets pretty close, but still distorts the text. Does HSSF support this yeT?
Thanks again. So far POI is working fantastically for the work I am doing. Great job! Cory
