Setting transparency to a chart series color results in a corrupted document.

When the columns are using widths with too precise decimal values (ex: 150.33333333333334), the VisibleRange of ViewportPane reports wrong range in some situations. 

This causes issues when calculating element positions in a custom WorksheetUILayerBase in the context of RadSpreadsheet for WPF.

Add support for the FILTER function.

Add support for setting the Axis Type to Automatic.

In Excel formulas, the double minus (--) is known as the "double unary operator." Its main purpose is to convert Boolean values (TRUE/FALSE) into numeric values (1/0).
How it works:
• TRUE becomes 1
• FALSE becomes 0
Example: Suppose you have an array formula like:

=SUM(--(B2:B20="Gamma"))

• (B2:B20="Gamma") produces an array of TRUE/FALSE.
• --(B2:B20="Gamma") converts that array to 1/0.
• SUM(...) then adds up the number of matches.

Some Excel functions (like SUM, SUMPRODUCT) require numbers, not Booleans.
The double unary is a concise way to force this conversion.

 

 

SEARCH function with the following format is valid only in Excel 365/2021 or later (with dynamic array support).
"=SEARCH({"Alpha","Beta","Gamma","Delta","Omega","Sigma","Zeta"}, "Omega")"

• It returns an array of numbers or errors, showing the position of each substring in "Omega".
• If a substring is found, you get its position (e.g., 1 for "Omega"); if not, you get #VALUE!.

Cached formula values are not respected for the AdditionExpression type.

GetResultValueAsString returns "#NAME?".

Add support for the RANDBETWEEN function.

Provide the ability to work with images in headers/footers of a worksheet. Note that large images put in headers are visualized as watermarks on printing/exporting to PDF.
Watermark in Excel: https://support.office.com/en-us/article/add-a-watermark-in-excel-a372182a-d733-484e-825c-18ddf3edf009
 

Add support for Stock charts (StockChart).

Add support for pivot tables.

Add API that allows one to manipulate the macros inside a Workbook.

Add support for documents with unexpected text between child elements (e.g. ZWNBSP).

The COUNTA function counts cells containing any type of information, including error values and empty text ("")

https://support.microsoft.com/en-us/office/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509 

Expose the argument values of existing conditional formatting rules. Currently, the argument values from the SingleArgumentConditionalFormattingRule and DoubleArgumentConditionalFormattingRule classes are internal.

Exporting XLS file with filters results in a corrupted document.

https://support.microsoft.com/en-us/office/eomonth-function-7314ffa1-2bc9-4005-9d66-f49db127d628 

Chart with missing shape properties (shPr) is corrupted with black background after PDF export.

Apply Note style:

Set None Fill:

 

Add support for creating Tables and applying tables styles (predefined ones or custom).