Let's say that i want to format an area of cells to have MEDIUM_BORDER, which contains some cells with bold font cell style, and everything else has plain font cell style. It's seems that is impossible to do this in a loop, by iterating through the cells of the area and setting the border to each cell, because i can't find the current cell style of one cell, and if i set the border to be MEDIUM_BORDER, the bold font will be lost? is this correct?
Is there some way to format an area of cells, without knowing the exact cell style of cells involved? Best regards Cata ----- Original Message ----- From: "Andrew C. Oliver" <[EMAIL PROTECTED]> To: "POI Users List" <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 3:48 PM Subject: Re: cell types > Catalin Kormos wrote: > > >Hi all, > > > >I just started using POI, and it's not clear for me, why the method getCellType() does't return the actual cell style of the given cell, and "returns a reference to a cell style contained in the workbook object". This means that i can't find a preseted cell type of a cell, and the only way is to keep references in my code to every cell style i have in my workbook? > > > >Can anyone help me? Thanks > > > >Best regards, > >Catalin Kormos > > > > > > > Because that is what it is like in the file. Cell Style is a member of > the workbook. A cell style can be assigned to multiple cells. Further > more, you can, and > excel can, create 2 styles that are exactly alike but assigned to > different cells. Then change one style and all cells assigned that > style suddenly look different. > > -Andy > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
