Skip to content

[BUG] Data validation list is absent for cell if source of values on another sheetΒ #41

@alinakuchai-ideals

Description

@alinakuchai-ideals

πŸ› Bug Report

Data validation list is absent for cell if source of values on another sheet

Lib version: latest

Steps To Reproduce

Create excel with two sheets
Fill cells with values on Sheet 1 (E67-E71)
On Sheet 2 add Data validation list for cell A1 with source of values from Sheet 1
Load file with workbook.xlsx.load
Actual result:
Workbook worksheet 'Sheet 2' doesn't contain dataValidation for cell A1

Expected result:
Workbook worksheet 'Sheet 2' contain dataValidation for cell A1 as
A1: {
formulae: ['=Sheet1!$E$67:$E$71'],
type: "list",
...
}

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions