The import process takes much time when the formatting of the cells needs to be resolved. 

Icon sets 'ThreeTriangles', 'ThreeStars', 'FiveBoxes', and 'Custom' are set as a 'ThreeTrafficLightsUnrimmed' when setting a rule.

Add support for NOW function. NOW returns the serial number of the current date and time. If the cell format was General before the function was entered, Excel changes the cell format so that it matches the date and time format of your regional settings.

A list of the supported functions is available at http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/functions

This function can be implemented as a custom function. Check the following resources for more details on how to achieve that:

- http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions
- https://github.com/telerik/xaml-sdk/tree/master/Spreadsheet/CustomFunctions

Column AutoFitWidth is not calculated when the text inside a cell is on more than one line.

Adding a formula with the SetValueAsFormula method is slow

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

In some cases, horizontal bar chart cannot be loaded correctly. This leads to issue when opening the document with the RadSpreadsheet for WPF control.

Handle import of documents with invalid elements in 'x:fonts'.

When an xlsm file is imported and then exported, a new ThisWorkbook object is created in the VBA browser. This creates issues when making VBA functions that have to be executed upon opening of the file.

Hello,

we would like to have the capability to create a chart in excel export using Telerik.Documents.Spreadsheet 

Marcos

If a workbook with data validation makes use of a formula which has a string in it, on import and export, the data validation will become invalid.

If the column has a text format set and has a mixture of text and numbers, the numbers should be exported as text as well.

Introduce support for TMP images. Currently, the import throws a KeyNotFoundException.

Auto-fit exported table to page.

Implement import of PDF to Workbook, using PdfFormatProvider. This would require text recognition and table recognition.

This will allow the conversion of PDF documents to XLSX and CSV.

Named range's naming convention is ignored on import for Xlsx and Xlsm formats, but respected in Xls.

In the styles part of the xlsx file there is a cellXfs collection which contains xf elements. Each xf element has a numFmtId attribute which has to refer to an entry in the numFmts collection. Some libraries produce files with numFmtId's which are not valid but Excel handles such situations. SpreadProcessing throws KeyNotFoundException on import.

When opening an Xlsx file with conditional formatting I get an Exception:

"System.ArgumentNullException: 'Value cannot be null. (Parameter 'formatting')'

at Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings.ConditionalFormattingDxfRule..ctor(DifferentialFormatting formatting)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.ConditionalFormattingRuleElement.GetRule(DifferentialFormatting formatting)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Worksheets.ConditionalFormattingRuleElement.OnAfterRead(IXlsxWorksheetImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.ReadChildElements(IOpenXmlReader reader, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Read(IOpenXmlReader reader, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.ReadChildElements(IOpenXmlReader reader, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Read(IOpenXmlReader reader, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.OpenXmlImporter`1.ImportPartFromArchive(ZipArchiveEntry zipEntry, PartBase part, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.FormatProviders.OpenXml.OpenXmlImporter`1.Import(Stream input, IOpenXmlImportContext context)
   at Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider.ImportOverride(Stream input)
   at WpfApp1.MainWindow.StartExcel() in C:\Users\larse\source\repos\WpfApp1\MainWindow.xaml.cs:line 49"

To quote my colleage: "After dissecting the Excel template file, I have isolated what is causing the issue. If conditional formatting is used to disable cell boarders it results in the error, if the conditional formatting is updated to turn the necessary borders white, instead of disabling the report exports correctly, the following screenshot also explains."

SpreadProcessing: feature request to add IEnumerable<T> Interface(LINQ) implementation with CellSelection

If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.