Hi,
Thank you for help.
I've figured out how to make Issue 1 work.
Please see my attached sample. I modified following two things:
// 1. add this line before GroupingGridToExcel
this.gridGroupingControl1.Table.ExpandAllGroups();
converter.GroupingGridToExcel(this.gridGroupingControl1, saveFileDialog.FileName,
Syncfusion.GridExcelConverter.ConverterOptions.Default);
//2. modify 'ExportRecordRow' in GroupingGridExcelConverterExt.cs
private int ExportRecordRow( RecordRow row, IWorksheet sheet, int index, ConverterOptions options
, int iIndexInGroup, int iGroupLevel, out int iSkipRecordRows )
{
..... //lan: is combobox
bool bIsComboBox=(table.Columns[strColumnName].Appearance.AnyRecordFieldCell.CellType =="ComboBox");
.....
//if(cellStyle.CellType == "ComboBox")
if (bIsComboBox)
{
//range.Value2 = cellStyle.FormattedText;
//Lan: To display combobox lookup desc,
//must use the visiblecolumn index because when it is grouped, col index changed
ColIndex = table.VisibleColumns.IndexOf( strColumnName );
ColIndex = table.FieldToColIndex( ColIndex );
range.Value2 = t.TableModel[RowIndex,ColIndex].FormattedText;
}
else
{
object value = row.ParentRecord.GetValue( field );
range.Value2 = ( value == null ) ? string.Empty : value;
}
CopyStyle( cellStyle, range );
.....
}
regards,
Lan
GGC_SummaryRowExportModified.zip