1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
require 'tc_helper.rb'
class TestChart < Test::Unit::TestCase
def setup
@p = Axlsx::Package.new
ws = @p.workbook.add_worksheet
@row = ws.add_row ["one", 1, Time.now]
@chart = ws.add_chart Axlsx::Bar3DChart, :title => "fishery"
end
def teardown
end
def test_initialization
assert_equal(@p.workbook.charts.last,@chart, "the chart is in the workbook")
assert_equal(@chart.title.text, "fishery", "the title option has been applied")
assert((@chart.series.is_a?(Axlsx::SimpleTypedList) && @chart.series.empty?), "The series is initialized and empty")
end
def test_title
@chart.title.text = 'wowzer'
assert_equal(@chart.title.text, "wowzer", "the title text via a string")
assert_equal(@chart.title.cell, nil, "the title cell is nil as we set the title with text.")
@chart.title = @row.cells.first
assert_equal(@chart.title.text, "one", "the title text was set via cell reference")
assert_equal(@chart.title.cell, @row.cells.first)
end
def test_to_from_marker_access
assert(@chart.to.is_a?(Axlsx::Marker))
assert(@chart.from.is_a?(Axlsx::Marker))
end
def test_style
assert_raise(ArgumentError) { @chart.style = 49 }
assert_nothing_raised { @chart.style = 2 }
assert_equal(@chart.style, 2)
end
def test_start_at
@chart.start_at 15, 25
assert_equal(@chart.graphic_frame.anchor.from.col, 15)
assert_equal(@chart.graphic_frame.anchor.from.row, 25)
@chart.start_at @row.cells.first
assert_equal(@chart.graphic_frame.anchor.from.col, 0)
assert_equal(@chart.graphic_frame.anchor.from.row, 0)
@chart.start_at [5,6]
assert_equal(@chart.graphic_frame.anchor.from.col, 5)
assert_equal(@chart.graphic_frame.anchor.from.row, 6)
end
def test_end_at
@chart.end_at 25, 90
assert_equal(@chart.graphic_frame.anchor.to.col, 25)
assert_equal(@chart.graphic_frame.anchor.to.row, 90)
@chart.end_at @row.cells.last
assert_equal(@chart.graphic_frame.anchor.to.col, 2)
assert_equal(@chart.graphic_frame.anchor.to.row, 0)
@chart.end_at [10,11]
assert_equal(@chart.graphic_frame.anchor.to.col, 10)
assert_equal(@chart.graphic_frame.anchor.to.row, 11)
end
def test_add_series
s = @chart.add_series :data=>[0,1,2,3], :labels => ["one", 1, "anything"], :title=>"bob"
assert_equal(@chart.series.last, s, "series has been added to chart series collection")
assert_equal(s.title.text, "bob", "series title has been applied")
end
def test_pn
assert_equal(@chart.pn, "charts/chart1.xml")
end
def test_to_xml_string
schema = Nokogiri::XML::Schema(File.open(Axlsx::DRAWING_XSD))
doc = Nokogiri::XML(@chart.to_xml_string)
errors = []
schema.validate(doc).each do |error|
errors.push error
puts error.message
end
assert(errors.empty?, "error free validation")
end
end
|
