The SDIGrid control is part of the CodeGuru project. It is a version, improved by Michael Lombardi, of the MFCGridCtrl. To see a sample program using this control, look at SDIGrid in the Sample folder, contributed by Robert Slack. The actual control, SDIGrid.ocx, is installed with NS Basic/Desktop.

The following is shared from the original article by Chris Maunder at the CodeProject site. We reproduce it here for convenience. Please note that the links in the article are relative to its position in the CodeProject website. If you link back to the orginal article, most work properly. The documentation is for the full control as implemented by Chris Maunder. The actual control that is usable from NS Basic/Desktop is the ActiveX version of the control, which is a subset of the full control, so not all functions and methods described below are available.

Introduction	General appearance and features	Structures, defines and Messages
Files	Colours	Protected overridable functions
Constuction	General cell information	Clipboard
Number of rows and columns	Operations	Acknowledgements
Sizing and position functions	Printing	History

Introduction

After pushing the CListCtrl to its limits in trying to display and edit tabulated data I decided what was really needed was a dedicated grid control. I started writing my own grid control from scratch but decided to save time by modifying Joe Willcoxson's free WorldCom grid control. I tore apert his code and rebuilt it from the ground up in order to get it to do all the things I needed. The code has gone through so many modifications that I'm not sure if there is even a single original line of code. In any case Joe's code was a great framework on which to build.

The project started out as a simple clean up but very quickly ballooned into a bit of a nightmare as I kept finding new features that I felt just had to go into it. It has not been tested exhaustively - but I'm fairly confident that it won't fall over too badly :). Joe was kind enough to allow me to release the source with no strings attached (since it is based on his code) but since the project was such a marathon I am placing a couple of very minor conditions on the use of this code:

The control features:

• Cell selection using the mouse, with optional Control and Shift key combinations. Selection can be disabled.
• Row and Column resizing. Sizing can be diabled for row, columns or both.
• Auto row or column sizing when dividers are double-clicked.
• Any number of fixed rows and columns.
• Individual cells can have separate text and background colours.
• Individual cells can have separate fonts.
• Individaul cells can be marked "Read-Only", or have their modification status set and checked.
• OLE Drag and drop.
• Ctrl-C, Ctrl-X and Ctrl-V perform clipboard copy, cut and paste, and Ctrl-A for "Select All"
• In place editing of cell contents. If a character key is pressed while a cell has focus, editing will start on that cell, and the arrow keys will allow navigation to other keys. If the current focus cell is clicked on, editing will start and the arrow keys will move the carot inside the edit control. Editing can be disabled.
• Support for Microsoft intellimouse.
• Optional grid lines.
• Images in any cell
• Full printing support, for either a Doc/View environment (inc Print preview) or a standalone dialog based app (no print preview).
• Optional "List mode", including full row selection, single row selection, and sort on column header click.
• Numerous virtual functions to allow this control to be extended very easily.
• UNICODE support.
• WinCE support
• Titletips for cells that are too small to display their data.
• Compiles under VC 4.2, 5.0, 6.0 and under the CE toolkit version 2.0 and 3.0

Files

To use the Grid control in your project you will need to add a number of files to your project:

	gridctrl.cpp, gridctrl.h	Main grid control source and header files.
	CellRange.h	Definition of CCellID and CCellRange helper classes.
	MemDC.h	Keith Rule's memory DC helper class.
	InPlaceEdit.cpp, InPlaceEdit.h	In-place edit windows source and header files.
	GridDropTarget.cpp, GridDropTarget.h	Grid control OLE drag and drop target. Only necessary if you don't define GRIDCONTROL_NO_DRAGDROP in gridctrl.h
	Titletip.cpp, Titletip.h	Titletips for cells, from www.codeguru.com Only necessary if you don't define GRIDCONTROL_NO_TITLETIPS in gridctrl.h

Constuction

The underlying class of the grid control is CGridCtrl which is derived from CWnd. To use it, either use the MS Visual C++ dialog editor to place a custom control on a dialog, and enter "MFCGridCtrl" (no quotes) as the Class name, or use CGridCtrl::Create:

        CGridCtrl(int nRows = 0, int nCols = 0, int nFixedRows = 0, int nFixedCols = 0);
        BOOL Create(const RECT& rect, CWnd* parent, UINT nID,
                    DWORD dwStyle = WS_CHILD | WS_BORDER | WS_TABSTOP | WS_VISIBLE);

        void AFXAPI DDX_GridControl(CDataExchange* pDX, int nIDC, CGridCtrl&rControl);

