Through our system our customers are able to freely design Excel forms generated with Aspose. Recently one customer generated a form with so many separate data validation areas that the file was viewed as corrupted by Excel and could not be opened without repair.
It is clear that we need to apply some sort of limit and after looking into this I have ended up with two requests for you:
Do you know of any specific limit on the number of data validation areas that we (or Aspose automatically) could enforce? Or is this limited by available memory?
When we handle the areas we want to add to existing validations we have a huge performance issue that comes from the fact that upon calling validation.addArea(newArea), Aspose will check all existing areas to see if newArea is already there. We have already done our area check up in a much faster way and would desperately need a way to get around this check that takes an increasing amount of time as more and more areas are added. I would like to request an alternative method with a flag to control whether or not existing areas are checked. Either addArea(area, boolean skipCheck) for adding quickly or setAreas(areas) to directly replace all previous areas with a new list.