VS:GetWSCellFormulaN/ja

From Vectorworks Developer
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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

Description

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

PROCEDURE GetWSCellFormulaN(
worksheet :HANDLE;
row :INTEGER;
column :INTEGER;
VAR formula :DYNARRAY[] of CHAR);
def vs.GetWSCellFormulaN(worksheet, row, column):
    return formula

Parameters

worksheet HANDLE ワークシートのハンドル
row INTEGER
column INTEGER
formula DYNARRAY[] of CHAR

Example

PROCEDURE WStest;
    VAR
       worksheet : HANDLE;
       inString, outString : DYNARRAY [] OF CHAR;
BEGIN
   worksheet := CreateWS('MyWS', 5, 5);
   inString := '';
   outString := '';

   { inserts a formula into a single cell }
   inString := '=3*2';
   SetWSCellFormulaN(worksheet, 1, 2, 1, 2, inString);

   { gets formula from cell }
   GetWSCellFormulaN(worksheet, 1, 2, outString);

   AlrtDialog(outString); { the cell formula }
END;
RUN(WStest);

Version

利用可能バージョン: Vectorworks 2012