mfc grid control with drop down lists

this article was contributed by motty cohen.

 download source code and demo project

this is a previous version of chris maunder’s mfc grid control (version 1.03) with a minor bug fix and several improvements.

first a bug fix: in some situations i have managed to edit cells in fixed column, so i added a line in oneditcell() event handler to prevent it:

	if ((nrow < m_nfixedrows)||(ncol < m_nfixedcols)) return;

and the improvements:

• i had the need to delete all rows but without the fixed rows and all the column attributes (see section 3), so i add function deleteallrows().
• 
  
  
• i added an uint array:

  m_arcoltype this array holds the edit type for each column. this edit type can take one of these  values:
    

  • gvet_noedit (0x0000) – cells in this column are not editable.
    
  • gvet_editbox(0x0001) – cells in this column are editable in the old way (i.e. inplace editbox is opened for the cell).
    
  • gvet_listbox (0x0002) – cells in this column are editable in the way that an inplace listbox is opened for the user to select value for this cell.
    

  there are more styles (gvet_combobox, gvet_checkbox) that are not implemented for now. (maybe someone would take the challenge to implement those styles before i do j).

• 
  
  
• to set the column edit type i’ve changed the insertcolumn() function to set this attribute as well:

  	int  insertcolumn(lpctstr strheading, uint nformat = dt_center|dt_vcenter|dt_singleline, int ncolumn = -1, int ntype = gvet_noedit);
    

  and i added the function:

  	bool setcolumntype(int ncol, int ntype);
    

• to let the programmer to fill the inplace listboxes i’ve added virtual function:

  	virtual void filllistitems(int ncol, lparam cltlist);
   

to use the listbox cells attribute, you have to inherit your class from the cgridctrl and override the function : filllistitems. this function is called before any inplace listbox is opened in order to fill it’s items by addstring. you can set the user-defined data for each listbox item. this data is attached to the grid item’s user-defined data. (this is useful for lookup lists in the grid).

i would like to thank all the guys who contribute articles and code to this site and especially for zafir anjum and all the others who keeps this site so useful. i know i gain a lot of knowledge and save a lot of time by constantly visiting here.

last updated: 17 april 1998