Replied 8 September 2017, 2:21 pm EST
When we save Spread in Excel, then Excel's default Column and Row Header's text are not replaced by the Spread's Headers, rather Spread's Headers gets accomodated in Excel's initial Rows and Columns because the Excel's default Column headers (A, B, C) can not be replaced with Spread's Headers. However you can make them hidden after exporting Spread to Excel by going in Tools>options>view tab>uncheck row and column headers.
And also along with that i would suggest you to upgrade your spread to the latest build of Spread version 2.5 which is 2.5.2015.2005. And here is the code i used to test the issue, wherein Spread's ColumnHeaders are exported to Excel initial rows with spanned cells:
private void ImportExcel_Load(object sender, EventArgs e)
fpSpread1.ActiveSheet.Cells[1, 1].Text = "These six cells are spanned.";
fpSpread1.ActiveSheet.Cells[5, 5].Text = "This is a long text which gets merged on exporting to excel";
fpSpread1.ActiveSheet.AddSpanCell(1, 1, 2, 3);
fpSpread1.ActiveSheet.ColumnHeader.RowCount = 3;
fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0].Text = "LONG COLUMN HEADER";
fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0].ColumnSpan = 3;
fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0].RowSpan = 2;
private void Save_Click(object sender, EventArgs e)
Hope this will help you. Thanks.