On Wed, 2 Mar 2011, Donato wrote:
String cell_new = (new CellReference(new_row, new_col)).formatAsString( );table.getCTTable( ).setRef(cell_start + ":" + cell_new); Using setRef, the table1.xml file is updated, but the xml for the sheet (containing a conditional formatting) is not.
When you call getCT.... you're getting the low level xml beans. At that point, you need to do everything yourself. So, you'll need to find any other appropriate beans and set them to match.
Where a high level usermodel call exists, POI will be doing any fiddly stuff for you (like keeping different bits of the file in sync when you make a change).
I think in this case though, there isn't a usermodel call for it. However, we'd love patches that would add this!
Thanks Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
