Data validation does not validate values if they are not set using the cell editor. Pasting or auto-fill of invalid values will not produce data validation warning.
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.
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.
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
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.
Currently, only Workbook/Worksheet could be protected. Would be nice to expose a way to protect cells for scenarios in which only particular cells should be locked for modifications.
Add support for preserving and exporting the macros in a macro-enabled workbook.
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
This item is declined. The visualized border describes the print area.
Can we have the ability to hide the cell selector rectangle in the RadSpreadsheet? If we had this, along with the current existing functionality we would have spreadsheet capabilities inside what looks like an 'empty' page. It would be good for reporting purposes where the developer can make full use of the spreadsheet's functions but completely hide the 'spreadsheet look-and-feel' from the user.