/** * 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); }
/** * 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); }
/** * Returns the cell for the specified location eg. "A4", using the * CellReferenceHelper * * @param loc the cell reference * @return the cell at the specified co-ordinates */ public Cell getCell(String loc) { return getCell(CellReferenceHelper.getColumn(loc), CellReferenceHelper.getRow(loc)); }
/** * Returns the cell for the specified location eg. "A4", using the * CellReferenceHelper * * @param loc the cell reference * @return the cell at the specified co-ordinates */ public Cell getCell(String loc) { return getCell(CellReferenceHelper.getColumn(loc), CellReferenceHelper.getRow(loc)); }
/** * 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); }
column = CellReferenceHelper.getColumn(cellString); row = CellReferenceHelper.getRow(cellString);
/** * 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); }
column = CellReferenceHelper.getColumn(cellString); row = CellReferenceHelper.getRow(cellString);
/** * 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); }
/** * 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); }
/** * Constructor invoked when parsing a string formula * * @param s the string to parse */ Area(String s) { int seppos = s.indexOf(":"); Assert.verify(seppos != -1); String startcell = s.substring(0, seppos); String endcell = s.substring(seppos + 1); columnFirst = CellReferenceHelper.getColumn(startcell); rowFirst = CellReferenceHelper.getRow(startcell); columnLast = CellReferenceHelper.getColumn(endcell); rowLast = CellReferenceHelper.getRow(endcell); columnFirstRelative = CellReferenceHelper.isColumnRelative(startcell); rowFirstRelative = CellReferenceHelper.isRowRelative(startcell); columnLastRelative = CellReferenceHelper.isColumnRelative(endcell); rowLastRelative = CellReferenceHelper.isRowRelative(endcell); }
/** * Constructor invoked when parsing a string formula * * @param s the string to parse */ Area(String s) { int seppos = s.indexOf(":"); Assert.verify(seppos != -1); String startcell = s.substring(0, seppos); String endcell = s.substring(seppos + 1); columnFirst = CellReferenceHelper.getColumn(startcell); rowFirst = CellReferenceHelper.getRow(startcell); columnLast = CellReferenceHelper.getColumn(endcell); rowLast = CellReferenceHelper.getRow(endcell); columnFirstRelative = CellReferenceHelper.isColumnRelative(startcell); rowFirstRelative = CellReferenceHelper.isRowRelative(startcell); columnLastRelative = CellReferenceHelper.isColumnRelative(endcell); rowLastRelative = CellReferenceHelper.isRowRelative(endcell); }