DDX_GridControl is used where a DDX_Control call is needed. It is necessary to use DDX_GridControl instead of DDX_Control when creating the control via a dialog template in order to ensure that the grid is correctly registered as a drag and drop target. This is to avoid a strange COleDropTarget::Register error that occurs in win95.

Number of rows and columns

int  GetRowCount() const

int  GetColumnCount() const

int  GetFixedRowCount() const

int  GetFixedColumnCount() const

BOOL SetRowCount(int nRows)

BOOL SetColumnCount(int nCols)

BOOL SetFixedRowCount(int nFixedRows = 1)

BOOL SetFixedColumnCount(int nFixedCols = 1)

Sizing and position functions

int GetRowHeight(int nRow) const

BOOL SetRowHeight(int row, int height)

int GetColumnWidth(int nCol) const

BOOL SetColumnWidth(int col, int width)

int GetFixedRowHeight() const

int GetFixedColumnWidth() const

long GetVirtualHeight() const

long GetVirtualWidth() const

BOOL GetCellOrigin(int nRow, int nCol, LPPOINT p)

BOOL GetCellOrigin(const CCellID& cell, LPPOINT p)

BOOL GetCellRect(int nRow, int nCol, LPRECT pRect)

BOOL GetCellRect(const CCellID& cell, LPRECT pRect)

BOOL GetTextRect(int nRow, int nCol, LPRECT pRect)t

BOOL GetTextRect(const CCellID& cell, LPRECT pRect)

General appearance and features

void SetImageList(CImageList* pList)

CImageList* GetImageList()

void SetGridLines(int nWhichLines = GVL_BOTH)

int GetGridLines() 

void SetEditable(BOOL bEditable = TRUE)

BOOL IsEditable()

void SetModified(BOOL bModified = TRUE,
                 int nRow = -1, int nCol = -1)

BOOL GetModified(int nRow = -1, int nCol = -1)

void SetListMode(BOOL bEnableListMode = TRUE)

BOOL GetListMode()

void SetSingleRowSelection(BOOL bSing = TRUE)

BOOL GetSingleRowSelection()

void EnableSelection(BOOL bEnable = TRUE)

BOOL IsSelectable()

void EnableDragAndDrop(BOOL bAllow = TRUE)

BOOL GetDragAndDrop()

void SetRowResize(BOOL bResize = TRUE) 

BOOL GetRowResize()

void SetColumnResize(BOOL bResize = TRUE)

BOOL GetColumnResize()

void SetHeaderSort(BOOL bSortOnClick = TRUE)

BOOL GetHeaderSort()

void SetHandleTabKey(BOOL bHandleTab = TRUE)

BOOL GetHandleTabKey()

void SetDoubleBuffering(BOOL bBuffer = TRUE)

BOOL GetDoubleBuffering()

void EnsureVisible(CCellID &cell)

BOOL IsCellVisible(CCellID &cell) const

BOOL IsCellVisible(CCellID cell) const

BOOL IsCellEditable(CCellID &cell) const

BOOL IsCellEditable(CCellID cell) const

void EnsureVisible(int nRow, int nCol)

void EnableTitleTips(BOOL bEnable = TRUE)

BOOL GetTitleTips()

BOOL IsCellFixed(int nRow, int nCol)

Colours

void SetTextColor(COLORREF clr)

COLORREF GetTextColor()

void SetTextBkColor(COLORREF clr)

COLORREF GetTextBkColor() 

void SetFixedTextColor(COLORREF clr)

COLORREF GetFixedTextColor()

void SetFixedBkColor(COLORREF clr)

COLORREF GetFixedBkColor() 

void SetBkColor(COLORREF clr)

COLORREF GetBkColor() 

void SetGridColor(COLORREF clr)

COLORREF GetGridColor() 

See also the Individual Cell colour functions that allow an individual cell's colours to be changes seperate to the rest of the grid.

General cell information

int GetSelectedCount()

CCellID GetFocusCell()

BOOL SetItem(const GV_ITEM* pItem)

BOOL GetItem(GV_ITEM* pItem)

BOOL SetItemText(int nRow, int nCol, LPCTSTR str)

virtual CString GetItemText(int nRow, int nCol)

BOOL SetItemData(int nRow, int nCol, LPARAM lParam)

LPARAM GetItemData(int nRow, int nCol) const

BOOL SetItemImage(int nRow, int nCol, int iImage)

int GetItemImage(int nRow, int nCol) const

BOOL SetItemState(int nRow, int nCol, UINT state)

UINT GetItemState(int nRow, int nCol) const

BOOL SetItemFormat(int nRow, int nCol, UINT nFormat)

UINT GetItemFormat(int nRow, int nCol) const

BOOL SetItemBkColour(int nRow, int nCol,  
                     COLORREF cr = CLR_DEFAULT)

COLORREF GetItemBkColour(int nRow, int nCol) const

BOOL SetItemFgColour(int nRow, int nCol,  
                     COLORREF cr = CLR_DEFAULT)

COLORREF GetItemFgColour(int nRow, int nCol) const

BOOL SetItemFont(int nRow, int nCol, LOGFONT* lf)

LOGFONT* GetItemFont(int nRow, int nCol) const

Operations

int InsertColumn(LPCTSTR strHeading,  
                 UINT nFormat, int nColumn = -1)

int InsertRow(LPCTSTR strHeading, int nRow = -1)

BOOL DeleteColumn(int nColumn)

BOOL DeleteRow(int nRow)

BOOL DeleteAllItems()

BOOL DeleteNonFixedRows()

BOOL AutoSizeRow(int nRow)

BOOL AutoSizeColumn(int nCol)

void AutoSizeRows()

void AutoSizeColumns()

void AutoSize()

void ExpandColumnsToFit()

void ExpandRowsToFit()

void ExpandToFit()

CSize GetTextExtent(LPCTSTR str,  
                    BOOL bUseSelectedFont = TRUE)

void SetRedraw(BOOL bAllowDraw,  
               BOOL bResetScrollBars = FALSE)

BOOL RedrawCell(int nRow, int nCol, CDC* pDC = NULL)

BOOL RedrawCell(const CCellID& cell, CDC* pDC = NULL)

BOOL RedrawRow(int row)

BOOL RedrawColumn(int col)

CCellRange GetCellRange()

void SetSelectedRange(const CCellRange& Range, 
                      BOOL bForceRepaint = FALSE);

void SetSelectedRange(int nMinRow, int nMinCol,  
                      int nMaxRow, int nMaxCol,  
                      BOOL bForceRepaint = FALSE);

BOOL IsValid(int nRow, int nCol)

BOOL IsValid(const CCellID& cell)

BOOL IsValid(const CCellRange& range)

CCellID GetNextItem(CCellID& cell, int nFlags) const

BOOL SortTextItems(int nCol, BOOL bAscending)

BOOL SortItems(PFNLVCOMPARE pfnCompare, int nCol,  
              BOOL bAscending, LPARAM data = 0)

Printing

void Print()

virtual void OnBeginPrinting(CDC *pDC, CPrintInfo *pInfo)

virtual void OnPrint(CDC *pDC, CPrintInfo *pInfo)

virtual void OnEndPrinting(CDC *pDC, CPrintInfo *pInfo)

Structures, defines and Messages

The CCellID class. This is a handy helper class used to reference individual cells. All members are public. This class is adapted from Joe Willcoxsons original implementation.

class CCellID
{
public:
    int row, col; // The zero based row and column of the cell.

    CCellID(int nRow = -1, int nCol = -1)

    int IsValid();
    int operator==(const CCellID& rhs);
    int operator!=(const CCellID& rhs);
}

The CCellRange class. This is a handy helper class used to reference cell ranges. This class is adapted from Joe Willcoxsons original implementation.

class CCellRange
{
public:
    CCellRange(int nMinRow = -1, int nMinCol = -1, int nMaxRow = -1, int nMaxCol = -1);
    void Set(int nMinRow = -1, int nMinCol = -1, int nMaxRow = -1, int nMaxCol = -1);

    int  IsValid() const;
    int  InRange(int row, int col) const;       // Is the row/col in the range?
    int  InRange(const CCellID& cellID) const;  // is the cell in the range?

    CCellID  GetTopLeft() const;                // Get topleft cell in range
    CCellRange Intersect(const CCellRange& rhs) const; 
                                                // Returns the intersection of
                                                // two cell ranges

    int GetMinRow() const;                      // Self explanatory
    void SetMinRow(int minRow);
    int GetMinCol() const;
    void SetMinCol(int minCol);
    int GetMaxRow() const;
    void SetMaxRow(int maxRow);
    int GetMaxCol() const;
    void SetMaxCol(int maxCol);

    int GetRowSpan() const;                    // Number of rows spanned
    int GetColSpan() const;                    // Number of columns spanned

    int  operator==(const CCellRange& rhs);
    int  operator!=(const CCellRange& rhs);
}

The GV_ITEM structure. This structure is used for Get/SetItem calls.

typedef struct _GV_ITEM {
        int      row,col;   // Row and Column of item
        UINT     mask;      // Mask for use in getting/setting cell data
        UINT     state;     // cell state (focus/hilighted etc)
        UINT     nFormat;   // Format of cell. Default imaplentation used CDC::DrawText formats
        CString  szText;    // Text in cell
        int      iImage;    // index of the list view items icon
        COLORREF crBkClr;   // Background colour (or CLR_DEFAULT)
        COLORREF crFgClr;   // Forground colour (or CLR_DEFAULT)
        LPARAM   lParam;    // 32-bit value to associate with item
        LOGFONT  lfFont;    // cell font
} GV_ITEM;

GVL_NONE       - No grid lines
GVL_HORZ       - Horizontal lines only
GVL_VERT       - Vertical lines only
GVL_BOTH       - Both vertical and horizontal lines

GVIF_TEXT       - Cell text will be accessed
GVIF_IMAGE      - Cell image number will be accessed
GVIF_PARAM      - Cell user data (lParam) will be accessed
GVIF_STATE      - Cell state will be accessed
GVIF_BKCLR      - Cell background colour will be accessed
GVIF_FGCLR      - Cell foreground colour will be accessed
GVIF_FORMAT     - Cell format field will be accessed
GVIF_FONT        - Cell logical font will be accessed

GVIS_FOCUSED      - Cell has focus
GVIS_SELECTED     - Cell is selected
GVIS_DROPHILITED  - Cell is drop highlighted
GVIS_READONLY     - Cell is read-only and cannot be edited
GVIS_FIXED        - Cell is fixed (not used)
GVIS_MODIFIED     - Cell has been modified

GVNI_FOCUSED      - Search for focus cell
GVNI_SELECTED     - Search for selected cells
GVNI_DROPHILITED  - Search for drop highlighted cells
GVNI_READONLY     - Search for read-only cells
GVNI_FIXED        - Search for fixed cells (not used)
GVNI_MODIFIED     - Search for modified cells

GVNI_ABOVE        - Search above initial cell
GVNI_BELOW        - Search below initial cell
GVNI_TOLEFT       - Search to the left of the initial cell
GVNI_TORIGHT      - Search to the right of the initial cell
GVNI_ALL          - Search all cells in the grid starting from the given cell
GVNI_AREA         - Search all cells below and to the right of the given cell

GVN_BEGINDRAG       - Sent when dragging starts
GVN_BEGINLABELEDIT  - Sent when inplace editing starts
GVN_ENDLABELEDIT    - Sent when inplace editing stops

These messages are exactly the same as their LVN_... counterparts, except they use an NM_GRIDVIEW structure:

typedef struct tagNM_GRIDVIEW {
    NMHDR hdr;
    int   iRow;
    int   iColumn;
} NM_GRIDVIEW;

Protected overridable functions

These functions have been made virtual to aid extensiblity.

Printing - called in OnPrint.

virtual void PrintColumnHeadings(CDC *pDC, CPrintInfo *pInfo);
virtual void PrintHeader(CDC *pDC, CPrintInfo *pInfo);
virtual void PrintFooter(CDC *pDC, CPrintInfo *pInfo);

Drag n' drop

virtual CImageList* CreateDragImage(CPoint *pHotSpot) - No longer necessary but I
                                                        thought the code was cool so
                                                        kept it :).

Mouse Clicks

virtual void OnFixedColumnClick(CCellID& cell);
virtual void OnFixedRowClick(CCellID& cell);

Editing

virtual void OnEditCell(int nRow, int nCol, UINT nChar)     - Starting edit
virtual void OnEndEditCell(int nRow, int nCol, CString str) - ending edit
virtual void CreateInPlaceEditControl(CRect& rect, DWORD dwStyle, int nRow, int nCol,
                                      LPCTSTR szText, int nChar) - Create the inplace edit control

Drawing

virtual CSize GetCellExtent(int nRow, int nCol, CDC* pDC)   - Returns Size of cell
                                                              according to cell
                                                              contents.
virtual void OnDraw(CDC& origDC);                           - Draws everything
virtual BOOL DrawFixedCell(CDC* pDC, int nRow, int nCol,    - Draws Fixed cells
                           CRect rect, BOOL bEraseBk=FALSE)
virtual BOOL DrawCell(CDC* pDC, int nRow, int nCol,         - Draws normal cells
                      CRect rect, BOOL bEraseBk=FALSE)

Construction and Cleanup

virtual CGridCell* CreateCell(int nRow, int nCol)           - Creates a new cell and
                                                              initialises it.
virtual void EmptyCell(CGridCell* cell, int nRow, int nCol) - Performs any cleanup
                                                              necessary before removing
                                                              cells

Clipboard

A number of Clipboard functions have been included.

virtual void OnEditCut()	Copies contents of selected cells to clipboard and deletes the contents of the selected cells. (Ctrl-X)
virtual void OnEditCopy()	Copies contents of selected cells to clipboard. (Ctrl-C)
virtual void OnEditPaste()	Pastes the contents of the clipboard to the grid. (Ctrl-V)
virtual void OnEditSelectAll()	Not actually a clipboard function, but handy nevertheless. This routine selects all cells in the grid. (Ctrl-A)

Acknowledgements

This would not have been possible without the following authors making their code freely available:

• Joe Willcoxson: Joe's original code spurred this project on, and provided the basic structure of this grid control.
• Keith Rule: Keith provided a neat CMemDC class to make flicker free display simple, and provided sample OLE copy/paste/drag/drop code.
• Ravi Reddy: I used a derivation of Ravi's listview printing code.
• Zafir Anjum: Provided the starting point for my CInPlaceEdit, the sorting routines and the TitleTip code, and is the site maintainer for The MFC Programmers Sourcebook, at www.codeguru.com. Zafir has done a great job of allowing devlopers to swap code and learn from each other.
• All those who contribute to the MFC Programmers Sourcebook: Without you all I would not have been able to write this.
• All those who sent in bug reports, suggestions, improvements and encouragement. Thank you!

History

Version

1.00     20 Feb 1998	First release version.
1.01     24 Feb 1998	Memory leak fix (Jens Bohlmann ) Mistype in CMemDC.h - Claus Arend-Schneider Bug in GetSelectedCount - Lyn Newton
1.02     4 Mar 1998	Scrolling a little neater (less dead area) Cell selection via OnTimer correctly updates Focus cell
1.03     31 Mar 1998	OnEditCopy, OnEditCut and OnEditPaste clipboard functions added. Ctrl-X,Ctrl-C and Ctrl-V now initiate clipboard cut, copy and paste. Support for OLE drag and drop. Support for Microsoft intellimouse. "DeleteContents" changed to "DeleteAllItems". ExpandRowsToFit and ExpandColumnsToFit added. Added SetHeaderSort and GetHeaderSort. ExpandRowsToFit and ExpandColumnsToFit added. Selected cell IDs now stored in a map instead of an array. Scrolling and scroll selection tweaked a little. Several minor bugs fixed. LVN_ENDLABELEDIT now handled using ON_NOTIFY_REFLECT_EX so the parent can handle it too. GetItemText() now public.
1.04     5 April 1998	Added Ctrl-A = OnEditSelectAll. Fixed CGridDropTarget double register problem Minor bug in CopyTextFromGrid (assert on empty string) fixed. Cleaned up reponse to m_bEditable (OnDrop and Ctrl-X disabled).
1.05     10 May 1998	Memory leak fixed. (Yuheng Zhao) Changed OLE initialisation (Carlo Comino) Added separate fore + background cell colours (John Crane). ExpandToFit etc cleaned up - now decreases and increases cell sizes to fit client area. Added notification messages for the grid's parent Added GVIS_READONLY state
1.06     20 May 1998	Added TAB key handling (Use Get/SetHandleTabKey to toggle). (Daniela Rybarova) Intellimouse code correction for whole page scrolling (Paul Grant) Fixed 16 bit thumb track problems (now 32 bit) (Paul Grant) Fixed accelerator key problem in CInPlaceEdit (Matt Weagle) Fixed Stupid ClassWizard code parsing problem (Michael A. Barnhart) Double buffering now programmatically selectable (Use Get/SetDoubleBuffering) Workaround for win95 drag and drop registration problem Corrected UNICODE implementation of clipboard stuff Dragging and dropping from a selection onto itself no no longer causes the cells to be emptied
1.07     26 July 1998	Added EnsureVisible (Roelf Werkman) Fixed delete key problem on read-only cells (Serge Weinstock) OnEndInPlaceEdit sends notification AFTER storing the modified text in the cell. Added CreateInPlaceEditControl to make it easier to change the way cells are edited. (suggested by Chris Clark) Added Set/GetGridColor. Tweaked CopyTextToClipboard a little. SetModified called when cutting text or hitting DEL. (Jonathan Watters) Focus cell made visible when editing begins. Blank lines now treated correctly when pasting data Removed ES_MULTILINE style from the default edit control Added virtual CreateCell(row, col) function for cell creation and initialisation. Fonts now specified on a per-cell basis using Get/SetItemFont
1.08     6 Aug 1998	Ctrl+arrows now allows cell navigation. Modified CreateInPlaceEditControl to accept ID of control. Added Titletips to grid cells. (Added EnableTitleTips / GetTitleTips)
1.09     12 Sep 1998	When printing, parent window title is printed in header - Gert Rijs GetNextItem search with GVNI_DROPHILITED now returns cells with GVIS_DROPHILITED set, instead of GVIS_FOCUSED (Franco Bez) (Also fixed minor bug in GetNextItem) (Franco Bez) Cell selection using Shift+arrows works - Franco Bez SetModified called after edits ONLY if contents changed (Franco Bez) Cell colours now dithered in 256 colour screens. Support for MSVC 4.2 (Graham Cheetham)
1.10     29 Nov 1998	Titletips now disappear on a scroll event. Compiler errors fixed. Grid lines drawing fixed (Graham Cheetham). Cell focus fix on Isert Row/Col (Jochen Kauffmann) Added DeleteNonFixedRows() (John Rackley) Message #define conflict fixed (Oskar Wieland) Titletips & cell insert/delete fix (Ramesh Dhar) Titletips repeat-creation bug fixed. GVN_SELCHANGED message now sends current cell ID Font resource leak in GetTextExtent fixed (Gavin Jerman) More TAB fixes (Andreas Ruh) ID_EDIT_* handlers added.
1.11     2 Dec 1998	GetNextItem bug fix (suggested by Francis Fu) InsertColumn (-1) fix (Roy Hopkins) Was too liberal with the "IsEditable"'s. oops. (Michel Hete) Made IsCellVisivle public, and added IsCellEditable.
1.11a     4 Jan 1999	Compiler errors in VC6 fixed.
1.12     10 Apr 1999	Cleanup to allow GRIDCONTROL_NO_CLIPBOARD define CE #defines added. (Thanks to Frank Uzzolino for a start on this) TitleTip display fixed for cells with images, plus it now uses cell font Added GetTextRect and IsCellFixed Focus change problem when resizing columns fixed (Sergey Nikiforenko) Grid line drawing problem in fixed cells fixed (Sergey Nikiforenko) CreateCell format persistance bug fixed (Sergey Nikiforenko) DeleteColumn now returns TRUE (oops) (R. Elmer) Enter, Tab and Esc key problem (finally) fixed - Darren Webb and Koay Kah Hoe OnSize infinite loop fixed - Steve Kowald GVN_SELCHANGING and GVN_SELCHANGED values changed to avoid conflicts (Hiroaki Watanabe) Added single row selection mode (Yao Cai) Mollified image drawing clip problem slightly (still not happy with it) Reduced unnecessary redraws significantly GetNextItem additions and bug fix, and GVNI_AREA search option (Franco Bez) Added GVIS_MODIFIED style for cells, so individual cells can have their modification status queried. (Franco Bez)

Last updated: April 10, 1999.