def test_getRangeStrings(self): doc = CalcDocument() path = os.path.dirname(os.path.abspath(__file__)) + "/docs/getNamedRanges.ods" doc.open(path) values = doc.getNamedRangeStrings("first") doc.close() expected = [["1", "2", "3"], ["4", "Friday, June 24, 2011", "6"], ["7", "8", "9"], ["10", "11", "12"]] self.assertEqual(expected, values)
def test_getNamedRangeData(self): doc = CalcDocument() path = os.path.dirname(os.path.abspath(__file__)) + "/docs/getNamedRanges.ods" doc.open(path) # test a couple of named ranges values = doc.getNamedRangeData("first") self.assertEquals((1, 2, 3), values[0]) self.assertEquals((4, 40718, 6), values[1]) self.assertEquals((7, 8, 9), values[2]) # another named range values = doc.getNamedRangeData("cola") self.assertEquals((1, 4, 7, 10), values) doc.close()
def test_getNamedRanges(self): doc = CalcDocument() path = os.path.dirname(os.path.abspath(__file__)) + "/docs/getNamedRanges.ods" doc.open(path) names = doc.getNamedRanges() self.assertTrue("first" in names) self.assertTrue("myranges" in names) self.assertTrue("cola" in names) self.assertTrue("colb" in names) self.assertTrue("colc" in names) doc.close()