Search found 1 match
- Mon Mar 27, 2023 3:08 pm
- Forum: XLSReadWritwII 6
- Topic: Data Range Validation
- Replies: 1
- Views: 489
Data Range Validation
I'm trying to set a set of cells to only accept dates in a certain range. My code FXLS.CmdFormat.Mode := xcfmReplace; FXLS.CmdFormat.BeginEdit(DataSheet); FXLS.CmdFormat.Number.Format := 'YYYY-MM-DD'; FXLS.CmdFormat.Apply(Col, FIRSTDATA_ROW, Col, AVAILABLE_ROWS - 1); dv := DataSheet.Validations.Add;...