formula1 dont work on add_data_validation

randym / axlsx

xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.

MIT License

2.62k stars 695 forks source link

formula1 dont work on add_data_validation #651

Open paulomcnally opened 4 years ago

paulomcnally commented 4 years ago

I create formula on Excel UI and work. But use formula1: '=INDIRECT(INDIRECT("C"&MID(CELL("address"),4,1))&"!A$2:A$30")' and dont work. The excel file generated is corrupted.

Any idea?

=INDIRECT(INDIRECT("C"&MID(CELL("address"),4,1))&"!A$2:A$30")

vsolari commented 2 years ago

Hola Paulo, lograste agregar la formula en formula1 ?