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.
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
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
This item is declined. The visualized border describes the print area.