SpreadProcessing: InvalidOperationException when opening an XLS document with a named range that refers to a formula. The message is "Only applicable to named ranges". Opened correctly in Excel.
Parsing a document that contains a cell with wrapped multiline text and its row doesn't define a value for height, results in wrong row height when rendering or exporting to PDF.
Workaround: Fit the height of the row when it contains wrapped cells:
Worksheet worksheet = workbook.ActiveWorksheet;
CellRange wrappedCells = worksheet.GetUsedCellRange(CellPropertyDefinitions.IsWrappedProperty);
for (int i = wrappedCells.FromIndex.RowIndex; i < wrappedCells.ToIndex.RowIndex; i++)
{
worksheet.Rows[i].AutoFitHeight();
}
Currently, the following text filters are not supported in the model: