Devexpress wpf wrong exporting to Xls

Question

I'm using DevExpress Wpf GridControl v2011.2.

I try to export data to excel via standard devexpress' mtethods:

 XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions()
            {
                TextExportMode = DevExpress.XtraPrinting.TextExportMode.Text,
                ExportMode = XlsExportMode.SingleFile,               
                Suppress65536RowsWarning=true,
                ShowGridLines=true,
                SheetName=header

            };
 ((TableView)GridControlForExporting.View).ExportToXls(filename, options);

The end-user has Windows XP and Office 2007. this combination has problems. After exporting the data over 750 rows, the file has 750,751,752 merged rows (A750 merged with A751,A752; B750 with B751,B752 and so on). On windows 7 and office 2010 there is no such problems.

What can cause it?

Solved

The issue was solved with installing 2011.2.10 binaries. There were some moments:

enviroment was as virtual machines
devexpress components were trial

Please, report this issue directly at DevExpress Support Center. — DmitryG
@DmitryG your link is broken, change please ".dev" to ".com" — Yuriy Vikulov

nik nik · Accepted Answer · 2012-03-06T10:39:47

Merging, at least of columns is behavior by design because Devexpress is trying to export in a WYSIWYG manner to excel.

See here for more

If it works on another machine, it could be because they layout of the grid is different there.

Devexpress wpf wrong exporting to Xls

1 Answers