Recently Updated
Unplanned
1
```Add support for the AVERAGEIF function:  https://support.office.com/en-us/article/AVERAGEIF-function-faec8e2e-0dec-4308-af69-f5576d8ac642

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria:

AVERAGEIF(range, criteria, [average_range])

Unplanned
1
```Add support for the SUBTOTAL function: https://support.office.com/en-us/article/SUBTOTAL-function-7b027003-f060-4ade-9040-e478765b9939

It computes the subtotal for some ranges, given the code for the subtotal function:

SUBTOTAL(function_num,ref1,[ref2],...)

where function_num is code referring to some of the functions: AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR, VARP.

Note that we should implement the support for all of the above functions. As of now, COUNTA, VAR, VARP are not supported.

Workaround: This could be implemented as a custom function: http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions.html , but multiple functions (4 as of now) has to be additionally implemented.```
Unplanned
2
```Add support for ROW function: https://support.office.com/en-us/article/ROW-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d?ui=en-US&rs=en-US&ad=US

Examples:

=ROW() returns the row in which the formula appears
=ROW(C10) returns the row of the reference - 10

Unplanned
3
```Implement SMALL function (https://support.office.com/en-us/article/SMALL-function-17da8222-7c82-42b2-961b-14c45384df07 ), which returns k-th smallest value from a range:

SMALL(array, k)

Unplanned
1
```If Spreadsheet's history is not enabled, merged cells cannot be unmerged.

Workaround: Enable the History before calling Unmerge():

workbook.History.IsEnabled = true;
worksheet.Cells[0, 0, 0, 4].Unmerge();
workbook.History.IsEnabled = false;```
Unplanned
4
`At this point, the formatting can be applied only to the whole cell content.`
Completed
3
```The MATCH function searches for a specified item in a range of cells and returns the relative position of the item found in this range.﻿﻿﻿

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

Available in R3 2017 Official Release Version```
Completed
0
```An InvalidOperationException could be thrown in multi-threaded export to XLSX format. However, the problem is not verified.

Here is the stacktrace:

ERROR System.InvalidOperationException: isParsing must be true.
at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase`3.OnBeforeWrite(IOpenXmlExportContext context)
at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Write(IOpenXmlWriter writer, IOpenXmlExportContext context)
at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Write(IOpenXmlWriter writer, IOpenXmlExportContext context)
at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Parts.OpenXmlPartBase.Export(IOpenXmlWriter writer, IOpenXmlExportContext context)
at Telerik.Windows.Documents.FormatProviders.OpenXml.Export.OpenXmlExporter`2.ExportPart(OpenXmlPartBase part, TContext context)
at Telerik.Windows.Documents.FormatProviders.OpenXml.Export.OpenXmlExporter`2.Export(Stream output, TContext context, OpenXmlExportSettings settings)

Available in LIB Version 2017.2.828.```
Declined
0

Unplanned
0
```There are scenarios when the default value of the columns is changed and may be different from 65. However, RadSpreadprocessing always exports the non-custom column values as 65.

WORKAROUND: After importing the XLSX file you may make all columns to have custom values in order to preserve the column widths after the export. The following code snippet shows how this may be achieved for some Worksheet instance:

CellRange usedRange = worksheet.UsedCellRange;

for (int i = 0; i < usedRange.ColumnCount; i++)
{
ColumnSelection column = worksheet.Columns[i];
double width = column.GetWidth().Value.Value;
column.SetWidth(new ColumnWidth(width, true));
}```
Unplanned
1

Add support for superscript and subscript font effects for cell formatting. Currently, this is not supported by the model and is omitted on import.

Completed
2

Unplanned
2
```Comparison operators (equal '=', not equal '<>') doesn't work as expected with references to empty cells. For example, expressions of type '=IF(A1="", TRUE, FALSE)' are evaluated to false when A1 cell is empty.

In MS Excel, such expression is evaluated to TRUE if the cell is empty - i.e. empty cell value is considered equal to an empty string "".

Workaround: Use ISBLANK function if possible. Its results are consistent with MS Excel.```
Unplanned
1
```For instance, when exporting FLOOR.MATH function a #NAME error is displayed initially.

Workaround: Select the cell in Excel, click in the formula bar and press Enter without changing anything. This fixes the #NAME error and Excel manages to successfully display the function result.```
Completed
1
```Add support for CHOOSE function. CHOOSE uses the number parameter to return a value from the list of value arguments.

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

Available in R2 2017 Official Release.```
Completed
1
```Add support for TRIM function. TRIM removes all spaces from text except for single spaces between words.

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

Available in R2 2017 Official Release.```
Completed
5
```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```
Unplanned
`Add support for strikethrough font effect for cell formatting. Currently this is not supported by the model and is omitted on import.`
`When the default number formats for Accounting and Currency are used and the current culture is Russian, the number format is not parsed correctly.`
`Add support for array formulas (CellFormulaType "array"). These formulas can accept as parameters and return results containing whole arrays (one- or two- dimensional) of data. In MS Excel, such formulas are inserted with CTRL + SHIFT + Enter, and visualized enclosed with curly brackets ('{' and '}'). `