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] >
