def test_merge_comments_vml(datadir):
datadir.chdir()
cw = ShapeWriter(create_comments())
with open('control+comments.vml') as existing:
content = fromstring(cw.write(fromstring(existing.read())))
assert len(content.findall('{%s}shape' % vmlns)) == 5
assert len(content.findall('{%s}shapetype' % vmlns)) == 2
def test_from_xml(self, DateAxis):
from openpyxl25.chart.data_source import NumFmt
src = """
<dateAx>
<axId val="20"/>
<scaling>
<orientation val="minMax"/>
</scaling>
<delete val="0"/>
<axPos val="b"/>
<numFmt formatCode="d-mmm" sourceLinked="1"/>
<majorTickMark val="out"/>
<minorTickMark val="none"/>
<tickLblPos val="nextTo"/>
<crossAx val="10"/>
<crosses val="autoZero"/>
<auto val="1"/>
<lblOffset val="100"/>
<baseTimeUnit val="months"/>
</dateAx>
"""
node = fromstring(src)
axis = DateAxis.from_tree(node)
assert axis == DateAxis(axId=20,
crossAx=10,
axPos="b",
delete=False,
numFmt=NumFmt("d-mmm", True),
majorTickMark="out",
crosses="autoZero",
tickLblPos="nextTo",
auto=True,
lblOffset=100,
baseTimeUnit="months")
def test_from_xml(self, Boolean):
src = """
<b />
"""
node = fromstring(src)
boolean = Boolean.from_tree(node)
assert boolean == Boolean()
def test_from_xml(self, DateTimeField):
src = """
<d v="2016-03-24T00:00:00"/>
"""
node = fromstring(src)
record = DateTimeField.from_tree(node)
assert record == DateTimeField(v=datetime(2016, 3, 24))
def test_from_xml(self, Text):
src = """
<s v="UCLA" />
"""
node = fromstring(src)
text = Text.from_tree(node)
assert text == Text(v="UCLA")
def test_read_fills():
# Make sure we pass the right class
from ..fills import Fill
s = """
<fills count="3" xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<fill>
<patternFill patternType="none" />
</fill>
<fill>
<patternFill patternType="gray125" />
</fill>
<fill>
<gradientFill type="path" left="0.5" right="0.5" top="0.5" bottom="0.5">
<stop position="0">
<color theme="0" tint="-5.0935392315439317E-2" />
</stop>
<stop position="1">
<color theme="0" tint="-0.25098422193060094" />
</stop>
</gradientFill>
</fill>
</fills>
"""
xml = fromstring(s)
for node in xml:
fill = Fill.from_tree(node)
def test_from_xml(self, InlineFont):
src = """
<RPrElt />
"""
node = fromstring(src)
font = InlineFont.from_tree(node)
assert font == InlineFont()
def test_from_xml(self, TableStyleElement):
src = """
<tableStyleElement type="secondRowStripe" size="2" />
"""
node = fromstring(src)
table = TableStyleElement.from_tree(node)
assert table == TableStyleElement(type="secondRowStripe", size=2)
def test_from_xml(self, PivotFormatList):
src = """
<pivotFmts />
"""
node = fromstring(src)
fmt = PivotFormatList.from_tree(node)
assert fmt == PivotFormatList()
def test_from_tree(self):
from openpyxl25.chart.series import Series, attribute_mapping
src = """
<ser>
<idx val="0"/>
<order val="0"/>
<spPr>
<a:ln xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main">
<a:prstDash val="solid" />
</a:ln>
</spPr>
<val>
<numRef>
<f>Blatt1!$A$1:$A$12</f>
</numRef>
</val>
</ser>
"""
node = fromstring(src)
ser = Series.from_tree(node)
assert ser.idx == 0
assert ser.order == 0
assert ser.val.numRef.ref == 'Blatt1!$A$1:$A$12'
ser.__elements__ = attribute_mapping['area']
xml = tostring(ser.to_tree())
diff = compare_xml(xml, src)
assert diff is None, diff
def test_from_xml(self, PlotArea):
src = """
<plotArea />
"""
node = fromstring(src)
plot = PlotArea.from_tree(node)
assert plot == PlotArea()
def test_from_xml(self, DataTable):
src = """
<dTable />
"""
node = fromstring(src)
table = DataTable.from_tree(node)
assert table == DataTable()
def from_xml(self, TextAxis):
src = """
<catAx>
<axId val="2065276984"/>
<scaling>
<orientation val="minMax"/>
</scaling>
<delete val="0"/>
<axPos val="b"/>
<majorTickMark val="out"/>
<minorTickMark val="none"/>
<tickLblPos val="nextTo"/>
<crossAx val="2056619928"/>
<crosses val="autoZero"/>
<auto val="1"/>
<lblAlgn val="ctr"/>
<lblOffset val="100"/>
<noMultiLvlLbl val="0"/>
</catAx>
"""
node = fromstring(src)
axis = CatAx.from_tree(node)
assert axis.scaling.orientation == "minMax"
assert axis.auto is True
assert axis.majorTickMark == "out"
assert axis.minorTickMark is None
def test_from_xml(self, ChartLines):
src = """
<chartLines />
"""
node = fromstring(src)
axis = ChartLines.from_tree(node)
assert axis == ChartLines()
def test_from_xml(self, DisplayUnitsLabelList):
src = """
<dispUnits />
"""
node = fromstring(src)
axis = DisplayUnitsLabelList.from_tree(node)
assert axis == DisplayUnitsLabelList()
def test_from_xml(self, TableStyle):
src = """
<tableStyle name="medium" />
"""
node = fromstring(src)
table = TableStyle.from_tree(node)
assert table == TableStyle(name="medium")
def test_from_xml(self, TableStyleList):
src = """
<tableStyles />
"""
node = fromstring(src)
table = TableStyleList.from_tree(node)
assert table == TableStyleList()
def test_from_xml(self, ExternalData):
src = """
<externalData id="rId1"/>
"""
node = fromstring(src)
data = ExternalData.from_tree(node)
assert data == ExternalData(id="rId1")
def test_from_xml(self, PhoneticProperties):
src = """
<phoneticPr fontId="0" type="noConversion"/>
"""
node = fromstring(src)
props = PhoneticProperties.from_tree(node)
assert props == PhoneticProperties(fontId=0, type="noConversion")
def test_from_xml(self, Surface):
src = """
<surface />
"""
node = fromstring(src)
surface = Surface.from_tree(node)
assert surface == Surface()
def test_from_xml(self, RichText):
src = """
<RElt />
"""
node = fromstring(src)
text = RichText.from_tree(node)
assert text == RichText()
def test_from_xml(self, PrintSettings):
src = """
<printSettings />
"""
node = fromstring(src)
chartspace = PrintSettings.from_tree(node)
assert chartspace == PrintSettings()
def test_from_xml(self, Number):
src = """
<n v="15" />
"""
node = fromstring(src)
number = Number.from_tree(node)
assert number == Number(v=15)
def test_from_xml(self, PageMargins):
src = """
<pageMargins b="1.0" l="0.75" r="0.75" t="1.0" header="0.5" footer="0.5"/>
"""
node = fromstring(src)
pm = PageMargins.from_tree(node)
assert pm == PageMargins()
def test_from_xml(self, Index):
src = """
<x v="1" />
"""
node = fromstring(src)
record = Index.from_tree(node)
assert record == Index(v=1)
def test_from_xml(self, BandFormatList):
src = """
<bandFmts />
"""
node = fromstring(src)
fmt = BandFormatList.from_tree(node)
assert fmt == BandFormatList()
def test_from_xml(self, Error):
src = """
<e v="error" />
"""
node = fromstring(src)
error = Error.from_tree(node)
assert error == Error(v="error")
def test_from_xml(self, SurfaceChart3D):
src = """
<surface3DChart>
<wireframe val="0"/>
<ser>
<idx val="0"/>
<order val="0"/>
<val>
<numRef>
<f>Blatt1!$A$1:$A$12</f>
</numRef>
</val>
</ser>
<ser>
<idx val="1"/>
<order val="1"/>
<val>
<numRef>
<f>Blatt1!$B$1:$B$12</f>
</numRef>
</val>
</ser>
<bandFmts/>
<axId val="2082935272"/>
<axId val="2082938248"/>
<axId val="2082941288"/>
</surface3DChart>
"""
node = fromstring(src)
chart = SurfaceChart3D.from_tree(node)
assert len(chart.ser) == 2
assert chart.axId == [2082935272, 2082938248, 2082941288]
def test_from_xml(self, Missing):
src = """
<m />
"""
node = fromstring(src)
missing = Missing.from_tree(node)
assert missing == Missing()
def test_from_xml(self, NumericAxis):
src = """
<valAx>
<axId val="2056619928"/>
<scaling>
<logBase val="10" />
<orientation val="minMax"/>
</scaling>
<delete val="0"/>
<axPos val="l"/>
<majorGridlines/>
<numFmt formatCode="General" sourceLinked="1"/>
<majorTickMark val="out"/>
<minorTickMark val="none"/>
<tickLblPos val="nextTo"/>
<crossAx val="2065276984"/>
<crosses val="autoZero"/>
<crossBetween val="between"/>
</valAx>
"""
node = fromstring(src)
axis = NumericAxis.from_tree(node)
assert axis.delete is False
assert axis.crossAx == 2065276984
assert axis.crossBetween == "between"
assert axis.scaling.logBase == 10
