ycphs/openxlsx

Remove DataValidation

Closed this issue · 2 comments

Is your feature request related to a problem? Please describe.
I use dataValidation to create drop-down lists in Excel.
But I also need to be able to delete drop-down lists from an Excel which seems to not be supported by openxlsx.

Describe the solution you'd like
A function that removes drop-down lists created with dataValidation from my Excel sheet.

Describe alternatives you've considered
I unsuccessfully tried to remove drop-down lists by overwriting cells or inserting empty list elements.

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

This issue was closed because it has been stalled for 7 days with no activity.