예제 #1
0
  @Test
  public void testZSS595_Column() {
    Book book = Util.loadBook(this, "book/blank.xlsx");
    Sheet sheet = book.getSheet("Sheet1");

    String[] columns = {"A", "B", "C", "D", "E"};
    Ranges.range(sheet).setFreezePanel(0, 5);

    // === Insert
    for (int i = 1; i < 6; i++) {
      try {
        Ranges.range(sheet, columns[i - 1] + ":G")
            .toColumnRange()
            .insert(InsertShift.DEFAULT, InsertCopyOrigin.FORMAT_LEFT_ABOVE);
      } catch (InvalidModelOpException e) {
        continue;
      }
      fail(); // if doesn't continue, it fail!
    }

    // == Delete
    for (int i = 1; i < 6; i++) {
      try {
        Ranges.range(sheet, columns[i - 1] + ":G").toColumnRange().delete(DeleteShift.DEFAULT);
      } catch (InvalidModelOpException e) {
        continue;
      }
      fail(); // if doesn't continue, it fail!
    }
  }
예제 #2
0
  @Test
  public void testZSS595_Row() {
    Book book = Util.loadBook(this, "book/blank.xlsx");
    Sheet sheet = book.getSheet("Sheet1");
    Ranges.range(sheet).setFreezePanel(5, 0);

    // === Insert
    for (int i = 1; i < 6; i++) {
      try {
        Ranges.range(sheet, i + ":6")
            .toRowRange()
            .insert(InsertShift.DEFAULT, InsertCopyOrigin.FORMAT_LEFT_ABOVE);
      } catch (InvalidModelOpException e) {
        continue;
      }
      fail(); // if doesn't continue, it fail!
    }

    // == Delete
    for (int i = 1; i < 6; i++) {
      try {
        Ranges.range(sheet, i + ":6").toRowRange().delete(DeleteShift.DEFAULT);
      } catch (InvalidModelOpException e) {
        continue;
      }
      fail(); // if doesn't continue, it fail!
    }
  }
예제 #3
0
 @Test
 public void testZSS502_NonExistingSheet2007() {
   Book book = Util.loadBook(this, "book/blank.xlsx");
   Sheet sheet = book.getSheetAt(0);
   Range cell = Ranges.range(sheet, "A1");
   cell.setCellEditText("=nonExisted!B1");
   assertEquals("=nonExisted!B1", cell.getCellEditText());
   assertEquals(ErrorConstants.getText(ErrorConstants.ERROR_REF), cell.getCellFormatText());
 }
예제 #4
0
 @Test
 public void testZSS510() {
   Book book = Util.loadBook(this, "book/blank.xlsx");
   Sheet sheet = book.getSheetAt(0);
   Range r = Ranges.range(sheet, "A1");
   r.setCellEditText("Hello");
   CellOperationUtil.applyDataFormat(r, "");
   r.getCellFormatText(); // get text shouldn't cause IndexOutBoundaryException
   assertEquals(
       "General", r.getCellStyle().getDataFormat()); // should get General instead of empty string
 }
예제 #5
0
  @Test
  public void testZSS502_2007() {
    Book book = Util.loadBook(this, "book/502-crossSheetReference.xlsx");
    Sheet sheet = book.getSheet("cell-reference");
    Range referencingCell = Ranges.range(sheet, "C4");
    assertEquals("=row!A1", referencingCell.getCellEditText());
    assertEquals("The first row is freezed.", referencingCell.getCellFormatText());

    Ranges.range(book.getSheet("row")).deleteSheet();

    assertEquals("='#REF'!A1", referencingCell.getCellEditText());
    assertEquals(
        ErrorConstants.getText(ErrorConstants.ERROR_REF), referencingCell.getCellFormatText());
  }
