When the spreadsheet contains empty rows and the format of some cells is set the rows are still exported to pdf or printed.  

To workaround this set the print area with the following code:

IPropertyDefinition[] propertyDefinitionsAffectiingPringing = new IPropertyDefinition[] { CellPropertyDefinitions.ValueProperty };
CellRange usedCellRange = workbook.Worksheets[0].GetUsedCellRange(propertyDefinitionsAffectiingPringing);

workbook.Worksheets[0].WorksheetPageSetup.PrintArea.SetPrintArea(usedCellRange);

When a workbook (xlsx) contains a worksheet where some of the columns have width, bigger than the value written in the SpreadsheetDefaultValues (2000) an exception during the import is thrown.

At this point, only the styling is preserved without the hyperlink itself. Implement logic to add the hyperlink to the generated PDF document.

Workaround: check the attached project.

Add support for the EDATE function.

Use the attached custom function as a workaround.

The exception is thrown when importing a document that contains an empty stylesheet tag in its styles.xml part.

Add API for setting custom document properties (metadata). Such are visualized by the common editors, e.g. in MS Excel in the File menu.

Example properties that can be set through the document properties are:

- Title
- Subject
- Author
- Keywords
- Comments
- Last Author
- Creation Date
- Category
- Manager
- Company

To reproduce: 

- Add the following formula to a cell: "=A1=FALSE"

Actual: the result is always false

Expected: the result should be true when the cell is empty

Workaround: Use the ISBLANK function.

Handle the case where the formula starts with "=+". Detailed information: https://professor-excel.com/equal-plus-excel-formulas/

Workaround: replace the "=+" with "="

CellRange usedCellRange = workbook.Worksheets[0].UsedCellRange;

for (int rowIndex = usedCellRange.FromIndex.RowIndex; rowIndex <= usedCellRange.ToIndex.RowIndex; rowIndex++)
{
    for (int columnIndex = usedCellRange.FromIndex.ColumnIndex; columnIndex <= usedCellRange.ToIndex.ColumnIndex; columnIndex++)
    {
        CellSelection cell = workbook.Worksheets[0].Cells[rowIndex, columnIndex];
       

        FormulaCellValue formulaCellValue =cell.GetValue().Value as FormulaCellValue;
        if (formulaCellValue == null)
        {
            continue;
        }
        CellValueFormat format = cell.GetFormat().Value;
        string resultValueAsString = formulaCellValue.GetValueAsString(format);
        Console.WriteLine(resultValueAsString);
        if (resultValueAsString.StartsWith("=+"))
        {
            resultValueAsString = resultValueAsString.Remove(1, 1);
            cell.SetValue(resultValueAsString);
        }
    }
}
radSpreadsheet.Workbook = workbook;