public void TestSVConditions() { System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US"); CellFormatCondition lt = CellFormatCondition.GetInstance("<", "1.5"); Assert.IsTrue(lt.Pass(1.4)); Assert.IsFalse(lt.Pass(1.5)); Assert.IsFalse(lt.Pass(1.6)); CellFormatCondition le = CellFormatCondition.GetInstance("<=", "1.5"); Assert.IsTrue(le.Pass(1.4)); Assert.IsTrue(le.Pass(1.5)); Assert.IsFalse(le.Pass(1.6)); CellFormatCondition gt = CellFormatCondition.GetInstance(">", "1.5"); Assert.IsFalse(gt.Pass(1.4)); Assert.IsFalse(gt.Pass(1.5)); Assert.IsTrue(gt.Pass(1.6)); CellFormatCondition ge = CellFormatCondition.GetInstance(">=", "1.5"); Assert.IsFalse(ge.Pass(1.4)); Assert.IsTrue(ge.Pass(1.5)); Assert.IsTrue(ge.Pass(1.6)); CellFormatCondition eqs = CellFormatCondition.GetInstance("=", "1.5"); Assert.IsFalse(eqs.Pass(1.4)); Assert.IsTrue(eqs.Pass(1.5)); Assert.IsFalse(eqs.Pass(1.6)); CellFormatCondition eql = CellFormatCondition.GetInstance("==", "1.5"); Assert.IsFalse(eql.Pass(1.4)); Assert.IsTrue(eql.Pass(1.5)); Assert.IsFalse(eql.Pass(1.6)); CellFormatCondition neo = CellFormatCondition.GetInstance("<>", "1.5"); Assert.IsTrue(neo.Pass(1.4)); Assert.IsFalse(neo.Pass(1.5)); Assert.IsTrue(neo.Pass(1.6)); CellFormatCondition nen = CellFormatCondition.GetInstance("!=", "1.5"); Assert.IsTrue(nen.Pass(1.4)); Assert.IsFalse(nen.Pass(1.5)); Assert.IsTrue(nen.Pass(1.6)); }
public void TestSVConditions() { TestCases.CultureShim.SetCurrentCulture("en-US"); CellFormatCondition lt = CellFormatCondition.GetInstance("<", "1.5"); Assert.IsTrue(lt.Pass(1.4)); Assert.IsFalse(lt.Pass(1.5)); Assert.IsFalse(lt.Pass(1.6)); CellFormatCondition le = CellFormatCondition.GetInstance("<=", "1.5"); Assert.IsTrue(le.Pass(1.4)); Assert.IsTrue(le.Pass(1.5)); Assert.IsFalse(le.Pass(1.6)); CellFormatCondition gt = CellFormatCondition.GetInstance(">", "1.5"); Assert.IsFalse(gt.Pass(1.4)); Assert.IsFalse(gt.Pass(1.5)); Assert.IsTrue(gt.Pass(1.6)); CellFormatCondition ge = CellFormatCondition.GetInstance(">=", "1.5"); Assert.IsFalse(ge.Pass(1.4)); Assert.IsTrue(ge.Pass(1.5)); Assert.IsTrue(ge.Pass(1.6)); CellFormatCondition eqs = CellFormatCondition.GetInstance("=", "1.5"); Assert.IsFalse(eqs.Pass(1.4)); Assert.IsTrue(eqs.Pass(1.5)); Assert.IsFalse(eqs.Pass(1.6)); CellFormatCondition eql = CellFormatCondition.GetInstance("==", "1.5"); Assert.IsFalse(eql.Pass(1.4)); Assert.IsTrue(eql.Pass(1.5)); Assert.IsFalse(eql.Pass(1.6)); CellFormatCondition neo = CellFormatCondition.GetInstance("<>", "1.5"); Assert.IsTrue(neo.Pass(1.4)); Assert.IsFalse(neo.Pass(1.5)); Assert.IsTrue(neo.Pass(1.6)); CellFormatCondition nen = CellFormatCondition.GetInstance("!=", "1.5"); Assert.IsTrue(nen.Pass(1.4)); Assert.IsFalse(nen.Pass(1.5)); Assert.IsTrue(nen.Pass(1.6)); }