Named styles are broken when openpyxl opens and closes workbook

Issue #617 resolved
Thomas Brown created an issue

The attached file has 4 custom named styles. With openpyxl I simply open the workbook and then save it as "out.xlsx". One of the named styles now has a different font color, and the "Normal" style has also changed!

Comments (7)

  1. CharlieC

    Thanks for the report. It looks like the named styles are being stored out of order. Sigh. I hate this part of the file format.

  2. Thomas Brown reporter

    Hi again, should this be fixed? I am still experiencing the problem. (I have updated using pip --upgrade). Cheers

  3. Thomas Brown reporter

    Hi again Charlie, sorry to bother you but I hope you can help me.

    I'm trying to use PyInstaller with openpyxl, and I run into an error when using the 2.4 branch.

    When I install the release branch of openpyxl, Pyinstaller builds my exe perfectly. But when I upgrade using --pre and try to use PyInstaller, I get many warnings saying "lib not found". PyInstaller still produces an exe though, but when I try to run this, I get ImportErrors, such as from openpyxl\packaging\ saying: cannot import name 'version'.

    Do you have any idea what might be causing this and how to fix it?


  4. CharlieC

    Please use the mailing list for general discussions and do not add new issues to existing ones.

    I have no idea what Pyinstaller is but it looks like there is a problem with the metadata. You'll have to come up with a workaround.

  5. Log in to comment