https://issues.apache.org/bugzilla/show_bug.cgi?id=47100
Yegor Kozlov <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #5 from Yegor Kozlov <[email protected]> 2011-03-04 06:17:18 EST --- Fixed in r1077878, junit added The fix that you suggested is naive and works only in simple cases. The correct approach is to parse every formula in the workbook and render it back to string with the updated sheet name. This way we ensure that the updated formulas are syntactically correct and parsable. P.S. we may need a similar fix for named ranges. Consider a case when you open a workbook and then change a name of a named range, e.g. XSSFWorkbook wb = new XSSFWorkbook(); XSSFName name = wb.getName("sale_1"); name.setNameName("sale_2"); Similar to changing sheet name, all dependent formulas and named ranges should be updated. I'm leaving it for a new Bugzilla ticket. 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]
