SheetXL - v1.0.2
    Preparing search index...

    Interface CellControlContext

    What a cell content entry writes through: guarded writes into the sheet, and the notifier for anything else it has to say. One per layer; every entry of the layer shares it.

    interface CellControlContext {
        notifier: IReactNotifier;
        sheet: IWorksheet;
        setCellValue(cell: ICell, value: Scalar): boolean;
        setRangeValue(range: ICellRange, value: Scalar): boolean;
    }
    Index
    notifier: IReactNotifier
    sheet: IWorksheet
    • Writes value into cell.

      Parameters

      • cell: ICell
      • value: Scalar

      Returns boolean

      false when the cell refuses the write: it holds a formula, or it is locked on a protected sheet (the user is told why).

    • Writes value into every cell of range that holds no formula, in one operation.

      Parameters

      • range: ICellRange
      • value: Scalar

      Returns boolean

      false when nothing was written: every cell holds a formula, or the sheet refused (a locked cell on a protected sheet; the user is told why).