Named ranges referencing external workbooks are stripped when saving

Issue #353 resolved
Angus Cameron
created an issue

Book1.xlsx contains 4 named ranges, two of which reference the external workbook Book2.xlsx. If Book1.xlsx is opened, and then immediately saved, the named ranges that reference the external workbook (Book2.xlsx) are dropped, breaking the functionality of Book1.xlsx

I believe it is related to the regex in namedrange.py but may also be due to lack of handling of external workbook names.

import openpyxl
wb = openpyxl.load_workbook("book1.xlsx")
wb.save('output.xlsx')

Comments (2)

  1. CharlieC

    You're right that external ranges are not handled. I can't find anything in the specification that really explains the range stuff so this is the way things will stay until we have more information or receive a reasonable pull request.

  2. Log in to comment