Illustration of different kinds of table name conflicts

file_62906.txt (text/plain), 4.00 KB, created by David Gauntt on 2019-04-29 12:38:58 UTC

(hide)

Description: Illustration of different kinds of table name conflicts

Filename:

MIME Type:

Creator: David Gauntt

Created: 2019-04-29 12:38:58 UTC

Size: 4.00 KB

patch

obsolete

> /** > * This method returns a workbook with two worksheets, a Table in the first > * worksheet, and optionally a Table or a Name range in the second worksheet > * that may conflict with the name of the first workbook. > * <p> > * If conflictType==0, then a range in the second worksheet is given the > * defined Name "Table1" with workbook scope. If conflictType==1, then a > * Table with the name "Table2" is added to the second worksheet. If > * conflictType==2, then a table with the name "Table2" is added to the > * first worksheet > * <p> > * Next, a Table is added to the first worksheet. If bApplyBugFix is true, > * the workbook will not be corrupted. Otherwise, if conflictType==0 then > * the name of the table will conflict with the name of the range on the > * second sheet, and if conflictType==1 the name of the workbook will > * conflict with the name of the Table on the second sheet. > * <p> > * Note: Excel 2010 can successfully repair this kind of corruption by > * renaming one of the tables. > * > * @param conflictType > * @param bApplyBugFix > * @return > * @throws Exception > */ > XSSFWorkbook runTestKern(int conflictType, boolean bSameSheet, boolean bApplyBugFix) throws Exception { > final String procName = "CreateTableUnitTest.runTestKern"; > final XSSFWorkbook workbook = new XSSFWorkbook(); > final XSSFSheet sheet0 = workbook.createSheet(); > final XSSFSheet sheet1 = workbook.createSheet(); > final XSSFSheet dstSheet = bSameSheet ? sheet0 : sheet1; > final int CONFLICT_RANGENAME = 0; > final int CONFLICT_TABLENAME = 1; > > switch (conflictType) { > case CONFLICT_RANGENAME: > /* Add a range named Table1 at sheet1!$A$1 */ > dstSheet.createRow(0).createCell(0).setCellValue("Range Table1"); > XSSFName name = workbook.createName(); > name.setRefersToFormula(dstSheet.getSheetName() + "!$A$1"); > name.setNameName("Table1"); > name.setSheetIndex(workbook.getSheetIndex(dstSheet)); > break; > case CONFLICT_TABLENAME: { > /* Add a table named Table2 at sheet1!$A$1:$A$2 */ > dstSheet.createRow(0).createCell(0).setCellValue("Table2Hdr1"); > dstSheet.createRow(1).createCell(0).setCellValue("Table2Cell1"); > final XSSFTable table = dstSheet.createTable(new AreaReference("$A$1:$A$2", SpreadsheetVersion.EXCEL2007)); > table.setDisplayName("Table2"); > System.out.println(String.format("\n%s: table=%s", procName, table.getCTTable())); > System.out.println(String.format("%s: names=%s", procName, workbook.getAllNames())); > } > break; > default: > break; > } > > /* Fill sheet0!$A$4:$A$5 with data */ > { > sheet0.createRow(3).createCell(0).setCellValue("Col1"); > sheet0.createRow(4).createCell(0).setCellValue("Cell1"); > } > > int tableNumber = sheet0.getPackagePart().getPackage() > .getPartsByContentType(XSSFRelation.TABLE.getContentType()).size() + 1; > > final XSSFTable table = sheet0.createTable(new AreaReference("$A$4:$A$5", SpreadsheetVersion.EXCEL2007)); > final CTTable cttable = table.getCTTable(); > > if (bApplyBugFix) { > while (isInvalidTableName(workbook, "Table" + tableNumber)) { > tableNumber++; > } > } > cttable.setDisplayName("Table" + tableNumber); > > // cttable.setId(1); > // cttable.setName("Test"); > final CTTableStyleInfo styleInfo; > styleInfo = cttable.addNewTableStyleInfo(); > styleInfo.setName("TableStyleMedium2"); > styleInfo.setShowColumnStripes(false); > styleInfo.setShowRowStripes(true); > cttable.setTotalsRowShown(false); > > System.out.println(String.format("\n%s: table=\n%s", procName, table.getCTTable())); > return workbook; > } > > private boolean isInvalidTableName(XSSFWorkbook workbook, String name) { > final Collection<XSSFName> names = workbook.getNames(name); > if (names != null && names.size() > 0) { > return true; > } > for (int n = workbook.getNumberOfSheets() - 1; n >= 0; --n) { > final XSSFSheet sheet = workbook.getSheetAt(n); > for (XSSFTable table : sheet.getTables()) { > if (name.equals(table.getDisplayName())) { > return true; > } > } > } > return false; > } > View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]