poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Louis.Mast...@log-net.com
Subject Re: Large list in data validation produces error when sheet opens
Date Wed, 26 Jan 2011 17:20:16 GMT
Thanks - good idea.   I think I'll try that tonight.


Mark Beardsley <markbrdsly@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 
> see what POI is doing differently. Build the first file using POI and 
> it as simple as possible, adding only those elements that will cause the
> problem. Next, create exactly the same file using Excel. Thirdly, unzip 
> - 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 
> internals to see if you can spot where Excel's and POI's files differ. 
> you are creating the older binary file format xls files then you can use 
> 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 
> 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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message