Introduction

Since I posted my MFC grid control I've had a lot of requests asking how to use other methods of editing cells in the grid. Ken Bertelson has taken this to the extreme, with his Grid Tree control. For some this was a little too involved, so I've created a demo project that shows how to replace the default editing with a simple combo box.

Previous methods of achieving this required that a new CGridCtrl derived class be created. With the new structure in the 2.X versions of CGridCtrl it's now a lot simpler.

A new cell type

Changing the way cells are edited is simply a matter of deriving a new grid cell class from CGridCellBase (or derivatives such as CGridCell).

I'm using the In-Place list that I used in previous versions. It's not the greatest - but it does demonstrate how to replace the default editing.

The first step is to derive a new class from CGridCell - I call it CGridCellCombo - and override Edit (which initiates editing) and EndEdit (which stops editing). You can find this class in the GridCellCombo.* files.

In Edit I create a CWnd derived class that will perform the actual editing - in this case my CInPlaceList from previous versions of the grid. There are a number of things to be aware of when creating such CWnd derived Edit classes:

The control will receive the row and column to be edited, the dimensions and location of the in-place edit control, the style of control to create, the original text in the cell plus the initial character that caused editing to commence (or VK_LBUTTON if the mouse was clicked on the current cell).

Your editing control should stop editing when it loses input focus.

Your editing object should handle mouse keys in a way that allows the user to navigate between cells while editing. If the control gets an arrow key for instance, it should cancel editing and return the last key it encountered back to the grid via the GVN_ENDLABELEDIT notification message. Note that the grid control accepts Ctrl+<arrows> for navigation, so if your in-place edit control needs to use the arrows, you can always reserve Ctrl+<arrows> to move to other cells.

Your edit control should pass back information about the last key pressed before editing ended. This allows correct movement among cells

If you look at the code you will see that the grid cell derived class is merely a wrapper that creates an instance of a CInPlaceList window and then sits back with the knowledge of a job well done. The actual guts of the grid cell class are as follows:

We rely on CGridCell::OnEndEdit to set m_bEditing to FALSE and m_pEditWnd to NULL when editing has finished. CInPlaceList is also self-deleting, which saves a whole line of code in EndEdit.

The CInPlaceList does the actual work, and keeps track of issues such as the last key pressed and it's current focus state. It also has niceties such as ensuring that the drop down list is correctly sized.

The major issue is that the control must pass the necessary data back to the parent grid once editing has been completed. It uses the following code snippet in it's EndEdit method to do this:

I pass the character that initiated editing to the edit control itself so that it can deal with keys appropriately. For instance in the default edit control, if the edit control is passed a normal character or arrow key as the "initiating" key, then it will cease editing when it encounters an arrow key (to allow navigation using the keyboard). If the edit control is passed VK_LBUTTON (meaning editing was initiated by a mouse click) then arrow keys will not cause the editing to cease.

One last thing I do is ensure that the new cell displays a user hint that it is not a normal grid cell. When a cell is selected I override drawing so that a small drop down arrow is shown. The code is quite simple:

Using the new cell type

Using the new cell is simple. You can either use the Grid control's default cell instantiation method (ie. do nothing) and then call CGridCtrl::SetCellType or you can call CGridCtrl::SetDefaultCellType and then do nothing. The first option changes cells from one type to another, and is good if you only want specific cells to be affected. The second option tells the grid the class type that you want to be used at the outset, and is good if you want all cells in the grid to be of your new type.

Thanks

Thanks go to Roelf Werkman for his work in extending the CInPlaceList to allow the CBS_DROPDOWN and CBS_SIMPLE styles to be used, and thanks to Fred Ackers for moticating me to finally write this up.

Share

About the Author

Chris is the Co-founder, Administrator, Architect, Chief Editor and Shameless Hack who wrote and runs The Code Project. He's been programming since 1988 while pretending to be, in various guises, an astrophysicist, mathematician, physicist, hydrologist, geomorphologist, defence intelligence researcher and then, when all that got a bit rough on the nerves, a web developer. He is a Microsoft Visual C++ MVP both globally and for Canada locally.

His programming experience includes C/C++, C#, SQL, MFC, ASP, ASP.NET, and far, far too much FORTRAN. He has worked on PocketPCs, AIX mainframes, Sun workstations, and a CRAY YMP C90 behemoth but finds notebooks take up less desk space.

He dodges, he weaves, and he never gets enough sleep. He is kind to small animals.

Chris was born and bred in Australia but splits his time between Toronto and Melbourne, depending on the weather. For relaxation he is into road cycling, snowboarding, rock climbing, and storm chasing.

Comments and Discussions

Hi,
I have program that use MFC Grid Control with combobox columns, these comboboxes need to be able to do simple search every time the user add a char in the editbox the dropdown list will change accordingly. any help or ideas will be appreciated.

I am using MFC Grid control in both MFC Applications (exe's) and MFC DLLS. Cut (Ctrl X) seems to work fine in the EXE's, but in the DLL I get "CoInitialize has not been called" when I try to Cut. The "error" is triggered by the statement "pSource->SetClipboard()". I've tried to add CoInitialize() in several places, but nothing seems to work. Is anyone else using Grid Control in an MFC created DLL? I'm creating the DLL app via "new Project" in Visual Studio.NET 2003.