def test_sum(self): formula = "oooc:=SUM([.B2:.B4])" excepted = "ooow:sum <B2:B4>" self.assertEqual(oooc_to_ooow(formula), excepted)
def test_addition_sum(self): formula = "oooc:=[.A2]-[.A3]+SUM([.B2:.B4])*[.D4]" excepted = "ooow:<A2>-<A3>+sum <B2:B4>*<D4>" self.assertEqual(oooc_to_ooow(formula), excepted)
def test_addition(self): formula = "oooc:=[.A2]+[.A3]" excepted = "ooow:<A2>+<A3>" self.assertEqual(oooc_to_ooow(formula), excepted)