The format string for dates should be in lowercase so they can work as expected. Ensure this in the internal logic.

Incorrect calculation of Round function returns wrong results in some cases. For example, test Microsoft Excel and Spreadsheet results of: ROUND(1.365, 2) to see the discrepancy.

Available in R3 2018 SP1 release.

The data validation rule should have values for formula1 and formula2 elements, which define the start and end values for a range to validate between. When such values are missing, a NullReferenceException is thrown on import and the document cannot be imported.

Details:

The COUNTIFS function returns the count of cells that meet one or more criteria.

Filter Selection dialog appears on the screen. 

Workaround: Open the file with Excel and save it as a new document.

While importing the arguments of the data validation rule, the formula is treated as text and its separators are replaced with the list separator defined in the current culture. This leads to an invalid formula treated as a list of strings.

The exception is thrown when importing a document that contains a not supported BuiltInNumberFormat.

The colors of the charts are determined by the theme in the default scenario. However, customers can apply any color to the series and the legend respectively. In such cases, RadSpreadProcessing doesn't import the custom colors and uses the ones defined by the theme.

Currently, adding hyperlinks to images is not supported.

Text is cut off when exporting to pdf with a specific font.

The calculation takes into account the height of the cell instead of the height of the row. 

The chart axes are not correctly imported when there are floating and sheet charts

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.

Currently, if there is an unsupported feature in the imported document it is stripped and not preserved in the document model (the Workbook). When exporting the Workbook the resulting document contains only the supported features.

Exception when the sheet name contains a single letter 

The filter icon is shown in merged cells after import export

Exception when importing a file with missing print settings

Introduce support for the XLOOKUP function.

The MATCH function does not work as expected. Should work exactly like in Excel. 

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