Hello,
Poi is great and has made our project much easier. Now we're at the point,
however, where we have a few issues with data validation that I was wondering
if anybody has some ideas how to solve. I am looking for work-arounds, but am
also willing to pay developers to build patches to support this functionality.
If I am missing something, and the following is supported, please let me know.
The two issues are:
1) Bug # 44953. Setting data validation to a list that is derived from a range
on a different sheet causes the resulting file to be corrupt. I have confirmed
that this is the case, and that it is in fact allowed in Excel. Poi works fine
if the range is on the same sheet. Similarly, it does not seem to work with a
named range as the source of the list. If anybody knows how to get this to
work, or is interested in a gig to develop a patch, please let me know.
2) Depended lists with INDIRECT. I need to be able to create a dropdown list
whose choices change depending on what is chosen in a previous list. This is
supported in Excel by using the INDIRECT function in a List type data
validation, however if I try to do this with Poi, I end up with a corrupt file.
Thanks in advance for your help!
--ES
