exceljs / exceljs/exceljs

[BUG] Template data validation lost

Open
#1,184 21 comments 0 reactions 0 assignees View on GitHub
bug enhancement
Dominant language
JavaScript
Stars
15.5k
Forks
2k
PR merge metrics
No merged PRs in 30d

Description

## 🐛 Bug Report

I have a template Excel file which includes data validations. When I use exceljs to write data to the template the data validations are lost.

Lib version: 3.8.2

## Steps To Reproduce

```javascript
// index.js
const Excel = require("exceljs");
(async () => {
const workbook = new Excel.Workbook();
await workbook.xlsx.readFile("./template.xlsx"); // Has data validation
await workbook.xlsx.writeFile("./output.xlsx"); // Data validation lost
})();
```

See attached sample project: [exceljs-bug.zip](https://github.com/exceljs/exceljs/files/4396512/exceljs-bug.zip)

## The expected behaviour:

Data validation is retained.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.