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 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
