/usr/lib/python3/dist-packages/openpyxl/chart/tests/test_reference.py is in python3-openpyxl 2.3.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 89 90 91 92 93 94 95 96 97 | from __future__ import absolute_import
# Copyright (c) 2010-2015 openpyxl
import pytest
from openpyxl.xml.functions import fromstring, tostring
from openpyxl.tests.helper import compare_xml
@pytest.fixture
def Reference():
from ..reference import Reference
return Reference
@pytest.fixture
def Worksheet():
class DummyWorksheet:
def __init__(self, title="dummy"):
self.title = title
return DummyWorksheet
class TestReference:
def test_ctor(self, Reference, Worksheet):
ref = Reference(
worksheet=Worksheet(),
min_col=1,
min_row=1,
max_col=10,
max_row=12
)
assert str(ref) == "dummy!$A$1:$J$12"
def test_single_cell(self, Reference, Worksheet):
ref = Reference(Worksheet(), min_col=1, min_row=1)
assert str(ref) == "dummy!$A$1"
def test_from_string(self, Reference):
ref = Reference(range_string="Sheet1!$A$1:$A$10")
assert (ref.min_col, ref.min_row, ref.max_col, ref.max_row) == (1,1, 1,10)
assert str(ref) == "Sheet1!$A$1:$A$10"
def test_cols(self, Reference):
ref = Reference(range_string="Sheet!A1:B2")
assert list(ref.cols) == [
('A1', 'A2'),
('B1', 'B2')
]
def test_rows(self, Reference):
ref = Reference(range_string="Sheet!A1:B2")
assert list(ref.rows) == [
('A1', 'B1'),
('A2', 'B2')
]
@pytest.mark.parametrize("range_string, cells",
[
("Sheet!A1:A5", ['A1', 'A2', 'A3', 'A4', 'A5']),
("Sheet!A1:E1", ['A1', 'B1', 'C1', 'D1', 'E1']),
]
)
def test_cells(self, Reference, range_string, cells):
ref = Reference(range_string=range_string)
assert list(ref.cells) == cells
@pytest.mark.parametrize("range_string, cell, min_col, min_row",
[
("Sheet1!A1:A10", 'A1', 1, 2),
("Sheet!A1:E1", 'A1', 2, 1),
]
)
def test_pop(self, Reference, range_string, cell, min_col, min_row):
ref = Reference(range_string=range_string)
assert cell == ref.pop()
assert (ref.min_col, ref.min_row) == (min_col, min_row)
@pytest.mark.parametrize("range_string, length",
[
("Sheet1!A1:A10", 10),
("Sheet!A1:E1", 5),
]
)
def test_length(self, Reference, range_string, length):
ref = Reference(range_string=range_string)
assert len(ref) == length
|