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.
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" />
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>
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.
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.
When using the Fill feature through the dialog, the series are currently filled only for the cells, which are included in the selection. Introduce functionality to fill them without requiring a selection. A custom implementation can be plugged through a custom dialog. A sample showing how to replace the default dialog with a custom one is available in the attachments of the item.
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
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.
When a de-DE culture is applied the 1,1 should be parsed as a number. On the other hand the 1.1 (with a dot) should be parsed as 01.Jan. Currently, both values (1,1 and 1.1) are parsed as datetime. Decline reason: This is reproducible only if the cell was previously formatted as DateTime. In this case the separator is not taken into account which is expected. The same behavior can be observed also in Excel.
Setting the visible size property to a small number, like 10,10, will result in missing the last column right border and last row bottom border.
Expose WorksheetUIUpdateContextBase.GetDataValidationRuleResult(CellIndex). This method is useful for creating optimized custom Data Validation Circles layers. Available in LIB Version 2017.2.828.
The class would be used for customization of the printing behavior of the control.
if you use Excel, you use a lot of formulas. But In Telerik WPF there isn't enough formulas.(even like SUMIFS , SUBTOTAL) But I search for other library like Kendo-UI, there is more fomulas than WPF. Why are these different? Please make this formulas in your library.
The COUNTIF function is already available in RadSpreadsheet.
When trying to set the VisibleSize property of RadSpreadsheet on the ActiveSheetChanged event a null exception is thrown in the UpdateSheet method of RadSheetEditorBase. Possible workaround is to record the visible size at the SheetChanged event and set it at a later time, e.g. using a timer.
When a sheet that has a new line in a text value is exported and the resulting file is opened in Excel, the value is displayed without a new line. If you enter edit mode and then exit (without confirming the value by pressing enter) the new line will appear. The reason for this behavior is that when there is a new line in a text value Excel automatically applies wrap text on the cell while RadSpreadsheet does not do that. A possible workaround is to apply wrap text on new values with new line in them.
Cell borders below the cells filled with data are not exported to XLSX.