var dv = GcSpread.Sheets.DefaultDataValidator.createFormulaValidator("AND(0.5<D4/D2 , D4/D2<1.5 )");
dv.showErrorMessage=false
sheet.setDataValidator(1, 3 ,dv)
var dv2 = GcSpread.Sheets.DefaultDataValidator.createFormulaValidator("AND(0.5<D4/D2 , D4/D2<1.5 )");
dv2.showErrorMessage=false
sheet.setDataValidator(3, 3 ,dv2) |