VS:SetWSCellFormula/ja

.VectorScript|VectorScript ..VS:Function Reference|Function Reference ..VS:Function_Reference_Appendix|Appendix

Description

ハンドルで指定したワークシートの、指定したセルの式を設定します。

PROCEDURE SetWSCellFormula(
              worksheet     :HANDLE;
              topRow        :INTEGER;
              leftColumn    :INTEGER;
              bottomRow     :INTEGER;
              rightColumn   :INTEGER;
              formula       :STRING);

def vs.SetWSCellFormula(worksheet, topRow, leftColumn, bottomRow, rightColumn, formula):
    return None

Parameters

worksheet		HANDLE		ワークシートのハンドル
topRow		INTEGER		上の行
leftColumn		INTEGER		左の列
bottomRow		INTEGER		下の行
rightColumn		INTEGER		右の列
formula		STRING		式

Example

{ inserts a formula into a single cell }
SetWSCellFormula(h,4,2,4,2,'=3*2');

{ inserts a formula into a range of cells }
SetWSCellFormula(h,1,1,2,10,'<empty>');

{ creates a database sub-row for the record 'Part Info' }
SetWSCellFormula(h,2,0,2,0,'=DATABASE(R IN [''PART INFO''])');


///////////////////////////////////////////////////////////////

{Save the current AutoRecalc state}
state := GetWSAutoRecalcState(h);

{Turn off worksheet Auto Recalculation}
SetWSAutoRecalcState(h,false);

FOR i := 1 TO numCols DO
BEGIN
SetWSCellFormula (h, 1, i, 1, i, Num2Str (0, i));
SetWSCellFormula (h, 2, i, 2, i , Num2Str (0, i));
END;

{Restore AutoRecalc state}
SetWSAutoRecalcState(h, state);

{Now recalculate the worksheet}
RecalculateWS(h);

Version

利用可能バージョン: VectorWorks9.0

See Also

関連関数:

VS:GetWSAutoRecalcState | VS:SetWSAutoRecalcState

関連関数:

[[VS:GetWSAutoRecalcState]]

| [[VS:SetWSAutoRecalcState]]