Approved
Last Updated: 07 Mar 2017 09:26 by ADMIN
If you try to filter a column which contains a cell with applied font color and the project is run in debug mode with enabled C# exceptions, it throws ArgumentException at System.Windows.Media.ColorConverter.ConvertFrom(ITypeDescriptorContext td, CultureInfo ci, Object value). The exception is handled and the functionality is working as expected, however this may be annoying during debugging projects containing RadSpreadsheet.
Approved
Last Updated: 31 Oct 2018 08:06 by ADMIN
When a workbook protection is applied, changing the color of a tab in the sheet selector shouldn't be allowed.

Workaround: Remove the Tab Color item from the Items collection of the SheetSelectorContextMenu. 
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
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:06 by ADMIN
When number format ends with N commas, the resulting number should be divided to 1000 N times. Instead, such commas are ignored. 

For example, if the format is #.0,, and the value of the cell is 12,200,000, the number should be displayed as 12.200.0
Approved
Last Updated: 31 Oct 2018 08:06 by ADMIN
LocalizableException with text "Format string is not in the correct format.", with inner ArgumentException "Format string is not in the correct format." is thrown. 

Currently the validation doesn't allow number format string starting with date or time formatting to have more that one section (for negative and zero numbers). Excel allows this type of number formats and if you set format like dd/mm/yyyy;[RED](#.##0); the positive numbers are visualized as dates, but negative numbers are visualized as numbers and their fore color is red.

Examples (including the final semicolons):

- ss;

- dd;

- dd/mm/yyyy;;

- mmm-yy;mmm-yy;_-* "-"??_-;_-@_-
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:06 by ADMIN
If a workbook contains a worksheet with RowHeight bigger than 600px (SpreadsheetDefaultValues.MaxRowHeight), an exception is thrown while trying to import such a document. 
Approved
Last Updated: 31 Oct 2018 08:06 by ADMIN
The default set of WPF UI controls measured in infinity results in the minimal size of the control. RadSpreadsheet should behave the same. This will help users to find out what is happening while debugging.
Approved
Last Updated: 31 Oct 2018 08:14 by ADMIN
ADMIN
Created by: Deyan
Comments: 0
Category: Spreadsheet
Type: Bug Report
1
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" />
Approved
Last Updated: 31 Oct 2018 08:06 by ADMIN
If the RadSpreadsheet is declared as a child content in the RadBusyIndicator, there isn't any tab selected as active in the SheetSelector.

Workaround: Declare the busy indicator after the RadSpreadsheet not as its child.

For example, instead of:

<telerik:RadBusyIndicator>
    <telerik:RadSpreadsheet x:Name="radSpreadsheet" />
</telerik:RadBusyIndicator>

Do:

<Grid>
    <telerik:RadSpreadsheet x:Name="radSpreadsheet" />
    <telerik:RadBusyIndicator />
</Grid>
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:06 by ADMIN
DataValidationRule is persisted after pasting a cell value which is copied from a cell without DataValidationRule applied. 

For example: Cell A1 has data validation rule applied. The cell A2 doesn't have. The value from cell A2 is copied to cell A1. The result is that cell A1 still has data validation, but it shouldn't.
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: 03 Aug 2017 10:40 by ADMIN
#.##0,00;-#.##0,00;;@ does not work in RadSpreadsheet. It should suppress visualizing of ) values.

Workaround: #.##0,00;-#.##0,00; ;@ works fine (there is ' ' [space] set for the zero values).
Approved
Last Updated: 23 Apr 2018 13:47 by ADMIN
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.
Approved
Last Updated: 25 Sep 2017 05:56 by ADMIN
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.
1 2 3