Formulas like =0.0001/10 or formulas that produce small values results in 0 instead of exponential numbers.


Available in LIB version: 2017.1.313

Some of the leftmost borders are omitted when exported to PDF.

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.

ArgumentException with clarification similar to  "'\u001f', hexadecimal value 0x1F, is an invalid character." is thrown when trying to export document containing characters which are not supported in XML document - such as some control characters like 0x00, 0x1F, 0x1B, etc. Such characters are described in the XML specification here: https://www.w3.org/TR/xml/#charsets.

Although the escaped strings are not supported (see  https://feedback.telerik.com/Project/184/Feedback/Details/190228 ), the library could prevent the exception and export the document successfully by skipping such characters.

Workaround: remove such characters before the export. Check the following StackOverflow answer for some ideas on code for replacing the characters: http://stackoverflow.com/a/14323524/259206

Fix available in R3 2018 SP1 release.

Currently, the calculation of the actual ScaleFactor is based only on Worksheet`s UsedCellRange.

 Importing an XLS file causes NullReferenceException due to fill color.

The attribute is lost when importing a document. This might lead to corrupting the macros. 

NullReferenceException when importing a document that contains vml shapes with no row and column

The full data for the images is not copied and they are missing in the target worksheet.

When importing a document containing a destination that does not refer to a formula an exception is thrown: System.NullReferenceException: 'Object reference not set to an instance of an object.'

Exporting sheet properties corrupts the file and it cannot be opened in Excel.

In the latest version we export: 

<sheetPr>
<pageSetUpPr fitToPage="true" />
<tabColor rgb="FF92D050" />
</sheetPr>

Excel cannot read this and tries to recover the file unsuccessfully. This works in R3 2020.

When an xls file with a large, but still valid column width is imported, an ArgumentException is thrown: "The maximum column width for an individual cell is 255 characters." 

Text is cut off in Net Standard with a specific document.

Exception when the comments are imported before the fallback notes.

Wrong color scheme colors leads to wrong cell coloring on export.

When a NonTopLeftCellInMergedRange has a value set the column width is wrongly calculated.

Importing XLS document containing defined name with spaces in the sheet name causes exception

InvalidCastException on import when a drawing in a document contains the "ext" tag 

When a file with a format string of the type "\m\:0.#;\m\:0.#;\m\:0.#;\m\:\ @" is imported, argument exception is thrown.