Worksheets

[Bruce C. Trygstad 0]

What is the procedure to put data in a worksheet cell since LoadCell is obsolete in v9.0

[Guest]

SetWSCellFormula is the new VectorScript call for setting data into a worksheet cell.

Please see the online VectorScript function reference at http://www.nemetschek.net/support/custom/vscript/functionref/VSFunctionReference.html for more details.

[Alexandre Villares 0]

As far as I understand, If you want to put a number into a single cell you can do this:

wsHandle:=GetObject('WorksheetName'); IF wsHandle <>NIL THEN SetWSCellFormula ( wsHandle, Row , Column , Row ,Column, Num2Str(0,Value) ) ;

Note Row & Columm parameters are used twice, and the Value variable is converted to a string.

[Petri Sakkinen 0]

LOADCELL still works in VW 9 so don't panic. By the time it ceases to work (VW 10? VW 11?) you may have new ideas - or perhaps the entire script has become obsolete.

Obsolete VS procedures & functions usually have been supported for at least two releases.