/** * Appends the cell reference for the column and row passed in to the string * buffer * * @param column the column * @param row the row * @param buf the string buffer to append */ public static void getCellReference(int column, int row, StringBuffer buf) { jxl.biff.CellReferenceHelper.getCellReference(column, row, buf); }
/** * Constructor invoked when parsing a text string * * @param s the string being parsed */ public CellReference(String s) { column = CellReferenceHelper.getColumn(s); row = CellReferenceHelper.getRow(s); columnRelative = CellReferenceHelper.isColumnRelative(s); rowRelative = CellReferenceHelper.isRowRelative(s); }
/** * Gets the column letter corresponding to the 0-based column number * * @param c the column number * @return the letter for that column number */ public static String getColumnReference(int c) { return jxl.biff.CellReferenceHelper.getColumnReference(c); }
/** * Constructor invoked when parsing a string formula * * @param s the string to parse */ ColumnRange(String s) { int seppos = s.indexOf(":"); Assert.verify(seppos != -1); String startcell = s.substring(0, seppos); String endcell = s.substring(seppos + 1); int columnFirst = CellReferenceHelper.getColumn(startcell); int rowFirst = 0; int columnLast = CellReferenceHelper.getColumn(endcell); int rowLast = 0xffff; boolean columnFirstRelative = CellReferenceHelper.isColumnRelative(startcell); boolean rowFirstRelative = false; boolean columnLastRelative = CellReferenceHelper.isColumnRelative(endcell); boolean rowLastRelative = false; setRangeData(columnFirst, columnLast, rowFirst, rowLast, columnFirstRelative, columnLastRelative, rowFirstRelative, rowLastRelative); }
/** * Sees if the row component is relative or not * * @param s * @return TRUE if the row is relative, FALSE otherwise */ public static boolean isRowRelative(String s) { return s.charAt(getNumberIndex(s) - 1) != fixedInd; }
/** * Gets the sheet name from the cell reference string * * @param ref the cell reference * @return the sheet name */ public static String getSheet(String ref) { return jxl.biff.CellReferenceHelper.getSheet(ref); }
/** * Gets the columnn number of the string cell reference * * @param s the string to parse * @return the column portion of the cell reference */ public static int getColumn(String s) { return jxl.biff.CellReferenceHelper.getColumn(s); }
/** * Sees if the row component is relative or not * * @param s the cell * @return TRUE if the row is relative, FALSE otherwise */ public static boolean isRowRelative(String s) { return jxl.biff.CellReferenceHelper.isRowRelative(s); }
/** * Sees if the column component is relative or not * * @param s the cell * @return TRUE if the column is relative, FALSE otherwise */ public static boolean isColumnRelative(String s) { return jxl.biff.CellReferenceHelper.isColumnRelative(s); }
/** * Gets the row number of the cell reference * @param s the cell reference * @return the row number */ public static int getRow(String s) { return jxl.biff.CellReferenceHelper.getRow(s); }
/** * Constructor invoked when parsing a string formula * * @param s the string to parse */ ColumnRange(String s) { int seppos = s.indexOf(":"); Assert.verify(seppos != -1); String startcell = s.substring(0, seppos); String endcell = s.substring(seppos + 1); int columnFirst = CellReferenceHelper.getColumn(startcell); int rowFirst = 0; int columnLast = CellReferenceHelper.getColumn(endcell); int rowLast = 0xffff; boolean columnFirstRelative = CellReferenceHelper.isColumnRelative(startcell); boolean rowFirstRelative = false; boolean columnLastRelative = CellReferenceHelper.isColumnRelative(endcell); boolean rowLastRelative = false; setRangeData(columnFirst, columnLast, rowFirst, rowLast, columnFirstRelative, columnLastRelative, rowFirstRelative, rowLastRelative); }
/** * Sees if the row component is relative or not * * @param s * @return TRUE if the row is relative, FALSE otherwise */ public static boolean isRowRelative(String s) { return s.charAt(getNumberIndex(s) - 1) != fixedInd; }
/** * Gets the sheet name from the cell reference string * * @param ref the cell reference * @return the sheet name */ public static String getSheet(String ref) { return jxl.biff.CellReferenceHelper.getSheet(ref); }
/** * Gets the columnn number of the string cell reference * * @param s the string to parse * @return the column portion of the cell reference */ public static int getColumn(String s) { return jxl.biff.CellReferenceHelper.getColumn(s); }
/** * Sees if the row component is relative or not * * @param s the cell * @return TRUE if the row is relative, FALSE otherwise */ public static boolean isRowRelative(String s) { return jxl.biff.CellReferenceHelper.isRowRelative(s); }
/** * Sees if the column component is relative or not * * @param s the cell * @return TRUE if the column is relative, FALSE otherwise */ public static boolean isColumnRelative(String s) { return jxl.biff.CellReferenceHelper.isColumnRelative(s); }
/** * Gets the row number of the cell reference * @param s the cell reference * @return the row number */ public static int getRow(String s) { return jxl.biff.CellReferenceHelper.getRow(s); }
/** * Constructor invoked when parsing a text string * * @param s the string being parsed */ public CellReference(String s) { column = CellReferenceHelper.getColumn(s); row = CellReferenceHelper.getRow(s); columnRelative = CellReferenceHelper.isColumnRelative(s); rowRelative = CellReferenceHelper.isRowRelative(s); }