Dhtmlx using translation (6) dhtmlxgrid Cell operations

 

1.1.116cellbyid (row_id, col)

Version: public version

Parameters:

Row_id: rowid

Col: column Index

Purpose: Obtain the cell object. If no parameter exists, the current selected cell object is returned.

Reference instance:

VaR cellobj = grid. cellbyid (row_id, col );

 

1.1.117cellbyindex (row_index, col)

Obtain the cell object through the row index, refer to cellbyid (row_id, col)

1.1.118cells (row_id, col)

Obtain the cell object through the row ID and column index. For more information, see cellbyid (row_id, col)

 

1.1.119cells2 (row_index, col)

Use the row index and column index to obtain the cell object. For more information, see cellbyid (row_id, col)

 

1.1.120checkall (Mode)

Version: public version

Parameters:

Mode: True/false

Purpose: Set whether all checkpoints in the grid are selected.

Reference instance:

Mygrid. checkall (true );

 

1.1.121clearchangedstate

Version: Professional Edition

Parameters:

Purpose: Clear all status changes in the grid.

Reference instance:

Mygrid. clearchangedstate ();

 

1.1.122editcell

Version: public version

Parameters:

Purpose: Clear the cells in the grid as the editing status.

Reference instance:

1.1.123editstop

Version: public version

Parameters:

Purpose: Clear the cells in the grid as the editing status.

Reference instance:

 

1.1.124enablecolspan (Mode)

Version: Professional Edition

Parameters:

Mode: True/false

Purpose: whether cross-row operations are supported.

Reference instance:

 

1.1.125enableeditevents (click, dblclick, f2key)

Version: public version

Parameters:

Click: True | false: whether to click to enter the editing status

Dbclick: True | false whether to double-click to enter the editing status

F2key: True | false: whether to press f2 to enter the editing status

Purpose: Method for triggering the editing mode

Reference instance:

Mygrid. enableeditevents (true, false, true );

 

1.1.126enablemarkedcells (Mode)

Version: For the public version, dhtmlxgrid_markers.js is required.

Parameters:

Mode: True | false indicates whether flag is allowed.

Purpose: set the cell tag.

Reference instance:

1.1.127enablemathediting (Mode)

Version: Professional dhtmlxgrid_math.js

Parameters:

Mode: True | false: whether to allow editing

Purpose: calculate whether the cell can be edited.

Reference instance:

Mygrid. enablemathediting (true );

 

1.1.128foreachcell (rowid, custom_code)

Version: For the public version, see foreachrow_custom_code.

1.1.129getcombo (col_ind)

Version: public version

Parameters:

Col_ind: column Index

Purpose: Obtain the combo object of the current column.

Reference instance:

VaR combo = mygrid. getcombo (0 );

 

1.1.130getcustomcombo (ID, IND)

Version: public version

Parameters:

ID: Row ID

IND: column Index

Purpose: current custom combo object

Reference instance:

VaR combo = mygrid. getcustomcombo ("row1", 0 );

 

1.1.20.getmarked

Version: For the public version, dhtmlxgrid_markers.js is required.

Parameters:

Purpose: current mark cell array (row ID/column index)

Reference instance:

VaR markedarray = mygrid. getmarked ();

 

1.1.132getselectedcellindex

Version: public version

Parameters:

Purpose: return the selected cell index. If no cell index is selected, return-1.

Reference instance:

VaR ind = mygrid. getselectedcellindex ();

 

1.1.133mark (RID, cIndex, FL)

Version: For the public version, dhtmlxgrid_markers.js is required.

Parameters:

RID: Row ID

CIndex: column Index

FL: True/false

Purpose: Set whether the cell is in the flag status.

Reference instance:

 

1.1.134selectcell (R, CIND, FL, preserve, edit, show)

Version: public version

Parameters:

R: Row index or row object

CIND: cell index

FL: True/false whether to call the onrowselect event

Preserve: True/false whether to save the original status

Edit: True/false check whether the selected cell is changed to edit status

Show: True/false auto-scroll Selection

Purpose: select a cell.

Reference instance:

 

1.1.135setcellexcelltype (rowid, cellindex, type)

Version: Professional Edition

Parameters:

Rowid: Row ID

Cellindex: cell index

Type: cell type

Purpose: set the cell type.

Reference instance:

Mygrid. setcellexcelltype ("row1", 1, "TXT ");

 

1.1.136setcelltextstyle (row_id, IND, stylestring)

Version: public version

Parameters:

Rowid: Row ID

Cellindex: cell index

Stylestring: style string

Purpose: set the cell style.

Reference instance:

Mygrid. setcelltextstyle ("row1", 0, "color: red; Border: 1px solid gray ;");

 

1.1.137setcolspan (row_id, col_ind, colspan)

Version: Professional Edition

Parameters:

Row_id: Row ID

Col_index: column Index

Colspan: Number of merged Cells

Purpose: set the cell style.

Reference instance:

Mygrid. enablecolspan (true );

// Merge first 2 cells in the row with ID "row1"

Mygrid. setcolspan ("row1", 0, 2 );

 

1.1.138setdateformat (mask)

Version: Professional Edition

Parameters:

Mask: Time Format

Purpose: set the cell time format. It only applies to "dhxcalendar" and "dhxcalendara"

Reference instance:

Mygrid. setdateformat ("% m/% d/% Y ");

 

1.1.139seteditable (Mode)

Version: public version

Parameters:

Mode: True/false

Purpose: Set whether the grid can be edited.

Reference instance:

 

1.1.140setmathround (digits)

Version: Professional Edition

Parameters:

Digits: True/false

Purpose: set the exact number of digits in a digital table in the grid.

Reference instance:

Mygrid. setmathround (2 );

 

1.1.141setnumberformat (mask, CIND, p_sep, d_sep)

Version: Professional Edition

Parameters:

Mask: Format

CIND: column Index

P_sep: decimal point is a format symbol

D_sep: integer grouping symbol

Purpose: set the number formatting in the grid.

Reference instance:

Mygrid. setnumberformat ("0,000.00", index ,".",",");

 

1.1.142setrowspan (rowid, colind, length)

Setcolspan

1.1.143uncheckall

Version: public version

Parameters:

Purpose: Disable all checkboxes in the grid.

Reference instance:

 

1.1.144unmarkall

Version: public version

Parameters:

Purpose: clear cells in the grid.

Reference instance:

(Note: All my articles are original articles. Please indicate the source for reprinting! 20100625 is written in Shenzhen .)