On Mon, 2002-02-18 at 14:45, [EMAIL PROTECTED] wrote: > Hi all, > > I'm a POI newbie (BTW, this stuff is great!), with what I am sure is a > newbie question. When I create a new workbook with POI, and open it in > Excel (2000), I get this message from Excel: >
You're in a commmon boat. POI's pretty new. Thanks! > "This workbook contains queries to external data that refreshes > automatically. ......" This is a known issue. At some point MS released a security fix that added this message. There is a patch on the old site (sourceforge.net/projects/poi - look under Bugs).. I believe this is also fixed in CVS. > > With options to Enable or Disable automatic refresh. My question is, what > is the external data that would be queried? Or is this a bug? (By the > way, I'm testing with the "HSSF Test" from the web pages) > It's basically a bug. Mostly, I had no idea what the property was so I set it to "true" by default (Excel 97, which I use for testing, doesn't display this error). So basically your options are: patch the production sources & build thn it will be set to false by default download and build the sources from CVS wait until version 1.5 which we'll release as an interim production release (to reflect a few bug fixes/changes/new package names). Anyhow, sorry about this one. I had to guess...it was a 50-50 chance...I'm not very lucky :-) > Thanks, > Jason -- www.superlinksoftware.com www.sourceforge.net/projects/poi - port of Excel format to java http://developer.java.sun.com/developer/bugParade/bugs/4487555.html - fix java generics! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh
