Forums Ultimate UI for WPF
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
brent
100
how to show the document in excel??
posted

when I save DataGrid into excel file and open the excel file with MS office, I can't see the document in excel. 

 Data is in excel, but columns of excel are shifted left side. Of course, I can drag columns to right side and watch the data.

how to control this happening?

  • 100
    posted in reply to [Infragistics] Vlad Zagorski

    Hi Vlad.

    my screenshot is...

    I marked red-rectangle. That position isoriginally A field and No.1. Of course, after I drag column and row, I can see data.

    My wpf prog. has 3 tabs that have 3 grid respectively. When I choose second tab(second grid) and I export first grid in first tab into excel, it happend. However, when I choose second tab and click button that export grid, excel does not have problem.

  • 9836
    posted

    Could you post some screenshot so we can see how the columns are shifted? By default, when exporting to excel the first cell in the first column should have the focus and respectively the document should be shifted to the most left position. Are the columns autogenerated and do you disable grid's settings when exporting?