Re: Large list in data validation produces error when sheet opens

[Lo...@log-net.com]

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


Louis.Masters@log-net.com wrote on 01/26/2011 12:20:16 PM:

> Thanks - good idea.   I think I'll try that tonight.
> 
> -Lou
> 
> Mark Beardsley <ma...@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
> > For additional commands, e-mail: user-help@poi.apache.org
> >