this is the sample

If you need any additional assistance don’t hesitate to ask.

Regards

hi,

Thanks for the post but it doesnt solve our purpose.

I am using Infragistics 11.2 with visual studio 2010.I have used for header formatting but object e is throwing null reference error which was rather working fine in infragistics 2003.7.Please help me in the same.

public void HeaderCellExported(HeaderCellExportedEventArgs

e)

{

string

msn;

//string msn_prec;

if (e.GridHeader.Column.Tag != null

)

{

if (e.GridHeader.Column.Tag.Equals("TEMP_COL"

))

{

msn = e.GridHeader.Column.Tag.ToString();

e.CurrentWorksheet.Rows[e.CurrentRowIndex - 1].Cells[e.CurrentColumnIndex].Value =

BusProject.GetInstance().GetCurrentProjectName() + "-TEMP MSN"

;

// Récupération du format

IWorksheetCellFormat

cellFormat = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex].CellFormat;

e.CurrentWorksheet.Rows[e.CurrentRowIndex - 1].Cells[e.CurrentColumnIndex].CellFormat.SetFormatting(cellFormat);

tempColCount++;

if

(msn != currentMsn) currentMsn = msn;

else if (currentMsn != ""

&& nbofvisibleTEmpcount == tempColCount)

{

e.CurrentWorksheet.MergedCellsRegions.Clear ();

WorksheetMergedCellsRegion

region = e.CurrentWorksheet.MergedCellsRegions.Add(e.CurrentRowIndex - 1, e.CurrentColumnIndex - (nbofvisibleTEmpcount-1),

e.CurrentRowIndex - 1, e.CurrentColumnIndex);

}

//if (currentMsn != "" && tempColCount == 3)

//{

// WorksheetMergedCellsRegion region = e.CurrentWorksheet.MergedCellsRegions.Add(e.CurrentRowIndex - 1, e.CurrentColumnIndex - 2,

// e.CurrentRowIndex - 1, e.CurrentColumnIndex);

//}

//if (currentMsn != "" && tempColCount == 2)

//{

// WorksheetMergedCellsRegion region = e.CurrentWorksheet.MergedCellsRegions.Add(e.CurrentRowIndex - 1, e.CurrentColumnIndex - 1,

// e.CurrentRowIndex - 1, e.CurrentColumnIndex);

//}

// }

}

else

{

msn = e.GridHeader.Column.Tag.ToString();

e.CurrentWorksheet.Rows[e.CurrentRowIndex - 1].Cells[e.CurrentColumnIndex].Value =

"MSN "

+ msn;

// Récupération du format

IWorksheetCellFormat

cellFormat = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex].CellFormat;

e.CurrentWorksheet.Rows[e.CurrentRowIndex - 1].Cells[e.CurrentColumnIndex].CellFormat.SetFormatting(cellFormat);

if

(msn != currentMsn) currentMsn = msn;

else if (currentMsn != ""

)

{

WorksheetMergedCellsRegion

region = e.CurrentWorksheet.MergedCellsRegions.Add(e.CurrentRowIndex - 1, e.CurrentColumnIndex - 1,

e.CurrentRowIndex - 1, e.CurrentColumnIndex);

}

}

/*msn = e.GridHeader.Column.Tag.ToString();

msn_prec = "";

if (firstColumnToMerge == 0) firstColumnToMerge = e.CurrentColumnIndex;

if (e.CurrentWorksheet.Rows[e.CurrentRowIndex-1].Cells[e.CurrentColumnIndex-1].Value != null)

msn_prec = e.CurrentWorksheet.Rows[e.CurrentRowIndex-1].Cells[e.CurrentColumnIndex-1].Value.ToString();

// copie du msn

e.CurrentWorksheet.Rows[e.CurrentRowIndex-1].Cells[e.CurrentColumnIndex].Value = "MSN "+ msn;

// Récupération du format

IWorksheetCellFormat cellFormat = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex].CellFormat;

e.CurrentWorksheet.Rows[e.CurrentRowIndex-1].Cells[e.CurrentColumnIndex].CellFormat.SetFormatting(cellFormat) ;

if (e.GridHeader.Column.Key.EndsWith("RevAchDates"))

{

WorksheetMergedCellsRegion region = e.CurrentWorksheet.MergedCellsRegions.Add(e.CurrentRowIndex-1,firstColumnToMerge,

e.CurrentRowIndex-1,e.CurrentColumnIndex);

firstColumnToMerge = 0;

}*/

}

//if (!e.GridRow.Band.Columns.Exists("C_ACTION_ID")) nbColumnsMilestones = e.CurrentColumnIndex;

//Rename the column header Responsible into Milestone Responsible in order to not confuse with column Responsible of actions when we repositionne

//actions columns

if

(e.CurrentColumnIndex > lastMilestoneColumn) lastMilestoneColumn = e.CurrentColumnIndex;

if (e.GridRow.Band.Key == BusMilestonesDates

.CNameMonitoredMilestones)

{

//if (!e.GridRow.Band.Columns.Exists("C_ACTION_ID"))

nbColumnsMilestones = e.CurrentColumnIndex;

}

else if (e.GridRow.Band.Key == BusMilestonesDates

.CNameRelMilestonesLinks)

{

nbColumnsLink = e.CurrentColumnIndex;

}

//Rename the column header Due Date into MILESTONE in order to not confuse with column Due Date of actions when we repositionne

//actions columns

if (e.GridHeader.Caption == "Responsible"

)

{

if (e.GridHeader.Band.Key == BusMilestonesDates

.CNameMonitoredMilestones)

{

e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex].Value =

"Responsible"

;

}

}

}

Hello seema,

Thanks for attached code, but could you please upload a whole sample,  that we could build and reproduce your issue.

Thanks and Regards

Hi,

There are other types of headers besides column headers. There's the grid header (which I don't exports, anyway), but there are also Group headers. So you are probably getting into that event for a Group header and so the column is null.

So just check to see if the Column is nothing and then skip your code that tries to access the Tag.

(not e.GridHeader.Column is nothing andalso e.GridHeader.Column.Tag != null)

hi,

The column value is null , but it was working fine in prior version without any change in the code (above specified).

I m not getting how to resolve this , can you please help me.

The column is not null when we use the same code for infragistics 2003.7

Thanks & Regards,

Seema Sharma.

My guess is that Column is null. So you should check to make sure e.GridHeader.Column is not Nothing before you try to access the Tag property.

Could you please tell me the exact place in your source code,  where is throwing null reference exception ?