Date: 02-16-2022
Return to Index
created by gbSnippets
'Example of Switches
'e3/r50/c8/b3/m1First,Second,Third, 0,0,200,100
'e3 means tell MLG to auto append a row if needed providing something is in the cell
'r50 calls for 50 rows total
'c8 calls for 8 columns
'b3 means block selecting of rows, columns, and the entire grid is activated
'm1 active the right click menu with the following comma delimited menu items
'SWITCHES
'r #rows default is 5 rows
'c #columns default is 5 cols
'j column names
'h headers default is row+column header 1-colonly 2-rowonly 3-neither
'x Column Widths RowHeaderDefault=50 ColumnHeaderDefault=100
'y Column Extra Height Default=2 3-16 are valid values
'f font default is Arial 1-CourierNew 2-TimesRoman 3-Arial (MLG API allows others)
's fontsize default is 10 8-16 are valid sizes
'e 1 ENTER moves to next cell down (loops to the top from bottom)
'e 2 ENTER moves to next cell down (loops to next column from bottom)
'e 3 ENTER moves to next cell down (create new row if bottom row not empty)
'e 4 ENTER closes edit box but does not move
't 1 TAB moves to next cell to right (loops to 1st column of same row from last column)
't 2 TAB moves to next cell to right (loops to 1st column of next row from last column)
'b Block Selection - default is not to allow row/col selection
'b 1 allow row selection
'b 2 allow col selection
'b 3 allow row/col selection. click upper-left corner to select all
'b 4 allow only 1 row to be selected
'b 5 allow only 1 col to be selected
'b 6 allow only 1 row OR 1 col to be selected
'm 1 context menu for cells
'm 2 context menu for tabs in multi-sheet workbook
'm 3 context menu for infobar menu
'w 1 Suppress column width resizing by mouse
'a 1 display right pointing arrow in selected Row Header
'a 2 suppress auto row numbering - default is to number the rows
'd Scroll Bars (minus number then hiding of the scrollbars and selection box is ignored when the grid is out of focus.
'd 0 both scrollbars
'd 1 horz only
'd 2 vert only
'd 3 no scrollbars
'z 1 create /resize array automatically
'v Justification - minus numbers means to support multiline content
'v 1 cell/header vertically justified to bottom
'v 2 cell/header vertically justified to center
'v 3 cell/header vertically justified to top
http://www.garybeene.com/sw/gbsnippets.htm