예제 #6
0
  @Test
  public void testZSS511_LEFTB() {
    Book book = Util.loadBook(this, "book/511-REPLACEB-LEFTB.xlsx");
    Sheet sheet = book.getSheet("LEFTB");

    assertEquals("#VALUE!", Ranges.range(sheet, "A1").getCellFormatText());
    assertEquals("", Ranges.range(sheet, "A2").getCellFormatText());
    assertEquals(" ", Ranges.range(sheet, "A3").getCellFormatText());
    assertEquals("\u5E8A", Ranges.range(sheet, "A4").getCellFormatText());
    assertEquals("\u5E8A ", Ranges.range(sheet, "A5").getCellFormatText());
    assertEquals("\u5E8A\u524D", Ranges.range(sheet, "A6").getCellFormatText());
    assertEquals("\u5E8A\u524D ", Ranges.range(sheet, "A7").getCellFormatText());
    assertEquals("\u5E8A\u524D\u660E", Ranges.range(sheet, "A8").getCellFormatText());
    assertEquals("\u5E8A\u524D\u660E ", Ranges.range(sheet, "A9").getCellFormatText());
    assertEquals("\u5E8A\u524D\u660E\u6708", Ranges.range(sheet, "A10").getCellFormatText());
    assertEquals("\u5E8A\u524D\u660E\u6708 ", Ranges.range(sheet, "A11").getCellFormatText());
    assertEquals("\u5E8A\u524D\u660E\u6708\u5149", Ranges.range(sheet, "A12").getCellFormatText());
    assertEquals("\u5E8A\u524D\u660E\u6708\u5149", Ranges.range(sheet, "A13").getCellFormatText());
    assertEquals("\u5E8A\u524D\u660E\u6708\u5149", Ranges.range(sheet, "A14").getCellFormatText());

    assertEquals("#VALUE!", Ranges.range(sheet, "C1").getCellFormatText());
    assertEquals("", Ranges.range(sheet, "C2").getCellFormatText());
    assertEquals("A", Ranges.range(sheet, "C3").getCellFormatText());
    assertEquals("A ", Ranges.range(sheet, "C4").getCellFormatText());
    assertEquals("A\u5E8A", Ranges.range(sheet, "C5").getCellFormatText());
    assertEquals("A\u5E8A ", Ranges.range(sheet, "C6").getCellFormatText());
    assertEquals("A\u5E8A\u524D", Ranges.range(sheet, "C7").getCellFormatText());
    assertEquals("A\u5E8A\u524D ", Ranges.range(sheet, "C8").getCellFormatText());
    assertEquals("A\u5E8A\u524D\u660E", Ranges.range(sheet, "C9").getCellFormatText());
    assertEquals("A\u5E8A\u524D\u660E ", Ranges.range(sheet, "C10").getCellFormatText());
    assertEquals("A\u5E8A\u524D\u660E\u6708", Ranges.range(sheet, "C11").getCellFormatText());
    assertEquals("A\u5E8A\u524D\u660E\u6708 ", Ranges.range(sheet, "C12").getCellFormatText());
    assertEquals("A\u5E8A\u524D\u660E\u6708\u5149", Ranges.range(sheet, "C13").getCellFormatText());
    assertEquals("A\u5E8A\u524D\u660E\u6708\u5149", Ranges.range(sheet, "C14").getCellFormatText());

    assertEquals("", Ranges.range(sheet, "E1").getCellFormatText());
  }
예제 #7
0
 @Test
 public void testZSS547_DeleteSheet() {
   // there are Sheet1~4
   testZSS547_DeleteSheet(Util.loadBook(this, "book/547-sheet-index.xlsx"));
   testZSS547_DeleteSheet(Util.loadBook(this, "book/547-sheet-index.xls"));
 }
