Skip to content
This repository has been archived by the owner on Jul 22, 2022. It is now read-only.

Hidden option issue on creation of first sheet #236

Closed
ssbike opened this issue Sep 19, 2018 · 2 comments
Closed

Hidden option issue on creation of first sheet #236

ssbike opened this issue Sep 19, 2018 · 2 comments
Milestone

Comments

@ssbike
Copy link

ssbike commented Sep 19, 2018

The "hidden:true" option in creating a worksheet is ignored if the sheet is the first in the order of creation. It works for subsequent sheets

@natergj
Copy link
Owner

natergj commented Sep 30, 2018

I should be able to update the library to handle this automatically, but the issue is that the default workbook active tab is set to the first tab if not overridden. If that tab is hidden, Excel chooses to show it if it is set to the active tab. For the time being, you can work around that behavior by setting the active tab to an index of a different non-hidden tab as shown in this gist.

https://gist.github.com/natergj/8cb84d3d2fa4be6e00ae74bf999027dc

@natergj natergj added this to the 1.7.0 milestone Oct 7, 2018
@natergj
Copy link
Owner

natergj commented Oct 7, 2018

as of release 1.7.0, the active tab will now be the first non-hidden tab unless otherwise specified.

@natergj natergj closed this as completed Oct 7, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants