Package org.zkoss.poi.ss.util

Examples of org.zkoss.poi.ss.util.CellRangeAddress.formatAsString()

320
321
322
323
324
325
326
327
328
329
330
        break;
      case 2:
        assertEquals("E3:F3", rng.formatAsString()); //E3:F4 -> E3:F3
        break;
      case 3:
        assertEquals("I3:J4", rng.formatAsString()); //I3:J7 -> I3:J4
        break;
      case 4:
        assertEquals("E11:F12", rng.formatAsString()); //E14:F15 -> E11:F12
      }
    }
View Full Code Here
323
324
325
326
327
328
329
330
331
332
333
        break;
      case 3:
        assertEquals("I3:J4", rng.formatAsString()); //I3:J7 -> I3:J4
        break;
      case 4:
        assertEquals("E11:F12", rng.formatAsString()); //E14:F15 -> E11:F12
      }
    }
  }
 
  private void testToFormulaString(Cell cell, String expect) {
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
    Name namevar = book.createName();
    namevar.setNameName(name);
    namevar.setSheetIndex(sheetindex);
    CellRangeAddress cra = new CellRangeAddress(top, bottom, left, right);
    namevar.setRefersToFormula(cra.formatAsString());
   
    Window rangeAddWin = (Window) Path.getComponent("//p1/rangeAddWin");
    rangeAddWin.detach();
  }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    lastCol = event.getColumn();
    Label lbpos = (Label)getFellow("lbpos");
    Textbox tbxval = (Textbox)getFellow("tbxval");
    CellRangeAddress addr = new CellRangeAddress(lastRow, lastRow, lastCol, lastCol);
    Cell cell = Utils.getCell(sheet, lastRow, lastCol);
    lbpos.setValue(addr.formatAsString());
    tbxval.setValue(cell == null ? "" : Utils.getEditText(cell));
  }
   
  void doCellChange(String value){
    if(lastRow == -1){
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
    assertEquals(6, sheet1.getNumMergedRegions());
    for (int j = 0; j < 6; ++j) {
      CellRangeAddress rng = sheet1.getMergedRegion(j);
      switch(j) {
      case 0:
        assertEquals("E6:F8", rng.formatAsString());
        break;
      case 1:
        assertEquals("E10:F12", rng.formatAsString());
        break;
      case 2:
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
      switch(j) {
      case 0:
        assertEquals("E6:F8", rng.formatAsString());
        break;
      case 1:
        assertEquals("E10:F12", rng.formatAsString());
        break;
      case 2:
        assertEquals("G5:H5", rng.formatAsString());
        break;
      case 3:
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
        break;
      case 1:
        assertEquals("E10:F12", rng.formatAsString());
        break;
      case 2:
        assertEquals("G5:H5", rng.formatAsString());
        break;
      case 3:
        assertEquals("E3:F4", rng.formatAsString());
        break;
      case 4:
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
        break;
      case 2:
        assertEquals("G5:H5", rng.formatAsString());
        break;
      case 3:
        assertEquals("E3:F4", rng.formatAsString());
        break;
      case 4:
        assertEquals("I3:J7", rng.formatAsString());
        break;
      case 5:
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
        break;
      case 3:
        assertEquals("E3:F4", rng.formatAsString());
        break;
      case 4:
        assertEquals("I3:J7", rng.formatAsString());
        break;
      case 5:
        assertEquals("E14:F15", rng.formatAsString());
        break;
      }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
        break;
      case 4:
        assertEquals("I3:J7", rng.formatAsString());
        break;
      case 5:
        assertEquals("E14:F15", rng.formatAsString());
        break;
      }
    }
 
    //remove rows 4 ~ 6
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.