Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Cell

450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
          for (int col = left; left <= right; ++col) {
            final CellIndex ci = ri.getCellIndexIfExists(col);
            if (ci == null) {
              dstri.detachCellIndex(col+coloffset);
            } else {
              final Cell cell = ci.getCellIfExists();
              if (cell != null) {
                final CellIndex dstci = dstri.getCellIndex(col+coloffset);
                //get cell, create if not exists
                final Cell dstcell = dstci.getCell();
                dstcell.setValue(cell.getValue());
              }
            }
          }
        }
        detach(row);
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
  public void testCopy1() {
    _sheet = ((BookImpl)_book).addSheet("sheet1", 256, 64*1024);
    assertEquals(_sheet, _book.lookupSheet("sheet1"));

    Cell cell = ((SheetImpl)_sheet).setCellEditText(2,0,"123"); //A3
    FormatImpl fm = new FormatImpl();
    cell.setFormat(fm);
    fm.setFormatCodes("0;[Red](0)");
    fm.setFontColor("#0000FF");
   
    assertEquals("#0000FF", cell.getTextColor());

    cell.setValue(new Double(1));
    assertEquals(TextHAlign.RIGHT, cell.getTextHAlign());
    cell.setValue("A String");
    assertEquals(TextHAlign.LEFT, cell.getTextHAlign());
   
    fm.setTextHAlign(TextHAlign.CENTER);
    cell.setValue(new Double(1));
    assertEquals(TextHAlign.CENTER, cell.getTextHAlign());
    cell.setValue("a string");
    assertEquals(TextHAlign.CENTER, cell.getTextHAlign());
   
    _sheet.copyCell(cell, 3, 0); //A4
    Cell cellA4 = ((SheetImpl)_sheet).getCell(3,0); //A4
    FormatImpl fm2 = (FormatImpl) cellA4.getFormat();
   
    assertNotSame(fm, fm2);
   
    assertEquals(fm.getFormatCodes(), fm2.getFormatCodes());
    assertEquals("0;[Red](0)", fm2.getFormatCodes());
    assertEquals(fm.getFontColor(), fm2.getFontColor());
    assertEquals("#0000FF", fm2.getFontColor());
    assertEquals("#0000FF", cellA4.getTextColor());

    cellA4.setValue(new Double(1));
    assertEquals(TextHAlign.CENTER, cellA4.getTextHAlign());
    cellA4.setValue("a string");
    assertEquals(TextHAlign.CENTER, cellA4.getTextHAlign());
   
  }
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
  public void testCopy2() {
    _sheet = ((BookImpl)_book).addSheet("sheet1", 256, 64*1024);
    assertEquals(_sheet, _book.lookupSheet("sheet1"));

    Cell cell = ((SheetImpl)_sheet).setCellEditText(2,0,"123"); //A3
    FormatImpl fm = new FormatImpl();
    cell.setFormat(fm);
    fm.setFormatCodes("0;[Red](0)");
    fm.setFontColor("#0000FF");
   
    assertEquals("#0000FF", cell.getTextColor());

    cell.setValue(new Double(1));
    assertEquals(TextHAlign.RIGHT, cell.getTextHAlign());
    cell.setValue("A String");
    assertEquals(TextHAlign.LEFT, cell.getTextHAlign());
   
    fm.setTextHAlign(TextHAlign.CENTER);
    cell.setValue(new Double(1));
    assertEquals(TextHAlign.CENTER, cell.getTextHAlign());
    cell.setValue("a string");
    assertEquals(TextHAlign.CENTER, cell.getTextHAlign());
   
    Range rng = new RangeSimple(_sheet, null, 0, 2, 0, 2); //A3
    rng.copy(new RangeSimple(_sheet, null, 0, 3, 2, 3)); //A4:C4
   
    for (int j = 0; j < 3; ++j) {
      Cell cellA4 = ((SheetImpl)_sheet).getCell(3,j); //A4 ~ C4
      FormatImpl fm2 = (FormatImpl) cellA4.getFormat();
     
      assertNotSame(fm, fm2);
     
      assertEquals(fm.getFormatCodes(), fm2.getFormatCodes());
      assertEquals("0;[Red](0)", fm2.getFormatCodes());
      assertEquals(fm.getFontColor(), fm2.getFontColor());
      assertEquals("#0000FF", fm2.getFontColor());
      assertEquals("#0000FF", cellA4.getTextColor());
 
      cellA4.setValue(new Double(1));
      assertEquals(TextHAlign.CENTER, cellA4.getTextHAlign());
      cellA4.setValue("a string");
      assertEquals(TextHAlign.CENTER, cellA4.getTextHAlign());
    }
   
  }
