When a worksheet has name that has spaces and a hyperlink to this worksheet is being inserted in Excel, quotes are used to surround the name (ex: 'Sheet 12'!A1) for a valid hyperlink. If quotes are not added, the hyperlink is invalid.
In RadSpreadsheet, it is the opposite: (Sheet 12!A1 is correct, while 'Sheet 12'!A1 is incorrect).
Thus, opening such an exported document from RadSpreadsheet in Excel loads it with incorrect hyperlinks; and importing such an Excel document in RadSpreadsheet loads it with incorrect hyperlinks.

A way to workaround this issue is to modify the hyperlinks on import/export from/to RadSpreadsheet. You can find attached a project demonstrating this approach.

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:

Add support for Point Markes customization options for the Charts.

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

Currently, row/column groups cannot be collapsed/expanded through the public API. User should be able to specify row's/column's "collapsed" attribute indicating whether the outlining is in a collapsed state.

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.