Posted 8 September 2017, 1:55 pm EST
i try to limit the user input for a DateTime cell with the MinimumDate / MaximumDate properties:
Dim ct As DateTimeCellType = CType(sprMonate_Sheet1.Columns(0).CellType, DateTimeCellType)
ct.MinimumDate = new Date(2006,10,1)
ct.MaximumDate = new Date(2007,9,30)
Now i want to enter 01.11.2006 (german date format) in a date cell. When the editor gots the focus, immedieatly the max. date (30.09.2007) is displayed. I can overwrite the day part, but overwriting the month part is inhibited by the editor until i overwrite the year part. Without the limits i can enter the date value without problems. How can i prevent, that the maximum date is displayed a default value when i enter a cell?