I am using GridWeb in an ASP.NET application, and I am encountering a number of problems related to cell validations:
1) I added a List validation on cell. I also added a custom comment on the cell. The tooltip for the cell now says:
My Cell Value
My custom tool tip
I want to remove the part, as these are useless to the user and often misleading. This is even more important when the validation is a regular expression, as the cell tooltip will display the regex used! How can this tooltip be modified with a custom message?
2) I set Date validation on a cell. This came up in yyyy/mm/dd format. I want to use dd/mm/yyyy format in ALL the worksheet. How can this be done? I tried setting the Custom property on the cell to "dd/mm/yyyy", and the cell then appeared correctly formatted. However, when I click on the cell to edit it, the cell value switches to "yyyy-mm-dd" format!
4) When a cell fails validation, it comes up with red boxes. Can this behaviour be modified to shade the cell background instead?
ASP.NET 2.0 with MS AJAX Extensions