VS:GetWSCellFormulaN

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

Description

Returns the formula from a cell in the referenced worksheet.

PROCEDURE GetWSCellFormulaN(
               worksheet     :HANDLE;
               row           :INTEGER;
               column        :INTEGER;
               VAR formula   :DYNARRAY[] of CHAR);

def vs.GetWSCellFormulaN(worksheet, row, column):
    return formula

Parameters

worksheet		HANDLE		Handle to worksheet.
row		INTEGER		Row of cell to be queried.
column		INTEGER		Column of cell to be queried.
formula		DYNARRAY[] of CHAR		Formula contained in worksheet cell.

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

Availability: from Vectorworks 2012