Hi Mark, Thanks for the insight over this. I also think it could also be interesting to have in poi api. Since I am working on prototype with no sizing at the moment :( so according to my requirement in a timeframe I am not covering tables with the border/outline at the moment. But surely, I will do once this prototype works and gets a green light for me. I will come back on this once I have a working solution and will go for JIRA creation. I will keep in touch with community/and you if more information needed on border range.
Many Thanks, rahul On Sun, Mar 27, 2011 at 12:41 PM, Mark Beardsley <[email protected]>wrote: > Forgot to mention that you will need to be careful when making changes to > the > style object associated with the cells in your range(s). You may know that > styles are shared - all cells that look the same will most likely share the > same style. As a result, making a cahnge to the style associated with one > cell can result in those changes being reflected in every other cell the > style is applied to. You have a couple of options when modifying the styles > associates with the peripheral cells in your range(s). The first is to just > assume that the style object could be shared and to clone it, modify the > clone and then apply that to the cell. This will work but only up to a > point > because Excel imposes a limit on the number of styles a workbook can > contain > - at least it did for the older binary format. It would be better - but > inevitably more complex - to determine if any other cells share the same > style object. If not, you could simply modify the style, if on the other > hand, it were shared, you could clone it, modify the clone and then apply > that to the cell. I have not looked into this in any detail yet but that > process may involve iterating through the cells in the worksheet and > checking to see if any share the style object. This could be a long process > and I will look to see if it is possible to short circuit it in any way. > > Yours > > Mark B > > PS In my previous response, I mentioned Ranges. Well you will most likely > be > dealing with CellRangeAddress objects not Range objects. > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Range-Border-tp4265910p4266241.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
