exceljs / exceljs/exceljs

Reference to an other sheet in formula

Open
#315 9 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
15.5k
Forks
2k
PR merge metrics
No merged PRs in 30d

Description

Hi, I have a problem using formula and Sheet reference.

I am using this :
```

sheet.getCell('A2').dataValidation = {
type: 'list',
allowBlank: true,
formulae: ['Company.A2:A500'],
showInputMessage: true,
promptTitle: 'Company',
prompt: 'In which company the user is in.',
};
```

And when I generate the XLSX and open the file with _libre office_ I get **'company.a2:A500'** in data validation and it don't work.

I guess there is a bug in Sheet name handling, at some point you seems to put some data in lowercase.

If you have a patch I take it please! :)

**PS**: I did try this too, and it gives the same behavior

```
sheet.getCell('A2').value = {
formula: 'Company.A10',
value: '',
};
```

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.