Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • O openpyxl
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 284
    • Issues 284
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 7
    • Merge requests 7
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar

In order to prepare the next update of Heptapod based on Gitlab 16.0. The instance will be unavailable on 2023-10-06 between 19:00 and 23:00 UTC+2

  • openpyxl
  • openpyxl
  • Issues
  • #1284
Closed
Open
Issue created May 22, 2019 by Bitbucket Importer@bitbucket_importerOwner

Openpyxl disable {ignore_blank} in all cell validator in Workbook

Created originally on Bitbucket by tgh101

in excel i create a cell validator with ‘ignore Blank’ option checked

wb = load_workbook(filename='DataValidationErrorExample.XLSX')
ws = wb.worksheets[0]
print(ws.data_validations)

it shows all IgnoreBlank as False. and after saving back my workbook, ‘ignore Blank’ option is unchecked for all my validators.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking