The AM/PM value is not shown in the cell when formatting a time value.

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")

Observed: The AM/PM format is missing
Expected: AM or PM should be shown after the time (image attached) 

Declined: The changes could be applied if the user presses OK button instead of pressing Enter key. A new feedback item is open where the issue is described: https://feedback.telerik.com/Project/143/Feedback/Details/212042-spreadsheet-custom-number-type-values-in-format-cells-dialog-are-not-applied-wh

Add support for formats which can present numbers with non-arabic numerals, for example:
- Bengali - [$-bn-IN,500]0
- Devanagari - [$-hi-IN,400]0
- East Arabic - [$-ar-SA,200]0
- Persian - [$-ar-SA,300]0
- Gujarati - [$-gu-IN,700]0
- Kannada - [$-kn-IN,B00]0
- Khmer - [$-et-EE,1200]0
- Lao - [$-lo-LA,E00]0
- Malayalam - [$-ml-IN,C00]0
- Mongolian - [$-mn-MN,1300]0
- Burmese - [$-my-MM,1000]0
- Oriya - [$-or-IN,800]0
- Tamil - [$-ta-IN,900]0
- Telugu - [$-te-IN,A00]0
- Thai - [$-th-TH,D00]0
- Tibetan - [$-bo-CN,F00]0

The item is closed as a duplicate. Please, vote and follow the item at https://feedback.telerik.com/wpf/1354143-spreadsheet-add-support-for-number-formats-for-presenting-numbers-with-non-arabic-numerals.

If you begin entering e.g. "=" in FormulaBar, the characters are not visible in dark themes. If the focus is in the cell it works as expected, if the focus is in FormulaBar, the Foreground is dark and cannot be seen on dark background. 

Workaround:
-  set the following style (add BaseOn if using implicit styles)

<Style  TargetType="spreadsheetControls:RadSpreadsheetFormulaBar" BasedOn="{StaticResource RadSpreadsheetFormulaBarStyle}">
            <Setter Property="Foreground" Value="White"/>
</Style>

Available in LIB Version 2017.2.828.

Implement automatic completion of cell value based on the values typed above, in the same column.

When a row is removed through code and an image is created immediately after that in the same method, the UI does not update. The change is made in the model, but not visualized. If you scroll up and down the change is reflected in the UI.

The background should be stretched along with the item itself. It is currently with specified width.
Workaround: Modify the style and change the width of the tab item. A sample is attached.

Currently, changing the sheets performs heavy calculations on the UI thread. This does not allow to perform any other UI task and the busy indicator cannot be shown before all layers are rendered.

In MS Excel, the users have the option to specify that the data contains a header row. When this option is enabled, the first row of the column is not included in the sorted range. Implement this option in RadSpreadsheet as well.

Allow loading of dialogs (SpellCheckAllAtOnce and SpellCheckWordByWord) different than the default ones through MEF. 

Use-cases: set different Width and Height, hide buttons (e.g. AddToDictionary), etc. 

When the InsertFunctionDialog is opened and the "Go" button is pressed with many words entered in the search terms field, the performance is so slow that the application appears hanged.

This item is moved, because it is related to the RadSpreadsheet's model. You can find the corresponding item here: https://feedback.telerik.com/Project/184/Feedback/Details/255960-spreadprocessing-incompatibility-with-microsoft-excel-of-in-document-hyperlinks

ArgumentException is thrown when protecting a worksheet having missing algorithmName information

Resizing images always position the image at the cell where the image has been inserted. Flipping image also results in a wrong behavior.

The exception is thrown when pasting in a protected sheet and canceling the warning message box using the MessageShowing event.

The scale factor is not imported from documents with no information about the selection state.

For example, the default namespace prefix for BlipElement is r: if the namespace prefix is different an exception will occur.

Hello,

 

In the spreadsheet control you cannot link/use in a function cells from one work sheet to cell(s) in another work sheet. Would like to have the same behavior and functionality of Excel, which allows you to use data from one sheet in any other sheet in the work book. Need the ability to create a sum of (or any other function available) cells from another worksheet in my current worksheet, within the same workbook.  

The used cell range is expanded when styles to all columns are applied and one copies an entire row.

Workaround:

private void RadSpreadsheet_WorkbookChanged(object sender, EventArgs e)
{
    var range = this.radSpreadsheet.Workbook.ActiveWorksheet.UsedCellRange;
    this.radSpreadsheet.ActiveWorksheet.Columns[range.ColumnCount + 1, SpreadsheetDefaultValues.ColumnCount - 1].Clear(ClearType.All);
}

When the column width is decreasing below the size of the filter button the size of the button remains the same and overlaps the previous button.

The named ranges are not updated after rows columns are inserted.

This item is migrated to the Telerik Document Processing portal: https://feedback.telerik.com/document-processing/1549293. Please, use the new item for commenting, voting, and subscribing instead of this one.