Adding "Merge cells" support to the MFC GridControl

Download demo project - 303 Kb

Sample Image - gridcontrl.jpg

Sample Image - print.jpg

Introduction

This example demonstrates how to add "merge cells" ability to Chris Maunder's MFC Grid control (derived from CWnd).

The example modifies only two classes: CGridCellBase and CGridCtrl. In the class CGridCellBase ,the following four private member variables are added:

CCellRange m_MergeRange;
bool m_IsMergeWithOthers;
CCellID m_MergeCellID;
bool m_Hide;

Six public member functions are also added:

void UnMerge();
virtual bool IsShow() ;
virtual CCellRange GetMergeRange();
virtual bool IsMergeWithOthers();
virtual CCellID GetMergeCellID();
virtual void SetMergeCellID(CCellID cell);

In the class CGridCtrl, the following six public member functions are added:

CGridCellBase* GetCell(CCellID cell);
CCellID GetMergeCellID(CCellID cell);
void UnMergeSelectedCells();
void MergeSelectedCells();
void UnMergeCells(int nStartRow, int nStartCol, int nEndRow, int nEndCol);
void MergeCells(int nStartRow, int nStartCol, int nEndRow, int nEndCol);

Usage

Use CGridCtrl::MergeSelectedCells() and MergeCells() to merge the selected cells;
Use CGridCtrl::UnMergeSelectedCells() and UnMergeCells() to restore the selected cell to its original state.

History

1.7 fixed the bug when merging in the corner, by Luther Bruck - 2002/12/31
1.6 fixed the bug when resizing the merged row - 2002/11/20
1.5 fixed the bug when resizing the merged column - 2002/11/18
1.4 bug when printing merge cell across pages fixed - 2002/10/10
1.3 fixed cells merge added - 2002/9/27
1.2 print bug fixed - 2002/9/23
1.1 scroll bug fixed - 2002/9/18
1.0 first release - 2002/9/15

(Note that users of the Grid control are bound by Chris' copyright requirements detailed on his web page.)

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Huang Wei

Web Developer

China

Member

He got Master degree of Theory and Application of Automatic Control from Tsinghua university(Beijing,China) in 1997,from then on he has been working for Tsinghua TongFang Software Co.Ltd,Beijing China.

Article Top

Poor

Excellent

Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

You must Sign In to use this message board. (secure sign-in)

Search this forum
	Profile popups Noise Layout Per page

set color of tool bar button text

Uday P.Singh

1:57 16 Feb '12

We are trying to set the color of CToolBar button's text but we have not got any success.The following code snippet we are using are as follows

CToolBarCtrl& bar = m_wndToolBar1.GetToolBarCtrl();
bar.SetMaxTextRows(2);
bar.SetDrawTextFlags(0xffffffff, DT_WORDBREAK|DT_CENTER);

m_wndToolBar1.SetButtonText (0, _T ("Cricket")); //Set the color of this Text
m_wndToolBar1.SetButtonText (1, _T ("FootBall"));//Set the color of this Text

//To be set the size of button and image size.......................
CRect temp;
m_wndToolBar1.GetItemRect(0,&temp);
m_wndToolBar1.SetSizes(CSize(55,38),CSize(1,30));

We could change the font and size of the text using the CFont object but not its color.

We also tried the ON_WM_CTLCOLOR event but it is not being called for CFrameWnd class - ours is an MDI application and we cannot use CDialog.

Thanks

Drawing issue in merging cell

Member 3047563

3:19 27 May '11

I have merged following cells:

m_iCols = 20;
m_Grid.MergeCells(0,2,0,m_iCols-1); // 0 row
m_Grid.MergeCells(2,0,2,1); // 2 row
m_Grid.MergeCells(0,0,0,1); // 0th row
m_Grid.MergeCells(1,0,1,1); //1 row

I am using MFC grid control 2.27.

I have 20 rows and 20 columns. 4 rows are fixed row and 1 columns is fixed.

The grid visible portion has 10 rows and 6 columns. After 5th column we can view columns by scrolling. There is no problem until the grid is scrolled. But when we edit column 6 onwards and click on anywhere in grid, merged cells' text is hidden. Border of cell is not visible for merged cell and in header cell (0, 0) copies the text of cell (0, 2) cell.

SetItemBkColour function will make grid line disappear

zhuguo

1:06 30 Jun '09

Hi, I was using the grid control with merge cell function in dialog model,Find the grid line will disappear if set a lot of continuously cell bkground by SetItemBkColour function. But it's ok in document model,Who can help me or please fix the bug. Thanks
Sign In·View Thread·Permalink	2.00/5 (1 vote)

Merged cell disapears while sorting

TanmaySathe

18:14 17 Feb '09

Merged cell disapear if the cell's column is clicked.
Sign In·View Thread·Permalink

How can i generate a DLL and an OCX file for this code in your attachment?

praveen_sap

11:55 25 Jan '09

Hello, I am pretty new to this technology. Let me know if i can generate an OCX and DLL for this object? thanks.
Sign In·View Thread·Permalink	2.00/5 (2 votes)

[Message Removed]

immetoz

7:55 6 Oct '08

Spam message removed
Sign In·View Thread·Permalink

unable to download the attachment file

G Haranadh

2:48 30 Jul '08

Hi i am unable to download the attachment file. Nice talking to you. If you judge people, you have no time to love them. -- Mother Teresa
Sign In·View Thread·Permalink

print probs

zhkingsmac

16:35 7 Jul '08

the last row printed out is actually not underlined ,what is wrong? thank you zhouhao from zju
Sign In·View Thread·Permalink	2.00/5 (1 vote)

in virtual mode, merge cells function doesn't work properly

Member 4647800

21:02 6 Mar '08

when merging cells in virtual mode, it doesn't display properly. if any one would help me to fix it, i will be appreciated very much
Sign In·View Thread·Permalink	2.50/5 (4 votes)

PrintCell is wrong

andrewtruckle

20:06 5 Aug '07

I have a BIG problem since using the merged control. The CGridCellBase::PrintCell is a bit stuffed up for two fundamental reasons and I don't have the answer.

Firstly, there is a call at the start to pDC->Rectangle(rect) and this basically means avery cell gets all of the lines drawn! It is not obeying the users choices. The OnPrint function handles drawing the lines.

Also, it has some code remmed out and indicates it as disabled and this means my font colours are not showing.

How can I fix these two problems?

Thank you.

Andrew

Re: PrintCell is wrong

andrewtruckle

22:01 5 Aug '07

OK, I had a look at an older set of data files I have for the grid control and I noticed the PrintCell worked a little differently:

        else
            crFG = (GetBackClr() != CLR_DEFAULT ||
                (GetTextClr() != CLR_DEFAULT && GetTextClr() != pDefaultCell->GetTextClr())) ?
                    GetTextClr() : RGB(0, 0, 0);

This fixes my font colours. Now my print preview behaves for font colours.

As for the grid lines being drawn, I did this:

	//Used for merge cells
	//by Huang Wei
	rect.InflateRect(1,1);
//  AJT
//	pDC->Rectangle(rect);
	rect.DeflateRect(1,1);

This sorts me out. If I was using merged cells then I think I would have a problem here, but I don't. The thing is, it is the GRID that draws the cells grid lines in OnPrint just after the PrintCell call. Thus the ->Rectangle call should NOT be done in PrintCell. If anything, OnPrint should be adjusted just after the PrintCell call to allow for merged cells and thus print the boundary of the merged cell based on the GridLines parameters. I am not brave enough to do this. Smile | :)

Andy

How to save the merged grid infomation??

hhuwangzhp1980

18:01 26 Jun '07

Thx for your great work~ I want to save the infomation of merged grid in database,for showing the grid in next time,thank U! leon
Sign In·View Thread·Permalink	1.50/5 (2 votes)

Adding a BITMAP

hodeck~

20:08 10 Sep '06

Thx for your great work~ I want to add a bitmap file on a merged cell... or just on a cell.... Is there any way to do that????
Sign In·View Thread·Permalink	2.00/5 (1 vote)

Has anyone got this working properly in v2.26 ?

jfougero

17:05 4 Sep '06

I have it working by copying in the 4 files (which are v2.24) into the 2.26 code. however, there are problems (such as grid lines not showing up on colored backgrounds). There were several things changed from 224 to 226, but I do not have the older sources, so I can not tell what was changed.

If someone has the original 2.24 source files (prior to the Mergecell changes), That would also work, as a set of diff files can be created, to obtain JUST the modifications needed by the Mergecell functions.

TIA, Jim.

Re: Has anyone got this working properly in v2.26 ?

hamo2008

20:05 27 Nov '06

I have done this work, visit http://www.ucosoft.com/archives/25.html for more detail. Enjoy it. ---- You have noting to lost, but everything to gain. http://www.ucosoft.com
Sign In·View Thread·Permalink

Re: Has anyone got this working properly in v2.26 ?

Member 3821640

23:56 26 Jun '08

I complete this. compare file with the UltraEdit's then modify the file of 2.26 version It compile successful and run successful If you want to get the code, Then Mail Me,please; My Mail is geoh#vip.qq.com (replace # to @) the mail's subject must be MFC Grid Control with Merge! Thanks,My English is bad,Sorry
Sign In·View Thread·Permalink	2.00/5 (2 votes)

bug: Merge the merged cells --fixed

hamo2008

5:40 26 Jul '06

when merge cells in which some are already merged, the result is wrong. To fix this bug,you have to adjust the merged range to the actual range.

here is my solution:



void CGridCtrl::MergeCells(int nStartRow, int nStartCol, int nEndRow, int nEndCol)

{

	// fixed the actual range, when some cells have already merged.

        // by hamo2008@gmail.com

	int nMinRow= nStartRow,nMaxRow= nEndRow,nMinCol= nStartCol,nMaxCol= nEndCol;

	for (int row1=nStartRow;row1<=nEndRow;row1++) 

	{

		for (int col1=nStartCol;col1<=nEndCol;col1++) 

		{

			CGridCellBase *pCell= (CGridCellBase*)GetCell(row1,col1);

			ASSERT(pCell);

			if (pCell->IsMerged()) {

				CCellRange range=pCell->GetMergeRange();

				nMinRow = min(nMinRow,range.GetMinRow());

				nMinCol = min(nMinCol,range.GetMinCol());

				nMaxRow = max(nMaxRow,range.GetMaxRow());

				nMaxCol = max(nMaxCol,range.GetMaxCol());

			}

		}

	}

 

	nStartRow	= nMinRow;

	nEndRow		= nMaxRow;

	nStartCol	= nMinCol;

	nEndCol		= nMaxCol;

 

        // below is the original code

	for(int row=nStartRow;row<=nEndRow;row++) 

        //....

}

----
You have nothing to lost, but everything to gain.
http://www.ucosoft.com

Problem deleting rows

andrewtruckle

1:39 8 Jun '06

I can delete rows grom the grid , even when there are merged rows. but, if my very last row is merged, it crashes.
Sign In·View Thread·Permalink	1.00/5 (1 vote)

Re: Problem deleting rows

andrewtruckle

3:53 8 Jun '06

Surely this code is wrong?

void CGridCellBase::operator=( CGridCellBase& cell)

{

	if (this == &cell) return;

 

    SetGrid(cell.GetGrid());    // do first in case of dependencies

 

    SetText(cell.GetText());

    SetImage(cell.GetImage());

    SetData(cell.GetData());

    SetState(cell.GetState());

    SetFormat(cell.GetFormat());

    SetTextClr(cell.GetTextClr());

    SetBackClr(cell.GetBackClr());

    SetFont(cell.IsDefaultFont()? NULL : cell.GetFont());

    SetMargin(cell.GetMargin());

//Used for merge cells

//by Huang Wei

	SetMergeCellID(cell.GetMergeCellID());

	SetMergeRange(cell.GetMergeRange());

	Show(cell.IsShow());

}

When you look at SetMergeRange:

//Used for merge cells

//by Huang Wei

void CGridCellBase::SetMergeRange(CCellRange range)

{

	m_MergeRange=range;

	m_bBaseForMerged = 1;

}

It always sets the cell as a merged base cell. But what if it not actually a merged cell in the first place that you are copying or doing stuff with? I wonder if this is the cause of my crashes.

I would have thought that it should be passing in the state of the cell.XXXXX merging properties.

Can some one help me here?

Re: Problem deleting rows - FIXED!

andrewtruckle

3:01 9 Jun '06

The bug sniffer has been at work. Do this to avoid the problems:

Step 1:

In CGridCellBase operator= change:

SetMergeRange(cell.GetMergeRange());

	SetMergeRange(cell.GetMergeRange());
	m_bBaseForMerged = cell.IsBaseForMerged();

The bug in SetMergeRange is here:

void CGridCellBase::SetMergeRange(CCellRange range)

{

	m_MergeRange=range;

-->	m_bBaseForMerged = 1;   <---

}

It should not do that. It should be using the value of the cell being copied. Only true merged cells should have a base flag set.

Step 2:

In CGridCellBase InflateMergedRange change to:

void CGridCellBase::InflateMergedRange(int cx, int cy)
{
	if (IsMerged())
	{
		m_MergeRange.Set(
			m_MergeRange.GetMinRow() + cy,
			m_MergeRange.GetMinCol() + cx,
			m_MergeRange.GetMaxRow() + cy,
			m_MergeRange.GetMaxCol() + cx
			);
	}
	else if(IsMergeWithOthers())
	{
		m_MergeCellID.row += cy;
		m_MergeCellID.col += cx;
	}
}

The bug is that only the BASE base has a valid range object.
Likewise, only merged cells utilise a merged cell id object.

The merged cell id object was not getting updated, so the merged cells now pointed to the wrong master base cell.

Because we have now corrected the operator= call in step 1, we could use IsBaseForMerge instead of IsMerged. But this works using the existing method IsMerged.

Step 3:

In CGridCtrl::InflateMergedRanges change to:

void CGridCtrl::InflateMergedRanges(int nStartRow, int nStartCol, int cx, int cy)
{
	for(int i = nStartRow; i < GetRowCount(); i++)
	{
		for(int j = nStartCol; j < GetColumnCount(); j++)
		{
			if(GetCell(i, j)->IsMerged() || GetCell(i, j)->IsMergeWithOthers())
			{
				GetCell(i, j)->InflateMergedRange(cx, cy); 
			}
		}
	}
}

As described for step 2, you need to intercept and modify both base cell (with a merge range) and merged cells (with a merged cell id).

AutoSizeColumn problem

andrewtruckle

21:04 24 May '06

When you autosize a column, and the cell is merged and the master cell, the column ends up being resized and the grid can effectively double in width.

I did this to overcome the problem:

AutoSizeColumn:

for (int nRow = nStartRow; nRow <= nEndRow; nRow++)

    {

        CGridCellBase* pCell = GetCell(nRow, nCol);

		// AJT Avoid merged cells in calculations

        if (pCell && !pCell->IsMerged())

		{

            size = pCell->GetCellExtent(pDC);

 

			if (size.cx > nWidth)

				nWidth = size.cx;

		}

    }

Clicking on a merged cell and moving by keyboard to merged cell

andrewtruckle

21:49 23 May '06

I have some problems here. Can anyone help me solve them?

1. In order to set a merged set of cells as the focus cell, you must click on the "base" cell for the merged cells. You can't click on any of them.

2. Related to this (perhaps). My grid uses combo cells and the odd row of merged text cells. If I am on a combo cell and the move down a row using the cursor key, it renders the dropdown arrow of the hidden combo cell. This would explain why item 1 above does not let you click a none-based merged cell.

The question is how can I solve these two problems? It would be nice to click on any merged cell and it set the focus correctly and it would be nice when moving up/down etc. that it set the focus cell correctly.

Andrew

Re: Clicking on a merged cell and moving by keyboard to merged cell - Solution

andrewtruckle

23:24 23 May '06

What you have to do is not let the grid set focus to a cell that is merged with others. Add this code to SetFocusCell:

// EFW - Bug Fix - Force focus to be in a non-fixed cell

if (cell.row != -1 && cell.row < GetFixedRowCount())

  cell.row = GetFixedRowCount();

if (cell.col != -1 && cell.col < GetFixedColumnCount())

  cell.col = GetFixedColumnCount();

 

*** NEW CODE ***

// AJT Bug Fix

CGridCellBase	*pCell = NULL;

pCell = GetCell(cell);

if(pCell != NULL && pCell->IsMergeWithOthers())

  cell = pCell->GetMergeCellID();

Now, it will select the right cell and this works for mouse and cursor movements. It also avoids the rendering of grid lines.