Open topic with navigation
To use the full functionality of the FarPoint Spread control, use %GRID_CREATE to create the Toolkit container window, create the ActiveX container, and load the Spread control. See Creating a container for the Spread control for information on other routines you can use.
WTSupported in traditional Synergy on Windows
window_id = %GRID_CREATE(rows, columns, license_string, [prefix], [control_name] & [, ocx_file])
On Windows, %GRID_CREATE returns the ID of the created Toolkit container window. On UNIX, this routine always returns false. On OpenVMS, it always returns true. (^VAL)
The number of rows for the initial container window size. (n)
The number of columns for the initial container window size. (n)
Your developer license string for the Spread control. (a)
(optional) The optional prefix for binding extension routines to the automatically registered %UWNDEVENTS_METHOD set and for auto‑binding control events. (See the documentation for the autobind_prefix argument for %AX_LOAD.) If you pass prefix to %GRID_CREATE, it is used in two places: for the %UWNDEVENTS_METHOD set that is registered for the Toolkit container window and for binding (AX_BIND) routines to each of the control events. (a)
(optional) The name of the control you want to load. (a)
(optional) The filename of the OCX file that contains the control. (a)
%GRID_CREATE makes it easy to add the FarPoint Spread control to a Toolkit application. You maintain only one ID: the window ID returned by %GRID_CREATE. The %GRID_CREATE routine
The resulting Toolkit container window is part of the current environment, but can be promoted to global.
To obtain your developer license string for the license_string argument, use the ActiveX Diagnostic Utility (axutl.exe). You must have installed a licensed copy of the Spread control (purchased from GrapeCity, Inc.) to get this string.
For information on the prefix argument and on causing the routines in the automatically registered method set to call routines (extensions) you’ve created, see the %AX_TKSINGLE Discussion.2
By default %GRID_CREATE loads the Spread control distributed with Toolkit. If you want to use a different version of the Spread control, you can use the control_name argument to pass a different control name, and you can use the ocx_file argument to pass the name (and path, if necessary) of a different OCX file and automatically register it.
If the Spread control cannot be loaded and the ocx_file argument
The UI Toolkit distribution includes grid.def, a file that provides definitions for constants used by the Spread control. See Examples below.
See the Spread control documentation for information on the methods, properties, and events supported by the Spread control.
The following example creates a Toolkit container, creates an ActiveX container, and loads the Spread control.
.include "WND:tools.def" .include "DBLDIR:activex.def" .include "WND:grid.def" .define D_SPREAD_LICENSE, 1234567 proc xcall u_start wndid = %grid_create(10, 40, D_SPREAD_LICENSE, "tgrid_") xcall u_window(D_PLACE, wndid, 10, 21) ctlid = %ax_tkctlid(wndid) xcall ax_set(ctlid, "Col", 1) xcall ax_set(ctlid, "Col2", 5) xcall ax_set(ctlid, "Row", 10) xcall ax_set(ctlid, "Row2", 10) xcall ax_set(ctlid, "BlockMode", TRUE) xcall ax_set(ctlid, "BackColor", RGB_VALUE(0,0,255)) xcall ax_set(ctlid, "BlockMode", FALSE) xcall ax_set(ctlid, "Row", 2) xcall ax_set(ctlid, "Col", 3) xcall ax_set(ctlid, "ForeColor", RGB_VALUE(255,0,0)) xcall ax_set(ctlid, "Text", "Hello world!") xcall ax_set(ctlid, "Action", SS_ACTION_ACTIVE_CELL) repeat begin xcall ax_input(wndid) if (g_select) exitloop end xcall u_finish .end