The fix is available in our latest LIB release (v.2015.3.1026). 

The feature will be available in our official release Q1 2016.

Add API allowing change of the mouse cursor.

Implement Show Formulas command, which display the formulas in the cells instead of the result value. In MS Excel, this is available in Formulas -> Formula Auditing -> Evaluate Formula.

The keyboard shortcut is "Ctrl + ~".

If you set "[h]:mm" as a custom format to a cell which has time set to it the calculated value in the cell is wrong for the minutes. The minutes part is interpreted as months.

The number format [hh]:mm causes ArgumentException on import.

Implement UI for hiding sheet. The sheets can be visible, hidden, or very hidden (could be made visible only from the API).

Note: This is already supported on model level (in RadSpreadProcessing).

Implement options in fill handle which enable to choose the type of the auto filling, as in MS Excel. 

After drag-drop of the fill handle, a small UI control (drop down button like) appears which enables the users to choose whether the cell data should be copied, filled using series or other. Another option (also available in MS Excel), is to drag the fill handle with the right mouse button, which shows window with options.

When I insert an image in a worksheet it shown and I can print it. But when I export the worksheet to a PDF file the image is not exported!

When a workbook with a number of worksheets larger than a certain count is saved an out of memory exception is thrown. The necessary number of worksheets depends on the file and the machine, but it ranges between 70-90.

With the current implementation, the Notes support only a rectangular shape.

Examples:

COUNTA function is similar to COUNTIF function, but it only counts the non-empty cells. 

Description from Microsoft here: https://support.office.com/en-us/article/COUNTA-function-7dc98875-d5c1-46f1-9a82-53f3219e2509?ui=en-US&rs=en-US&ad=US&fromAR=1 .

Workaround: it should be possible to implement such custom function. See Custom Functions help article here: http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/formulas/custom-functions .

We should provide an easier API allowing the customers to remove the key bindings or change the commands that they trigger.

Workaround: There is attached a sample showing how all the commands triggered by the key bindings can be disabled.

If you need to set a custom type number format (using Format cell dialog) and enter some additional text in Type TextBox and press Enter key, the changes are not applied.


Steps to reproduce: 

1. Insert some time in a cell in spreadsheet (22:20)

2. Apply it a custom format that contains AM/PM (e.g. "h:mm AM/PM") and press Enter key

Observed: The AM/PM format is missing

Expected: AM or PM should be shown after the time


Workaround: Press OK button or first click somewhere else in order to change the focus

Steps to reproduce: 

1. Enter in a cell =Today()
2. Show Format Cells dialog and set Custom format "d"

Expected: The value is the day of the month.
Actual: The date is formatted as short date but has to be day of the month.