poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 60260] Sheet shiftRows exception at rowShifter.updateNamedRanges
Date Fri, 13 Jan 2017 02:16:08 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=60260

--- Comment #9 from Zero <tuyenivt@gmail.com> ---
(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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message