Johannsen, Cory wrote: >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 > > > HSSF supports all of the fill types as far as I know. Do this. Create this as a bug in Bugzilla. Do a sheet with a single cell and the styling as you prefer it. Do another programatically in HSSF. Save the bug then go back to it and attach both files. I'll look at what is different.
-Andy -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
