Skip to content

All tabs becoming visible after loadWorkbook #12

@dovrosenberg

Description

@dovrosenberg

Expected Behavior

When opening a workbook with loadWorkbooks, all tabs should retain the same visibility state that they have in the saved workbook that is loaded.

Actual Behavior

All tabs become visible.

Steps to Reproduce the Problem

(please attach an example xlsx file if possible)

  1. Create a workbook (an .xlsm in my case, if that matters)

  2. Hide one of the tabs

  3. call wb <- loadWorkbook(filename)

  4. sheetVisibility(wb) will show all the tabs are visible; when saving the resulting workbook, all of the tabs are visible.

sessionInfo()

  • Version of openxlsx: 4.1.3
  • Version of R: 3.6.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions