We're using POI to place data in an existing spreadsheet and the user is complaining that the row background fill colur is not being respected.
As a simple case, imagine a blank spreadsheet, Excel 97 format. Set the background fill for column A to cyan, say. Set the background fill for row 1 to red. Cell A1 now appears red, and were I to type into it would remain red. Instead, I save the spreadsheet. It has no cells, but it has a row, and it has column attributes for column A. Now I use POI to place data in cell A1. How do I preserve the observable cell style? When I try it, if I simply create cell number 0 in row 0, it respects the column style but not the row style. I believe I can get hold of the row style via the HSSFRow.getRowStyle() method, but how do I know whether it is the row style or the column style that should take precendence? --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
