def test_SUMPRODUCT_ranges_with_errors(self): range1 = func_xltypes.Array( [[xlerrors.NumExcelError('err')], [10], [3]] ) range2 = func_xltypes.Array([[3], [3], [1]]) self.assertIsInstance( math.SUMPRODUCT(range1, range2), xlerrors.NaExcelError)
def test_SUMPRODUCT_with_single_value(self): self.assertEqual(math.SUMPRODUCT(1), 1.0)
def test_SUMPRODUCT_without_any_range(self): self.assertIsInstance(math.SUMPRODUCT(), xlerrors.NullExcelError)
def test_SUMPRODUCT_with_empty_frist_range(self): self.assertEqual(math.SUMPRODUCT(func_xltypes.Array([])), 0)
def test_SUMPRODUCT_ranges_with_different_sizes(self): range1 = func_xltypes.Array([[1], [10], [3]]) range2 = func_xltypes.Array([[3], [3], [1], [2]]) self.assertIsInstance(math.SUMPRODUCT(range1, range2), xlerrors.ValueExcelError)
def test_SUMPRODUCT(self): range1 = func_xltypes.Array([[1], [10], [3]]) range2 = func_xltypes.Array([[3], [1], [2]]) self.assertEqual(math.SUMPRODUCT(range1, range2), 19)