Question about using the export to excel

[Jose]

Hi 

i'm trying to export a grid with 2 detail tables to excel, when i do the export in the excel documents appears 2 columns in color gray in front the text.  I dont understand where my problem because when i do this export from word and pdf works fine

Thanks in advance

There is my Code Behind :

grdcostcategory.ExportSettings.ExportOnlyData = False
            grdcostcategory.ExportSettings.IgnorePaging = False
            grdcostcategory.ExportSettings.OpenInNewWindow = True
            grdcostcategory.MasterTableView.HierarchyDefaultExpanded = False

            grdcostcategory.MasterTableView.UseAllDataFields = True

            grdcostcategory.ExportSettings.FileName = TL_CF_Configuration.Constants.ExportCostCategory.ToString
            grdcostcategory.MasterTableView.GetColumn("BtnEditImage").Visible = False
            grdcostcategory.MasterTableView.GetColumn("BtnNewClientLocationImage").Visible = False

            grdcostcategory.ExportSettings.HideStructureColumns = True
            grdcostcategory.GridLines = GridLines.Both

[Shinu]

Hi,

I cannot reproduce the issue at my end. Try setting ExportOnlyData as False and check whether it makes any difference. Hope this helps.

Thanks,
Shinu.