Forums Ultimate UI for Windows Forms
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
Close
Sowmya Chidambaram
140
Exporting to excel - grid has multiple bands
posted

Hello,

I am trying to export an ultragrid which has 2 bands in it. The second band columns are defined by their colSpan. The first column of the child band aligns with like the 7th or 8th column of the parent band. I understand that the excelexporter does not recognize the colspans set on these columns. How do I align these columns? I have a right click option in an excel sheep to shift cells right. I want to do something similar through program

Thanks

Sowmya

  • 469350
    Suggested Answer
    Offline posted

    Hi Sowmya,

    I tried this out and I see the results you are getting. I tried to work around it by using the HeaderExporting and CellExporting events and merging the cells and the shifting the CurrentRowIndex over, but this does not work because the exporter doesn't honor the CurrentRowIndex for cells, only for the entire row.

    So I don't see any good way to do this. You can, of course, cancel the exporting of the entire row and then export it yourself, but this would involve exporting everything including the appearances, borders, headers, etc. so that's not a realistic solution.