The other tack you may want to try is using a template file. Using Excel, create an empty workbook, set the error checking options off and then save the file away. Open this file using POI, populate a few cells and then save the results away again. Now, when you open the file using Excel again, what are the results? Hoepfully, the error checking options are set and stored and the workbook level, passed through unchanged by POI and give you the results you require; that is hopefully however as I have never tried this myself.
Yours Mark B Nick Burch wrote: > > On Thu, 17 Dec 2009, Thomas Carolan wrote: >> Is there a way to ignore validation errors using XSSF? > > I'm not sure there is yet. As a start, I'd suggest opening a new bug on > bugzilla, and uploading two files. One is a very simple 1 cell spreadsheet > with the warning there. The 2nd is the same file, having ignored the > warning and saved. If you also fancy unzipping the two files and diffing > the contents to spot what excel changes when you ignore the warning, > that'll help :) > > Cheers > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/Ignoring-Validation-Errors-tp26834228p26840323.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]
