Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
495
Problem with Column Headings in Export of WinGrid
posted
I am exporting a WinGrid that contains two bands. In the code prior to calling the export I manipulate the displaylayout of the first band (band[0] to set the HeaderPlacement to FixedOnTop, however when the resulting excel is created, the header columns for band[0] appear on top as anticipated, however the headers for the columns in band[1] appear in the second row in the Excel, not expected. Simply want to see the columns of band[0], and allow the headings for band[1] to appear when the excel is expanded. I've attached a screen shot of the resulting excel and highlighted the columns that are part of band[1] showing in the 2nd row of the Excel file. Note that I am not doing anything special with the export simply calling the Export from a button click after the Grid is loaded into the view. Please advise as to how to resolve. Please note that I am using the latest version of Infragistics 11.2, CLR 4x. Thanks, Paul
Parents
  • 469350
    Offline posted

    Hi,

    If you don't want the headers in the Excel sheet to be fixed at the top, then why are you setting the HeaderPlacement to FixedOnTop?

    Are you saying you want the headers in the on-screen grid to be on top, but not in the Excel file? If that's the case, handle the ExportStarted event and modify the HeaderPlacement property on the Layout passed into the event.

     

Reply Children