SXSSF sheets and datavalidation

2020-05-15 Thread Yoeri Smets
Hi all, I'm looking arround to get a dropbox with limited possible value displayed on an SXSSFWorkbook. I've found several examples for the XSSF api however no implementation is found to create an explicitListConstraint. Is ther someone out here who has managed to get this up and running ?

Re: SXSSF sheets and datavalidation

2020-05-18 Thread Yoeri Smets
content from the variable data. > This approach would work of course only, when your contraints > definition is static and not depending on the particular data set. > > Cheers > Andreas > > > On Fri, 2020-05-15 at 13:37 +, Yoeri Smets wrote: > > Hi all, > >

Re: SXSSF sheets and datavalidation

2020-05-21 Thread Yoeri Smets
proach would be to write the SXSSF first, then to > extract/open the XML sheet and to manipulate that XML sheet > incorporating your constraints. > > I understand that these are not your preferred solutions but I do not > know of a better way. > > Best regards > Andreas >