View Full Code Here
740
741
742
743
744
745
746
747
748
749
750
751
    if (_cell != null) {
      final Object val = _cell.getValue();
      final Format format = _cell.getFormat();
      _cell.setValue(null); //clear the value
      //get the destination cell, create one if not exist.
      final Cell dstcell = dstci.getCell();
      dstcell.setValue(val);
      ((CellImpl)dstcell).mySetFormat(format, false);
      _cell = null; // remove cell from this CellIndex (DO NOT CALL setCell(null) which will clean up Formula)
    } else {
      dstci.setCell(null);
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
    if(list.size()<=ss.getSelectedIndex()){
      throw new XelException("No such sheet :"+ss.getSelectedIndex());
    }*/
    Sheet sheet = ss.getSelectedSheet();
   
    Cell cell = sheet.getCell(row,column);
   
    if(cell==null) return "";
   
    Object value = cell.getText();
    String txt = value==null?"":value.toString();
   
    boolean wrap = false;
    Format format = cell.getFormat();
    if(format != null && format.isTextWrap()){
      wrap = true;
    }
   
    txt = Utils.escapeCellText(txt,wrap,wrap);
View Full Code Here
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
        if(row>_loadedRect.getBottom() ||
          (row <_loadedRect.getTop() && row>getRowfreeze())) continue;
        if(col>_loadedRect.getRight() ||
            (col <_loadedRect.getLeft() && row>getColumnfreeze())) continue;
       
        Cell cell = sheet.getCell(row,col);
        //if(cell==null) continue;
        String text = (cell==null)?"":cell.getText();
       
       
        JSONObj result = new JSONObj();
        result.setData("r", row);
        result.setData("c", col);
        result.setData("type", "udcell");
       
        Format format = (cell==null)?null:cell.getFormat();
        boolean wrap = false;
       
        CellFormatHelper cfh = new CellFormatHelper(sheet,row,col,getMergeMatrixHelper(sheet));
        String st = cfh.getHtmlStyle();
        String ist = cfh.getInnerHtmlStyle();
        if (st != null && !"".equals(st)){
          result.setData("st", st);// style of text cell.
        }
        if (ist != null && !"".equals(ist)){
          result.setData("ist", ist);// inner style of text cell
        }
        if (format!=null && format.isTextWrap()){
          wrap = true;
          result.setData("wrap", true);
        }
        if (cfh.hasRightBorder()){
          result.setData("rbo",true);
        }
        TextHAlign textHAlign = (cell==null)?null:cell.getTextHAlign();
        if (textHAlign != null) {
          if (textHAlign.equals(TextHAlign.RIGHT)) {
            result.setData("hal","r");
          } else if (textHAlign.equals(TextHAlign.CENTER)) {
            result.setData("hal","c");
View Full Code Here
306
307
308
309
310
311
312
313
314
315
316
  }
 
  /*package*/ void getCells(int left, int right, List list) {
    for (final Iterator it = getCellIndexes(left, right).iterator(); it.hasNext();) {
      final CellIndex ci = (CellIndex) it.next();
      final Cell cell = ci.getCellIfExists();
      if (cell != null) {
        list.add(cell);
      }
    }
  }
View Full Code Here
140
141
142
143
144
145
146
147
148
  }
 
  public Cell setCellValue(int row, int col, Object value) {
    final CellIndex ci = _matrix.getCellIndex(row, col);
    //get cell, create one if not exists
    final Cell cell = ci.getCell();
    cell.setValue(value);
    return cell;
  }
View Full Code Here
148
149
150
151
152
153
154
155
156
  }

  public Cell setCellEditText(int row, int col, String value) {
    final CellIndex ci = _matrix.getCellIndex(row, col);
    //get cell, create one if not exists
    final Cell cell = ci.getCell();
    cell.setEditText(value);
    return cell;
  }
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
    return cell;
  }
 
  public Cell removeCell(int row, int col) {
    final CellIndex ci = _matrix.getCellIndexIfExists(row, col);
    final Cell old = ci == null ? null : ci.getCellIfExists();
    if (old != null) {
      //remove the merge range if a merged cell
      final RangeMerge rm = ((CellImpl)old).getRangeMerge();
      if (rm != null) {
        final Range rng = new RangeSimple(this, null, rm.getLeft(), rm.getTop(), rm.getRight(), rm.getBottom());
View Full Code Here
TOP

Related Classes of org.zkoss.zss.model.Cell

  • org.zkoss.zss.demo.CustomFunction
  • org.zkoss.zss.demo.MainWindow
  • org.zkoss.zss.engine.fn.MathFns
  • org.zkoss.zss.engine.fn.StatFns
  • org.zkoss.zss.engine.fn.UtilFns
  • org.zkoss.zss.engine.xel.Ref2d
  • org.zkoss.zss.engine.xel.Token
  • org.zkoss.zss.model.impl.AbstractRange
  • org.zkoss.zss.model.impl.BugTest
  • org.zkoss.zss.model.impl.CellImpl
    • Copyright © 2018 www.massapicom. 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.