This project has moved and is read-only. For the latest updates, please go here.

Problem with row header that has a line feed

Jul 27, 2016 at 9:09 PM
I have XLS file whose column header has a line feed (char(10))
"Open/
Closed"

I refer to it on the pivot table and add it to RowFields.
But, when I open the XLS file, it didn't add that to the pivot table.
How can I fix it ?

var OpenClosedField = pivotTable1.Fields[1]; //--> this is the column whose header has the line feed
pivotTable1.RowFields.Add(OpenClosedField);
var countField = pivotTable1.Fields[1];
pivotTable1.DataFields.Add(countField);
pivotTable1.DataFields[0].Function = OfficeOpenXml.Table.PivotTable.DataFieldFunctions.Count;
package.Save();

Thank you.