def test_freeze(self, Worksheet):
ws = Worksheet(Workbook())
ws.freeze_panes = ws['b2']
assert ws.freeze_panes == 'B2'
ws.freeze_panes = ''
assert ws.freeze_panes is None
ws.freeze_panes = 'C5'
assert ws.freeze_panes == 'C5'
ws.freeze_panes = ws['A1']
assert ws.freeze_panes is None
def test_freeze_panes_vert(Worksheet):
ws = Worksheet(Workbook())
ws.freeze_panes = 'D1'
view = ws.sheet_view
assert len(view.selection) == 1
assert dict(view.selection[0]) == {
'activeCell': 'A1',
'pane': 'topRight',
'sqref': 'A1'
}
assert dict(view.pane) == {
'activePane': 'topRight',
'state': 'frozen',
'topLeftCell': 'D1',
'xSplit': '3'
}
def test_freeze_panes_horiz(Worksheet):
ws = Worksheet(Workbook())
ws.freeze_panes = 'A4'
view = ws.sheet_view
assert len(view.selection) == 1
assert dict(view.selection[0]) == {
'activeCell': 'A1',
'pane': 'bottomLeft',
'sqref': 'A1'
}
assert dict(view.pane) == {
'activePane': 'bottomLeft',
'state': 'frozen',
'topLeftCell': 'A4',
'ySplit': '3'
}
def test_freeze_panes_both(Worksheet):
ws = Worksheet(Workbook())
ws.freeze_panes = 'D4'
view = ws.sheet_view
assert len(view.selection) == 3
assert dict(view.selection[0]) == {'pane': 'topRight'}
assert dict(view.selection[1]) == {
'pane': 'bottomLeft',
}
assert dict(view.selection[2]) == {
'activeCell': 'A1',
'pane': 'bottomRight',
'sqref': 'A1'
}
assert dict(view.pane) == {
'activePane': 'bottomRight',
'state': 'frozen',
'topLeftCell': 'D4',
'xSplit': '3',
"ySplit": "3"
}