예제 #8
0
  @Test
  public void testZSS511_REPLACEB() throws UnsupportedEncodingException {
    Book book = Util.loadBook(this, "book/511-REPLACEB-LEFTB.xlsx");
    Sheet sheet = book.getSheet("REPLACEB");
    assertEquals(
        "A\u6E2C\u660E\u6708\u5149\u662F\u5B57\u4E32",
        Ranges.range(sheet, "A1").getCellFormatText());
    assertEquals(
        "A\u6E2C\u660E\u6708\u5149 \u5B57\u4E32", Ranges.range(sheet, "A2").getCellFormatText());
    assertEquals(
        "A\u6E2C\u660E\u6708\u5149\u5B57\u4E32", Ranges.range(sheet, "A3").getCellFormatText());
    assertEquals("A\u6E2C\u660E\u6708\u5149 \u4E32", Ranges.range(sheet, "A4").getCellFormatText());
    assertEquals("A\u6E2C\u660E\u6708\u5149\u4E32", Ranges.range(sheet, "A5").getCellFormatText());
    assertEquals("A\u6E2C\u660E\u6708\u5149 ", Ranges.range(sheet, "A6").getCellFormatText());
    assertEquals("A\u6E2C\u660E\u6708\u5149", Ranges.range(sheet, "A7").getCellFormatText());
    assertEquals("A\u6E2C\u660E\u6708\u5149", Ranges.range(sheet, "A8").getCellFormatText());

    assertEquals("\u5E8A \u4F60\u597D\u55CE", Ranges.range(sheet, "C1").getCellFormatText());
    assertEquals(
        "\u5E8A \u4F60\u597D\u55CE\u660E\u6708\u5149",
        Ranges.range(sheet, "C2").getCellFormatText());
    assertEquals(
        "\u5E8A \u4F60\u597D\u55CE \u6708\u5149", Ranges.range(sheet, "C3").getCellFormatText());
    assertEquals(
        "\u5E8A \u4F60\u597D\u55CE\u6708\u5149", Ranges.range(sheet, "C4").getCellFormatText());
    assertEquals("\u5E8A \u4F60\u597D\u55CE \u5149", Ranges.range(sheet, "C5").getCellFormatText());
    assertEquals("\u5E8A \u4F60\u597D\u55CE\u5149", Ranges.range(sheet, "C6").getCellFormatText());
    assertEquals("\u5E8A \u4F60\u597D\u55CE ", Ranges.range(sheet, "C7").getCellFormatText());
    assertEquals("\u5E8A \u4F60\u597D\u55CE", Ranges.range(sheet, "C8").getCellFormatText());

    assertEquals("#VALUE!", Ranges.range(sheet, "E1").getCellFormatText());
    assertEquals("#VALUE!", Ranges.range(sheet, "E2").getCellFormatText());
    assertEquals("\u4F60\u597D\u55CE", Ranges.range(sheet, "E3").getCellFormatText());
    assertEquals(" ", Ranges.range(sheet, "E4").getCellFormatText());
    assertEquals("\u6E2C", Ranges.range(sheet, "E5").getCellFormatText());
    assertEquals("\u6E2C\u8A66", Ranges.range(sheet, "E6").getCellFormatText());

    assertEquals(
        "\u4F60\u597D\u55CE\u5E8A\u524D\u660E\u6708\u5149",
        Ranges.range(sheet, "G1").getCellFormatText());
    assertEquals(" \u4F60\u597D\u55CE", Ranges.range(sheet, "G2").getCellFormatText());
    assertEquals(
        "\u5E8A\u4F60\u597D\u55CE\u524D\u660E\u6708\u5149",
        Ranges.range(sheet, "G3").getCellFormatText());
    assertEquals("\u5E8A \u4F60\u597D\u55CE", Ranges.range(sheet, "G4").getCellFormatText());
    assertEquals(
        "\u5E8A\u524D\u4F60\u597D\u55CE\u660E\u6708\u5149",
        Ranges.range(sheet, "G5").getCellFormatText());
    assertEquals("\u5E8A\u524D \u4F60\u597D\u55CE", Ranges.range(sheet, "G6").getCellFormatText());
    assertEquals(
        "\u5E8A\u524D\u660E\u4F60\u597D\u55CE\u6708\u5149",
        Ranges.range(sheet, "G7").getCellFormatText());
    assertEquals(
        "\u5E8A\u524D\u660E \u4F60\u597D\u55CE", Ranges.range(sheet, "G8").getCellFormatText());
    assertEquals(
        "\u5E8A\u524D\u660E\u6708\u4F60\u597D\u55CE\u5149",
        Ranges.range(sheet, "G9").getCellFormatText());

    assertEquals("A \u660E\u6708\u5149", Ranges.range(sheet, "I1").getCellFormatText());
    assertEquals(
        "A \u660E\u6708\u5149\u662F\u5B57\u4E32", Ranges.range(sheet, "I2").getCellFormatText());
    assertEquals(
        "A \u660E\u6708\u5149 \u5B57\u4E32", Ranges.range(sheet, "I3").getCellFormatText());
    assertEquals("A \u660E\u6708\u5149\u5B57\u4E32", Ranges.range(sheet, "I4").getCellFormatText());
    assertEquals("A \u660E\u6708\u5149 \u4E32", Ranges.range(sheet, "I5").getCellFormatText());
    assertEquals("A \u660E\u6708\u5149\u4E32", Ranges.range(sheet, "I6").getCellFormatText());

    assertEquals("HelWhatlo World", Ranges.range(sheet, "K1").getCellFormatText());
    assertEquals("HelWhato World", Ranges.range(sheet, "K2").getCellFormatText());
    assertEquals("HelWhat World", Ranges.range(sheet, "K3").getCellFormatText());
    assertEquals("HelWhatWorld", Ranges.range(sheet, "K4").getCellFormatText());
    assertEquals("HelWhatorld", Ranges.range(sheet, "K5").getCellFormatText());
    assertEquals("HelWhatrld", Ranges.range(sheet, "K6").getCellFormatText());
    assertEquals("HelWhatld", Ranges.range(sheet, "K7").getCellFormatText());
    assertEquals("HelWhatd", Ranges.range(sheet, "K8").getCellFormatText());
  }