public override string ToString() { CellAddr ulCa = new CellAddr(colInt.min, rowInt.min), lrCa = new CellAddr(colInt.max, rowInt.max); return(String.Format("{0}!{1}:{2}", sheet.Name, ulCa, lrCa)); }
public String Show(int col, int row, Formats fo) { switch (fo.RefFmt) { case Formats.RefType.A1: CellAddr ca = new CellAddr(this, col, row); return((colAbs ? "$" : "") + CellAddr.ColumnName(ca.col) + (rowAbs ? "$" : "") + (ca.row + 1)); case Formats.RefType.R1C1: return("R" + RelAbsFormat(rowAbs, rowRef, 1) + "C" + RelAbsFormat(colAbs, colRef, 1)); case Formats.RefType.C0R0: return("C" + RelAbsFormat(colAbs, colRef, 0) + "R" + RelAbsFormat(rowAbs, rowRef, 0)); default: throw new ImpossibleException("Unknown reference format"); } }
public FullCellAddr(Sheet sheet, CellAddr ca) { this.ca = ca; this.sheet = sheet; }
// Does this raref at (col, row) refer inside the sheet? public bool ValidAt(int col, int row) { CellAddr ca = new CellAddr(this, col, row); return(0 <= ca.col && 0 <= ca.row); }