Hi, Last time I asked something similar I got the answer from Vic: "Unfortunately, you shouldn't expect it." (search the forum for validation).
This is a major obstacle. I am inventing ridiculuos solutions trying to prevent invalid data. I have even been looking for other spreadsheet solutions because of this. Have not found one through.
