/usr/lib/python3/dist-packages/openpyxl/chartsheet/tests/test_protection.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 | 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 ChartsheetProtection():
from ..protection import ChartsheetProtection
return ChartsheetProtection
class TestChartsheetProtection:
def test_read(self, ChartsheetProtection):
src = """
<sheetProtection
algorithmName="SHA-512"
hashValue="frzjS2RlYHFtCLJwGZod5i+414zeFhyLnVYY6A++RjBbtDfGng4+nU0Qpo1ZyIlXnfffImweadNwHNy5Bmm+zw=="
saltValue="Bo89+SCcqbFEcOS/6LcjBw=="
spinCount="100000" content="1"
objects="1"
xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main" />
"""
xml = fromstring(src)
chartsheetProtection = ChartsheetProtection.from_tree(xml)
assert chartsheetProtection.algorithmName == "SHA-512"
assert chartsheetProtection.saltValue == "Bo89+SCcqbFEcOS/6LcjBw=="
def test_write(self, ChartsheetProtection):
chartsheetProtection = ChartsheetProtection()
chartsheetProtection.saltValue = "Bo89+SCcqbFEcOS/6LcjBw=="
chartsheetProtection.content = "1"
chartsheetProtection.objects = "1"
chartsheetProtection.algorithmName = "SHA-512"
chartsheetProtection.spinCount = "100000"
chartsheetProtection.hash_password('Openpyxl_password')
expected = """
<sheetProtection
algorithmName="SHA-512"
hashValue="a7749ffe7ad38e41fa458d7b1b75b2ba98c94c334033dfb97896d4323a08b06b"
saltValue="Bo89+SCcqbFEcOS/6LcjBw=="
spinCount="100000" content="1"
objects="1"
xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main" />
"""
xml = tostring(chartsheetProtection.to_tree())
diff = compare_xml(xml, expected)
assert diff is None, diff
|