Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Hidden sheets unhide when loading and saving #279

Closed
JanMarvin opened this issue Oct 26, 2021 · 3 comments · Fixed by #282
Closed

Hidden sheets unhide when loading and saving #279

JanMarvin opened this issue Oct 26, 2021 · 3 comments · Fixed by #282
Labels
bug Something isn't working Style issue

Comments

@JanMarvin
Copy link
Collaborator

  • Tab formatting: hidden tabs reappear upon loading and saving the workbook.

Originally posted by @mendy-friedman in #207 (comment)

@JanMarvin
Copy link
Collaborator Author

Pre saving: ColorTabs3.xlsx

After saving: test3.xlsx

@JanMarvin
Copy link
Collaborator Author

From workbook.xml. The hidden argument somehow got lost and should be re-assigned.

pre saving:

<sheets>
    <sheet name="Nums" sheetId="1" r:id="rId1"/>
    <sheet name="Chars" sheetId="2" r:id="rId2"/>
    <sheet name="hidden" sheetId="3" state="hidden" r:id="rId3"/>
</sheets>

post saving:

<sheets>
    <sheet name="Nums" sheetId="1" state="visible" r:id="rId1"/>
    <sheet name="Chars" sheetId="2" state="visible" r:id="rId2"/>
    <sheet name="hidden" sheetId="3" state="visible" r:id="rId3"/>
</sheets>

@JanMarvin JanMarvin added bug Something isn't working Style issue labels Oct 26, 2021
@JanMarvin
Copy link
Collaborator Author

Seems like something is lost when reading. I'm leaving this for now, if someone is willing to pick this up or fixes it, be my guest :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Style issue
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant