Approved
Last Updated: 08 Jan 2019 19:24 by ADMIN
Some of the RadSpreadsheet child controls do not apply the new theme, but stay with office black applied when theme is set on control level.
In Development
Last Updated: 28 Dec 2018 14:55 by ADMIN
ADMIN
Created by: Deyan
Comments: 1
Category: Spreadsheet
Type: Feature Request
22
Add support for visualizing and editing charts.
Completed
Last Updated: 25 Dec 2018 15:10 by ADMIN
ArgumentException is thrown when protecting a worksheet having missing algorithmName information
Completed
Last Updated: 12 Dec 2018 13:36 by ADMIN
Xlsx documents with a global filter defined cannot be imported. Message box "The name that you entered is not valid." is shown and internally SpreadsheetNameException is thrown. MS Excel can import such document and even preserve the filter, but do not respect it and doesn't have UI to clear it.

Workaround 1 (includes processing the document with MS Excel):
- Open the document in MS Excel
- Choose Formulas -> Defined names -> Named Manager
- Choose Filter -> Names with errors
- Find all Filter defined names and delete them
- Save the document
Approved
Last Updated: 05 Nov 2018 11:27 by ADMIN
ADMIN
Created by: Martin
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
RadSpreadsheet should respect negative time values as MS Excel does it.
Approved
Last Updated: 31 Oct 2018 13:43 by ADMIN
At the moment when any of the properties are changed, e.g. the frozen panes, the UI is not notified and you have to export and import the file in order for the UI to pick them up. 


Workaround: There are several workarounds:

1. Change the active worksheet and return to the old one

2. Export and import the document

3. Change the workbook of the RadSpreadsheet to a new one, and return the old one after that
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
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.
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
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
Declined
Last Updated: 31 Oct 2018 08:14 by ADMIN
ADMIN
Created by: Boby
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
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
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
If plain text is pasted in a cell, and the text is automatically recognizable as date, number, percentage, formula or other format, the text is always converted to the recognized number format.

Instead, the cell's current number format should affect the convertion in the following way:
- If the current format is General -> parse the value with the automatically recognized format, and set the value with the automatically recognized format
- If the current format is Text -> set the value as text, and preserve the current format (Text)
- If the current format is any other format -> try parse the value with the current format
  - Successful -> set the parsed value with the current format
  - Unsuccessful -> parse the value with the automatically recognized format, and set the parsed value with the current format.

As a result, strings which are recognizable as dates, for example, are pasted as their numeric representation instead of with their Date formatting. Also it's not possible to paste something as plain text. 

Workaround: for always pasting plain text: Create custom Paste button and executes the following code:
this.radSpreadsheet.ActiveWorksheetEditor.Selection.Cells.SetValueAsText(Clipboard.GetText());
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
When setting the following strings as cell value, they are recognized as dates. In industry standard applications like MS Excel and OpenOffice, they are recognized as strings:
- "12 3456" in bg-BG, fr-FR, ru-RU, sv-FI, en-US
- "12.3456" in de-DE
- "1 23" in en-US
- "2013/5" in en-US
- "3000-03" in en-US
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
When RadSpreadsheet is placed inside a data template and the Workbook property is bound, the binding fails. 

In the Convert() method of the debug converter, the proper value is set. However, an empty workbook is displayed in the view.
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
ADMIN
Created by: Boby
Comments: 0
Category: Spreadsheet
Type: Feature Request
0
Currently the following text filters are not supported in the model, filtering popup and Custom Filter dialog:
- begins with
- does not begin with
- ends with
- does not end with
- contains
- does not contain.

All of these are supported in MS Excel.
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
Add support for import and export of Excel Template files (XLTS) file format.
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
The overlapping of SelectionFill and SelectionStroke geometries may be seen in the attached screenshot. This scenario may be reproduced with the following RadSpreadsheet instance:

<telerik:RadSpreadsheet SelectionStroke="Red" SelectionStrokeThickness="10" FillHandleSelectionStroke="Green" SelectionFill="#550000FF" />
Completed
Last Updated: 31 Oct 2018 08:14 by ADMIN
Number formats like "[$-1010409]General" containing locale code and General keyword are not parsed correctly which results in interpreting them as number formats which have to replace the positive numbers with "General".

Available in R1 2017 SP
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
The visualization and scrolling of documents containing many merged cells (e.g. 1000) is very slow. The control becomes almost unusable when the number increases.
Approved
Last Updated: 31 Oct 2018 08:13 by ADMIN
Workaround: Import the document without using the default command

OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "All Spreadsheet Files (*.txt, *.csv, *.pdf, *.xlsx)|*.txt;*.csv;*.pdf;*.xlsx|Excel Workbook (*.xlsx)|*.xlsx|CSV (Comma delimited) (*.csv)|*.csv|Text (Tab delimited) (*.txt)|*.txt|All Files (*.*)|*.*";
if (openFileDialog.ShowDialog() == true)
{
    string extension = Path.GetExtension(openFileDialog.SafeFileName);
    using (Stream input = openFileDialog.OpenFile())
    {
        Workbook workbook = WorkbookFormatProvidersManager.Import(extension, input);
        workbook.Name = openFileDialog.SafeFileName; // in the default implementation this is set after applying the document to RadSpreadsheet and triggers the event
       
        this.radSpreadsheet.Workbook = workbook;
    }
}
Approved
Last Updated: 31 Oct 2018 08:13 by ADMIN
If a cell starts with number, contains text, and some values are auto-filled using this cell as base, for example with the Fill handle, the wrong Spreadsheet's autofill generator is used, and ordinal numbers are generated. Instead, the last number (if such) should be increased.

For example, if the cell value is "35'5" and the fill handle is used in order the values to next cells to be autofilled, the values are 35th, 36th and etc., instead of the correct ones which are: 35'6, 35'7,...
Approved
Last Updated: 31 Oct 2018 08:11 by ADMIN
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.
1 2 3 4 5 6