def test_ctor(self): from openpyxl.chart import Axis, Legend from openpyxl.drawing import Drawing c = Chart(None, None) eq_(c.type, None) eq_(c.grouping, None) assert_true(isinstance(c.x_axis, Axis)) assert_true(isinstance(c.y_axis, Axis)) assert_true(isinstance(c.legend, Legend)) eq_(c.show_legend, True) eq_(c.lang, 'fr-FR') eq_(c.title, '') eq_(c.print_margins, { 'b': .75, 'l': .7, 'r': .7, 't': .75, 'header': 0.3, 'footer': .3 }) assert_true(isinstance(c.drawing, Drawing)) eq_(c.width, .6) eq_(c.height, .6) eq_(c.margin_top, c._get_max_margin_top()) eq_(c.margin_left, 0) eq_(c._shapes, [])
def test_computer_xmin_xmax(self): c = Chart(None, None) s = Serie(self.range, xvalues=self.range) c._series.append(s) c._compute_xmin_xmax() eq_(c.x_axis.max, 2.0) eq_(c.x_axis.unit, 1.0)
def test_mymin(self): c = Chart() eq_(c.mymin(range(10)), 0) from string import ascii_letters as letters eq_(c.mymin(list(letters)), "A") eq_(c.mymin(range(-10, 1)), -10) eq_(c.mymin([""] * 10), "")
def test_compute_series_max_dates(self): ws = self.make_worksheet() for i in range(1, 10): ws.append([date(2013, i, 1)]) c = Chart() ref = Reference(ws, (0, 0), (9, 0)) series = Serie(ref) c._series.append(series) mini, maxi = c._get_extremes() eq_(mini, 0) eq_(maxi, 41518.0)
def test_ctor(self): from openpyxl.chart import Axis, Legend from openpyxl.drawing import Drawing c = Chart(None, None) eq_(c.type, None) eq_(c.grouping, None) assert_true(isinstance(c.x_axis, Axis)) assert_true(isinstance(c.y_axis, Axis)) assert_true(isinstance(c.legend, Legend)) eq_(c.show_legend, True) eq_(c.lang, 'fr-FR') eq_(c.title, '') eq_(c.print_margins, {'b':.75, 'l':.7, 'r':.7, 't':.75, 'header':0.3, 'footer':.3} ) assert_true(isinstance(c.drawing, Drawing)) eq_(c.width, .6) eq_(c.height, .6) eq_(c.margin_top, c._get_max_margin_top()) eq_(c.margin_left, 0) eq_(c._shapes, [])
def test_get_min_margin_left(self): c = Chart(None, None) c._series.append(self.range) eq_(c._get_min_margin_left(), 1.2857142857142858)
def test_get_max_margin_top(self): c = Chart(None, None) eq_(c._get_max_margin_top(), 0.21250000000000005)
def test_compute_min_max(self): c = Chart(None, None) c._series.append(self.range) c._compute_min_max() eq_(c.y_axis.max, 2.0) eq_(c.y_axis.unit, 1.0)
def test_get_y_char(self): c = Chart(None, None) c._series.append(self.range) eq_(c.get_y_chars(), 1)
def test_get_y_unit(self): c = Chart(None, None) c._series.append(self.range) c.y_axis.max = 10 eq_(c.get_y_units(), 109728.0)
def test_get_x_unit(self): c = Chart(None, None) c._series.append(self.range) eq_(c.get_x_units(), 10)
def test_mymax(self): c = Chart(None, None) eq_(c.mymax(range(10)), 9) from string import letters eq_(c.mymax(list(letters)), "z")
def test_set_margin_left(self): c = Chart() c._series.append(self.range) c.margin_left = 0 eq_(c.margin_left, 0.03375)
def test_set_margin_top(self): c = Chart() c.margin_top = 1 eq_(c.margin_top, 0.31)
def test_compute_series_extremes(self): c = Chart() c._series.append(self.range) mini, maxi = c._get_extremes() eq_(mini, 0) eq_(maxi, 1.0)