OK, just for some closure - this is an Excel issue - the "Source" of a validation is limited to 256 characters. I believe you can get around this by using a range of cells as the source.
Thanks, Lou [email protected] wrote on 01/26/2011 12:20:16 PM: > Thanks - good idea. I think I'll try that tonight. > > -Lou > > Mark Beardsley <[email protected]> wrote on 01/26/2011 12:13:37 PM: > > > > > Oh well, just a thought because I had seen a few posting on the internet > > about problems with large lists. > > > > Nick's advice in cases like this is to create two files and compare them > to > > see what POI is doing differently. Build the first file using POI and > make > > it as simple as possible, adding only those elements that will cause the > > problem. Next, create exactly the same file using Excel. Thirdly, unzip > both > > - I am assuming you are creating xlsx files rather than xls ones here - > > using something like WinRAR or PKUnzip and then dig around within the > files > > internals to see if you can spot where Excel's and POI's files differ. > If > > you are creating the older binary file format xls files then you can use > the > > BiffViewer utility to take a look at both and see any differences POI is > > able to detect. At the very least this will enable you to point the > > developers in the right direction if you need to raise this issue as a > bug. > > > > Good luck. > > > > Yours > > > > Mark B > > -- > > View this message in context: http://apache-poi.1045710.n5.nabble. > > com/Large-list-in-data-validation-produces-error-when-sheet-opens- > > tp3356946p3358273.html > > Sent from the POI - User mailing list archive at Nabble.com. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > >
