ws.freeze_panes not retained when loading workbook

Issue #427 resolved
Simon Crouch created an issue

When you use load_workbook this doesn't retain the settings saved previously for worksheet.freeze_panes

code to recreate:

from openpyxl import Workbook
from openpyxl import load_workbook

wb = Workbook()
ws = wb.active
ws.freeze_panes = ws['B2']
wb.save(r'test.xlsx')

new = Workbook()
wb2 = load_workbook(r'test.xlsx')
wb2.save(r'test.xlsx')

wb2 will overwrite the file's freeze_panes on the first sheet, when actually, it should retain it.

Running on 2.7 with v2.15 (i believe, have done pip install openpyxl --upgrade at 03/Mar/15)

Comments (5)

  1. Log in to comment