jxl.biff.formula: class: ColumnRange

jxl.biff.formula
class: ColumnRange [javadoc | source]

java.lang.Object
   jxl.biff.formula.ParseItem
      jxl.biff.formula.Operand
         jxl.biff.formula.Area
            jxl.biff.formula.ColumnRange

All Implemented Interfaces:
ParsedThing

A class to hold range information across two entire columns

Constructor:

Constructor:
ColumnRange() { super(); } Constructor
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); } Constructor invoked when parsing a string formula Parameters: `s` - the string to parse

 ColumnRange() {
      
    super();
}

Constructor

 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);
}

Constructor invoked when parsing a string formula

Parameters:

s - the string to parse

Method from jxl.biff.formula.ColumnRange Summary:
getString

Methods from jxl.biff.formula.Area:
adjustRelativeCellReferences, columnInserted, columnRemoved, getBytes, getFirstColumn, getFirstRow, getLastColumn, getLastRow, getString, handleImportedCellReferences, read, rowInserted, rowRemoved, setRangeData

Methods from jxl.biff.formula.Operand:
adjustRelativeCellReferences, columnInserted, columnRemoved, rowInserted, rowRemoved

Methods from jxl.biff.formula.ParseItem:
adjustRelativeCellReferences, columnInserted, columnRemoved, getBytes, getString, handleImportedCellReferences, isValid, isVolatile, rowInserted, rowRemoved, setAlternateCode, setInvalid, setParent, setVolatile, useAlternateCode

Methods from java.lang.Object:
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method from jxl.biff.formula.ColumnRange Detail:
public void getString(StringBuffer buf) { CellReferenceHelper.getColumnReference(getFirstColumn(), buf); buf.append(':"); CellReferenceHelper.getColumnReference(getLastColumn(), buf); } Gets the string representation of this item

Method from jxl.biff.formula.ColumnRange Detail:

 public  void getString(StringBuffer buf) {
    CellReferenceHelper.getColumnReference(getFirstColumn(), buf);
    buf.append(':");
    CellReferenceHelper.getColumnReference(getLastColumn(), buf);
}

Gets the string representation of this item