/usr/lib/python3/dist-packages/openpyxl/worksheet/tests/test_views.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 | from __future__ import absolute_import
# Copyright (c) 2010-2015 openpyxl
from openpyxl.xml.functions import fromstring, tostring
import pytest
from openpyxl.tests.helper import compare_xml
@pytest.fixture
def SheetView():
from ..views import SheetView
return SheetView
@pytest.mark.parametrize("value, result",
[
(True, {'workbookViewId': '0'}),
(False, {'workbookViewId': '0', 'showGridLines':'0'})
]
)
def test_show_gridlines(SheetView, value, result):
view = SheetView(showGridLines=value)
assert dict(view) == result
def test_parse(SheetView):
src = """
<sheetView xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" tabSelected="1" zoomScale="200" zoomScaleNormal="200" zoomScalePageLayoutView="200" workbookViewId="0">
<pane xSplit="5" ySplit="19" topLeftCell="F20" activePane="bottomRight" state="frozenSplit"/>
<selection pane="topRight" activeCell="F1" sqref="F1"/>
<selection pane="bottomLeft" activeCell="A20" sqref="A20"/>
<selection pane="bottomRight" activeCell="E22" sqref="E22"/>
</sheetView>
"""
xml = fromstring(src)
view = SheetView.from_tree(xml)
assert dict(view) == {'tabSelected': '1', 'zoomScale': '200', 'workbookViewId':"0",
'zoomScaleNormal': '200', 'zoomScalePageLayoutView': '200'}
assert len(view.selection) == 3
def test_serialise(SheetView):
view = SheetView()
xml = tostring(view.to_tree())
expected = """
<sheetView workbookViewId="0">
<selection activeCell="A1" sqref="A1"></selection>
</sheetView>
"""
diff = compare_xml(xml, expected)
assert diff is None, diff
|