You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Thomas Carolan <TC...@gnf.org> on 2009/12/17 21:08:35 UTC
Ignoring Validation Errors
Is there a way to ignore validation errors using XSSF? Eliminating the green checkmark warnings "Number stored as text" is my ultimate goal. In my circumstance the values should be text because they often have leading zeros, eg 00012345. So I want the value to be text but for the validation checks to ignore those cells. Any ideas are greatly appreciate. And congrats on releasing version 3.6! The comments in XSSF are great.
Tom Carolan
Re: Ignoring Validation Errors
Posted by MSB <ma...@tiscali.co.uk>.
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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Ignoring Validation Errors
Posted by Nick Burch <ni...@torchbox.com>.
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org