Search found 1 match

by mjb1416
Mon Mar 27, 2023 3:08 pm
Forum: XLSReadWritwII 6
Topic: Data Range Validation
Replies: 1
Views: 1662

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;...