Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Range

909
910
911
912
913
914
915
916
    return range.getText();
  }
 
  public static FormatText getFormatText(Cell cell) {
    //TODO, shall cache the FormatText inside cell. value/style/evaluate then invalidate the cache
    Range range = getRange((Worksheet)cell.getSheet(), cell.getRowIndex(), cell.getColumnIndex());
    return range.getFormatText();
  }
View Full Code Here
954
955
956
957
958
959
960
961
   * Sets the user input text into the cell.
   * @param cell the cell.
   * @param txt the user input text.
   */
  public static void setEditText(Cell cell, String txt) {
    final Range range = getRange((Worksheet)cell.getSheet(), cell.getRowIndex(), cell.getColumnIndex());
    range.setEditText(txt);
  }
View Full Code Here
964
965
966
967
968
969
970
971
   * Returns the {@link RichTextString} for editing on the cell.
   * @param cell the cell
   * @return the {@link RichTextString} for editing on the cell.
   */
  public static RichTextString getRichEditText(Cell cell) {
    final Range range = getRange((Worksheet)cell.getSheet(), cell.getRowIndex(), cell.getColumnIndex());
    return range.getRichEditText();
  }
View Full Code Here
974
975
976
977
978
979
980
981
   * Sets the user input {@link RichTextString} into the cell.
   * @param cell the cell
   * @param value the user input {@link RichTextString} to be set into the cell.
   */
  public static void setRichEditText(Cell cell, RichTextString value) {
    final Range range = getRange((Worksheet)cell.getSheet(), cell.getRowIndex(), cell.getColumnIndex());
    range.setRichEditText(value);
  }
View Full Code Here
979
980
981
982
983
984
985
986
    final Range range = getRange((Worksheet)cell.getSheet(), cell.getRowIndex(), cell.getColumnIndex());
    range.setRichEditText(value);
  }
 
  public static void mergeCells(Worksheet sheet, int tRow, int lCol, int bRow, int rCol, boolean across) {
    Range rng = getRange(sheet, tRow, lCol, bRow, rCol);
    rng.merge(across);
  }
View Full Code Here
984
985
986
987
988
989
990
991
    Range rng = getRange(sheet, tRow, lCol, bRow, rCol);
    rng.merge(across);
  }
 
  public static void unmergeCells(Worksheet sheet, int tRow, int lCol, int bRow, int rCol) {
    Range rng = getRange(sheet, tRow, lCol, bRow, rCol);
    rng.unMerge();
  }
View Full Code Here
1206
1207
1208
1209
1210
1211
1212
1213
   * @param col
   * @param px column width in pixel
   */
  public static void setColumnWidth(Worksheet sheet, int col, int px) {
    final int char256 = Utils.pxToFileChar256(px, ((Book)sheet.getWorkbook()).getDefaultCharWidth());
    final Range rng = Utils.getRange(sheet, -1 , col);
    rng.setColumnWidth(char256);
  }
View Full Code Here
1218
1219
1220
1221
1222
1223
1224
1225
   * @param row
   * @param px row height in pixel
   */
  public static void setRowHeight(Worksheet sheet, int row, int px) {
    final int points = Utils.pxToPoint(px);
    final Range rng = Utils.getRange(sheet, row, -1);
    rng.setRowHeight(points);
  }
View Full Code Here
1224
1225
1226
1227
1228
1229
1230
1231
    rng.setRowHeight(points);
  }
 
  public static void moveRows(Worksheet sheet, int tRow, int bRow, int nRow) {
    final int maxcol = ((Book)sheet.getWorkbook()).getSpreadsheetVersion().getLastColumnIndex();
    final Range rng = Utils.getRange(sheet, tRow, 0, bRow, maxcol);
    rng.move(nRow, 0);
  }
View Full Code Here
1230
1231
1232
1233
1234
1235
1236
1237
    rng.move(nRow, 0);
  }

  public static void moveColumns(Worksheet sheet, int lCol, int rCol, int nCol) {
    final int maxrow = ((Book)sheet.getWorkbook()).getSpreadsheetVersion().getLastRowIndex();
    final Range rng = Utils.getRange(sheet, 0, lCol, maxrow, rCol);
    rng.move(0, nCol);
  }
View Full Code Here
TOP

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

  • org.zkoss.zss.app.cell.CellHelper
  • org.zkoss.zss.app.MainWindowCtrl
  • org.zkoss.zss.app.PasteSpecialWindowCtrl
  • org.zkoss.zss.app.test.AutofilterComposer
  • org.zkoss.zss.app.zul.ctrl.SSWorkbookCtrl
  • org.zkoss.zss.app.zul.FormulaEditor
  • org.zkoss.zss.app.zul.Sheets
  • org.zkoss.zss.engine.fn.MathFns
  • org.zkoss.zss.engine.fn.StatFns
  • org.zkoss.zss.engine.fn.UtilFns
    • 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.