To reproduce:
- Set the first column header text to "+R/S";
- Export the grid with spread export.
Workaround:
class MySpreadExportRenderer : SpreadExportRenderer
{
public override void SetCellSelectionValue(string text)
{
if (text == "+R/S")
{
var cellSelection = typeof(SpreadExportRenderer).GetField("cellSelection", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(this) as CellSelection;
CellRange range = cellSelection.CellRanges.ElementAtOrDefault(0);
CellValueFormat cvf = new CellValueFormat("@");
var worksheet = typeof(SpreadExportRenderer).GetField("worksheet", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(this) as Worksheet;
worksheet.Cells[range.FromIndex.RowIndex, range.FromIndex.ColumnIndex].SetFormat(cvf);
}
base.SetCellSelectionValue(text);
}
}