Nick Burch <nick.burch <at> alfresco.com> writes:
>
> On Wed, 2 Mar 2011, Donato wrote:
> > I'll try. In the meantime, is it possible to create a kind of feature
> > request or to open a bug in bugzilla or somewhere else?
>
> Yup, just set the severity to "enhancement" in bugzilla
>
> > I think the following things should be supported:
> > - possibility to handle conditional formatting using XSSF objects too
> > - auto-extend ranges for conditional formatting when new rows are inserted
> > inside a range
> > - auto-extend ranges when a table is extented using setRef
>
> One thing to remember is that as POI is a volunteer project, the quickest
> way to see new features added is to send in the patches yourself :)
>
> Nick
>
Hi Nick,
another topic related to tables. I noticed the following problem: I have an
Excel (XLSX) with a table in the sheet1. I add a new sheet with
workBook.createSheet("mysheet") and then I set it as the first sheet with
workBook.setSheetOrder(0). After that, the table is in some way corrupted (i.e.
it is displayed but cells cannot be edited any more).
This happens with xlsx files and not with xls (i.e. it happens with
XSSFWorkbook only). Maybe relations between tables and sheets are not updated
correctly.
Can you check?
Note that this is not related to the problem of reading / updating tables from
POI, but it's just to preserving existing tables in case of new sheets.
Many thanks!
Donato
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
