dhatim / fastexcel

Generate and read big Excel files quickly
Other
677 stars 122 forks source link

#453: Add new data validation: ListFormulaDataValidation. #454

Closed civgio closed 3 weeks ago

civgio commented 1 month ago

Fixing the issue 453:: a new data validation is added: ListFormulaDataValidation. This DataValidation allow to create a data validation with list type and with a formula value (to referrer a list, for example with INDIRECT formula).

In addition, it is possibility to set global visibility to a range when a named range is added.

civgio commented 1 month ago

@meiMingle @rzymek can you check the pull request and if you think the change makes sense, merge it into master?

civgio commented 1 month ago

@rzymek thank you for your comments and your time. I have fixed all your issues and I have added the tests. I hope all is ok. If you have any other doubts, I am here. Have a nice evening.

civgio commented 4 weeks ago

Please @rzymek, can you close the pull request if all is ok? Otherwise can you tell me what needs to be fix to complete the pull request? Thank you so much for your support and availability