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?
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?
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.