I have defined a name called DB_NAMES(table_array) refers to a sheet3 in MS-EXCEL. Now DB_NAMES refres to formule is =sheet3!$A$2:$B$245 my excel has 4 sheets. by using POI, I am deleting the sheet2 and re-creating with same name sheet2. Now the new sheet created at end. I am doing a re-order my using workbook.setSheetOrder("sheet1", 0); workbook.setSheetOrder("sheet2", 1); workbook.setSheetOrder("sheet3", 2); workbook.setSheetOrder("sheet4", 3); after that my DB_NAMES refers to formule changed to =REF!$A$2:$B$245 This is working fine in POI - 3.7 version. After upgraded to 3.11 version I got this issue. formules in the excel got corrupted. Could you please let me know, do i need to take any other version of POI and do i need to change the code or can this be fixed in any POI version.
Can you please attach the Excel file and your source code, preferably as unit test so we can reproduce your problem?
Marking this bug as duplicate of bug 58746 as we are not having enough information to reproduce the problem here and the other bug has an easy reproducer and likely handles the same issue. *** This bug has been marked as a duplicate of bug 58746 ***