Is there a way to have a default value that shows in a cell if the cell's value is not in the cell's value list. Example:
Value List
1 Red2 Blue3 Green
If the cell's value is anything besides 1, 2, or 3 I would like it to show up as UNDEFINED. Can I do this, and if so how?
Do you care what the underlying value is? Typically, in a case like this, you would allow nulls and simply set the NullTextLabel on the column to the strnig you want to show when it's null.
Is there anything I can do if the value is not going to be null? It could be pretty much any integer, but if it's not one of the integers I have a label for I would like it to show as UNDEFINED.
You should be able to acheive what you want, but how you do it depends on some other factors. What's the Style of the column? Is it a DropDown or DropDownList? In other words, is the user limited to selecting from the list or can they type into the box? I
If the cell is not editable, you can probably use a DrawFilter or CreationFilter to control the displayed text. If it is editable, then it becomes more complicated, because what do you do when the type in something like "UNDEFINED"? What would be the underlying value you would use?