https://bz.apache.org/bugzilla/show_bug.cgi?id=60260
--- Comment #9 from Zero <[email protected]> --- (In reply to Javen O'Neal from comment #8) > (In reply to Zero from comment #1) > > The exception also occurred while rename sheet > > Do you have a unit test for this as well? Oddly, the two other unit tests > that I wrote in r1778418 that started with a blank workbook passed without > modifying Formula parser. It'd be good to have another meaningful unit test > if you have it. Your changes work with me, I try to test based on your unit test (renameSheetWithNamedRangeReferringToUnicodeSheetName), and all my case passed > @Test > public void renameSheetWithNamedRangeReferringToUnicodeSheetName() { > List<String> specChars = Arrays.asList( > "\u2018", "\u300C", "\u300D", "\uFFE5", "\uFF5B", > "\uFF5D", "\uFF5C", "\uFF1B", "\u2019", "\uFF1A", "\u201D", > "\u30FC", "\uFF5E", "\uFF01", "\uFF20", "\uFF03", "\uFF04", > "\uFF05", "\uFF3E", "\uFF06", "\uFF0A", "\uFF08", "\uFF09", > "\uFF3F", "\uFF1C", "\uFF1E", "\uFF1F", "\u3001", "\u3002", > "\u30FB", "\u2605", "\u2606", "\uFF0B", "\u25CF", "\u203B", > "\uFF1D", "\u2460", "\u2461", "\u2462", "\u2463", "\u2464", > "\u2465", "\u2466", "\u2467", "\u2468", "\u2469", "\u246A", > "\u246B", "\u246C", "\u246D", "\u246E", "\u246F", "\u2470", > "\u2471", "\u2472", "\u2473", "\u24EB", "\u24EC", "\u24ED", > "\u24EE", "\u24EF", "\u24F0", "\u24F1", "\u24F2", "\u24F3", > "\u24F4", "\u3007", "\uFF0E", "\u30FB", "\u3002", "\u25CB", > "\u25CE", "\u21D4", "\u2192", "\u2190", "\u2191", "\u2193", > "\u21D2", "\u3010", "\u3011", "\u3014", "\u3015", "\u300A", > "\u300B", "\u3008", "\u3009", "\u300E", "\u300F", "\uFF1C", > "\uFF1E", "\u226A", "\u226B", "\u301D", "\u301F"); > XSSFWorkbook wb = new XSSFWorkbook(); > for (String specChar : specChars) { > wb.createSheet("Sheet" + specChar + "1"); > > Name name = wb.createName(); > name.setNameName("test_named_range"); > name.setRefersToFormula("'Sheet" + specChar + "1'!A1:A6"); > > wb.setSheetName(0, "Sheet 1"); > > wb.removeName(name); > wb.removeSheetAt(0); > } > IOUtils.closeQuietly(wb); > } Thank you so much, Javen O'Neal -- 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]
