https://issues.apache.org/bugzilla/show_bug.cgi?id=47100
--- Comment #2 from Yegor Kozlov <[email protected]> 2011-03-01 11:36:29 EST --- It is a bug in XSSF. In the binary .xls format formulas are stored in parsed form as sequences of tokens. The Sheet Name token just points to the corresponding SheetRecord and when you change that SheetRecord all depending formulas are automatically updated. The .xlsx format is totally different. It is a zip of xml files and formulas are stored in plain text. XSSFWorkbook.setSheetName just updates the corresponding bits in workbook.xml and that's all. No formulas are updated. To fix your problem, XSSFWorkbook.setSheetName should iterate over all formulas and named ranges and update the sheet name. Yegor -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
