Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Format

99
100
101
102
103
104
105
106
107
108
109
  }
 
  public static void setFontStrikethrough(Sheet sheet,int row,int col,boolean b){
    Cell cell = Utils.getCell(sheet,row,col);
    if(cell!=null){
      Format format = cloneCellFormat(cell);
      if(format instanceof FormatImpl){
        ((FormatImpl)format).setFontStrikethrough(b);
        cell.setFormat(format);
      }
    }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
  }
 
  public static void setFontType(Sheet sheet,int row,int col,String type){
    Cell cell = Utils.getCell(sheet,row,col);
    if(cell!=null){
      Format format = cloneCellFormat(cell);
      if(format instanceof FormatImpl){
        ((FormatImpl)format).setFontType(type);
        cell.setFormat(format);
      }
    }
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
  }
 
  public static void setBorder(Sheet sheet,int row,int col,BorderStyle bs,int at){
    Cell cell = Utils.getCell(sheet,row,col);
    if(cell!=null){
      Format format = cloneCellFormat(cell);
      if(format instanceof FormatImpl){
        if((at&0x08)!=0)((FormatImpl)format).setBorderLeft(bs);
        if((at&0x04)!=0)((FormatImpl)format).setBorderTop(bs);
        if((at&0x02)!=0)((FormatImpl)format).setBorderRight(bs);
        if((at&0x01)!=0)((FormatImpl)format).setBorderBottom(bs);
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
  }
 
  public static void setFontStyle(Sheet sheet,int row,int col,FontStyle style){
    Cell cell = Utils.getCell(sheet,row,col);
    if(cell!=null){
      Format format = cloneCellFormat(cell);
      if(format instanceof FormatImpl){
        ((FormatImpl)format).setFontStyle(style);
        cell.setFormat(format);
      }
    }
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
  }
 
  public static void setFontUnderline(Sheet sheet,int row,int col,FontUnderline underline){
    Cell cell = Utils.getCell(sheet,row,col);
    if(cell!=null){
      Format format = cloneCellFormat(cell);
      if(format instanceof FormatImpl){
        ((FormatImpl)format).setFontUnderline(underline);
        cell.setFormat(format);
      }
    }
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
  }
 
  public static void setTextHAlign(Sheet sheet,int row,int col,TextHAlign textHAlign){
    Cell cell = Utils.getCell(sheet,row,col);
    if(cell!=null){
      Format format = cloneCellFormat(cell);
      if(format instanceof FormatImpl){
        ((FormatImpl)format).setTextHAlign(textHAlign);
        cell.setFormat(format);
      }
    }
View Full Code Here
1719
1720
1721
1722
1723
1724
1725
1726
1727
1728
1729
1730
        HTMLs.appendAttribute(sb, "z.zsh",zsh);
      }
       
     
      if(cell!=null){
        Format format = cell.getFormat();
        if(format != null && format.isTextWrap()){
          HTMLs.appendAttribute(sb, "z.wrap", "t");
        }
       
        TextHAlign textHAlign = cell.getTextHAlign();
        if (textHAlign != null) {
View Full Code Here
737
738
739
740
741
742
743
744
745
746
747
  }
 
  private void moveCell(CellIndex dstci) {
    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);
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
83
   
    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
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
        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);
View Full Code Here
TOP

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

  • org.zkoss.zss.model.impl.CellImpl
  • org.zkoss.zss.model.impl.CellIndex
  • org.zkoss.zss.model.impl.ImportExportTest
  • org.zkoss.zss.model.impl.SheetImpl
  • org.zkoss.zss.ui.au.in.CellFetchCommandHelper
  • org.zkoss.zss.ui.fn.UtilFns
  • org.zkoss.zss.ui.impl.CellFormatHelper
  • org.zkoss.zss.ui.impl.Styles
  • org.zkoss.zss.ui.Spreadsheet
  • org.zkoss.zss.ui.Spreadsheet$ExtraCtrl
    • 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.