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.

Here are the steps:

1. Copy some basic content from Excel (two text cells)

2. Paste the content to the Telerik Blazor Spreadsheet component and save the XLSX file

3. Try importing this file with RadSpreadProcessing

If the conditional formatting is missing, the copy operation is executed with no errors.

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 API that allows one to manipulate the macros inside a Workbook.

Charts in excel have support for minor grid lines. This is not supported here.

When the worksheet contains fraction numbers with fractional parts > 0.5 and < 0.5 and both these numbers have fraction format applied, the number with fractional part < 0.5 will have incorrect whole part.

Incorrect timestamp of a DateTime with custom number format.

Expected:

Actual:

XlsFormatProvider: FormulaParseException is thrown when importing a document with formulas referencing non-existent named ranges.

InvalidOperationException is thrown when a comment uses legacyDrawingHF element instead of legacyDrawing.

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: