Nick Burch <nick.burch <at> alfresco.com> writes:
>
> On Thu, 3 Mar 2011, Donato wrote:
> > 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?
>
> Probably easiest if you do - unzip the .xlsx and take a look at the _rels.
> You're looking at what you had before for linking and referencing your
> table, and what you have after
>
> Nick
>
I had a look at the resulting xlsx file, the relationships seems ok, but the
excel file seems corrupted in some way (major problem: if you delete the sheet
0 also the sheet with the table is removed!). I opened the bug 50867 in
bugzilla to move there this discussion.
Many thanks! Donato
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
