Package org.zkoss.poi.ss.util

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

111
112
113
114
115
116
117
118
119
120
121
    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
114
115
116
117
118
119
120
121
122
123
124
      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
117
118
119
120
121
122
123
124
125
126
127
        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
120
121
122
123
124
125
126
127
128
129
130
        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
123
124
125
126
127
128
129
130
131
132
133
        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
126
127
128
129
130
131
132
133
134
135
136
        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
180
181
182
183
184
185
186
187
188
189
190
    assertEquals(5, sheet1.getNumMergedRegions()); //G5:H5 unmerged
    for (int j = 0; j < 5; ++j) {
      CellRangeAddress rng = sheet1.getMergedRegion(j);
      switch(j) {
      case 0:
        assertEquals("E4:F5", rng.formatAsString()); //E6:F8 -> E4:F5
        break;
      case 1:
        assertEquals("E7:F9", rng.formatAsString()); //E10:F12 -> E7:F9
        break;
      case 2:
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
      switch(j) {
      case 0:
        assertEquals("E4:F5", rng.formatAsString()); //E6:F8 -> E4:F5
        break;
      case 1:
        assertEquals("E7:F9", rng.formatAsString()); //E10:F12 -> E7:F9
        break;
      case 2:
        assertEquals("E3:F3", rng.formatAsString()); //E3:F4 -> E3:F3
        break;
      case 3:
View Full Code Here
186
187
188
189
190
191
192
193
194
195
196
        break;
      case 1:
        assertEquals("E7:F9", rng.formatAsString()); //E10:F12 -> E7:F9
        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:
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
        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
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.