Tech Tip: Utility Method to Set 4D View Pro Area Selection Unit
PRODUCT: 4D | VERSION: 20 | PLATFORM: Mac & Win
Published On: March 25, 2024
Below is a utility method that will allow the selection unit to be changed.
By default, the selection unit is a cell. This can be changed to a row or a column. For example if row is set, selecting a cell will select the entire row containing the cell.
This is similar to the legacy 4D View feature of PV SET AREA PROPERTY with the pv select mode property.
Example of use:
The above will set the area's selection mode to Columns. If a use clicks on a cell or makes a selection the column(s) of the selected cells will be selected.
By default, the selection unit is a cell. This can be changed to a row or a column. For example if row is set, selecting a cell will select the entire row containing the cell.
This is similar to the legacy 4D View feature of PV SET AREA PROPERTY with the pv select mode property.
| // Method: VP_SetSelectionUnit // // Description: // Sets Selection Unit for 4D VP Area // // Parameters: // $1 - VP Area Name // $2 - Selection Mode // - 0 : cell (Default) // - 1 : row // - 2 : column // ================================================================ #DECLARE($vpArea_t : Text; $selectionMode_l : Integer) var $res_o : Object var $jsScript_t; $res_t : Text $res_o:=WA Evaluate JavaScript(*; $vpArea_t; "Utils.spread;"; Is object) If ($res_o=Null) $jsScript_t:="spread" Else $jsScript_t:="Utils.spread" End if $jsScript_t:=$jsScript_t+".getActiveSheet().selectionUnit(GC.Spread.Sheets.SelectionUnit\ [GC.Spread.Sheets.SelectionUnit["+String($selectionMode_l)+"]])" $res_t:=WA Evaluate JavaScript(*; $vpArea_t; $jsScript_t; Is text) |
Example of use:
| VP_SetSelectionUnit("ViewProAreaName"; 2) |
The above will set the area's selection mode to Columns. If a use clicks on a cell or makes a selection the column(s) of the selected cells will be selected.