how to display header text for grouped columns in excel epxort

hello, I have these grouped columns:

<SfGrid @ref="_SfGrid" Height="500px" AllowExcelExport="true" DataSource="@_EverythingDailies" AllowGrouping="true" AllowPdfExport="true" GridLines="GridLine.Both"
        Toolbar="_Toolbaritems">
    <GridGroupSettings ShowDropArea="true" Columns="@GroupedColumn"></GridGroupSettings>
    <GridEvents OnToolbarClick="ToolbarClickHandler" TValue="ReportmakingServiceReference.EverythingDaily"></GridEvents>
    <GridColumns>
        <GridColumn Field=@nameof(ReportmakingServiceReference.EverythingDaily.StartDate) Format="dd.MM.yyyy" HeaderText="Дата начала" AutoFit="true"></GridColumn>
        <GridColumn Field=@nameof(ReportmakingServiceReference.EverythingDaily.EndDate) Format="dd.MM.yyyy" HeaderText="Дата завершения" AutoFit="true"></GridColumn>
        <GridColumn Field=@nameof(ReportmakingServiceReference.EverythingDaily.StationName) HeaderText="Станция" AutoFit="true"></GridColumn>
    </GridColumns>
</SfGrid>


    private string[] GroupedColumn = new string[] { "StartDate", "EndDate", "StationName" };

and in excel export it displays like this:

is it possible to display HeaderTexts instead of these red ones?
I mean to replace them with these ones: HeaderText="Дата начала", HeaderText="Дата завершения" , HeaderText="Станция"
I am using blazor version  18.2.0.47

1 Reply 1 reply marked as answer

VN Vignesh Natarajan Syncfusion Team January 7, 2021 06:02 AM UTC

Hi Aleqsandre,    
 
Thanks for contacting Syncfusion support. 
 
Query: “is it possible to display HeaderTexts instead of these red ones? 
 
We have analyzed your query and we are able to reproduce the reported issue at our end. By default while exporting, header text has to be displayed in grouped caption. We have considered the reported query as a bug and logged the defect report “Grouped column name is displayed wrongly in exported file” for the same. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and including the defect fix in our weekly release which is expected to be rolled out by mid of February, 2021. We will update you once the release is rolled out.   
      
You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.      
  
 
Till then we appreciate your patience..   
 
Regards, 
Vignesh Natarajan  
 
 
 
 
 
 
 
 
 
 
 
 
 


Marked as answer
Loader.
Up arrow icon