You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Marc-Olivier Blanc <ma...@acuity-solutions.fr> on 2015/02/20 21:49:58 UTC

How to remove data validation on a cell ?

Hi,



I am reading an XLSM file and have some processing to do including writing
some data in it.



Unfortunately there are some data validation of list type on the cells and
I do not write these values in the cell. Don’t ask me why, I receive this
file as is and these validation are usefull later in the process.



Can you point to the correct way to work around these validations ? perhaps
invalidate them for the time of my processing and revalidate them
afterwards ?



Thanks for your help.



Friendly regards.

Marco.

RE: How to remove data validation on a cell ?

Posted by Marc-Olivier Blanc <ma...@acuity-solutions.fr>.
Hi,

My bad, I was mistaken. The data validation actually doesn't happened. I had
a bug in my code and was not writing in where I was expecting.

Thanks for taking the time to replay.

Friendly regards,
Marco.

-----Message d'origine-----
De : Dominik Stadler [mailto:dominik.stadler@gmx.at]
Envoyé : samedi 21 février 2015 12:12
À : POI Users List
Objet : Re: How to remove data validation on a cell ?

What error messages/validation errors do you get reported?

Thanks... Dominik.

On Fri, Feb 20, 2015 at 9:49 PM, Marc-Olivier Blanc
<ma...@acuity-solutions.fr> wrote:
> Hi,
>
>
>
> I am reading an XLSM file and have some processing to do including
> writing some data in it.
>
>
>
> Unfortunately there are some data validation of list type on the cells
> and I do not write these values in the cell. Don’t ask me why, I
> receive this file as is and these validation are usefull later in the
> process.
>
>
>
> Can you point to the correct way to work around these validations ?
> perhaps invalidate them for the time of my processing and revalidate
> them afterwards ?
>
>
>
> Thanks for your help.
>
>
>
> Friendly regards.
>
> Marco.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
commands, e-mail: user-help@poi.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: How to remove data validation on a cell ?

Posted by Dominik Stadler <do...@gmx.at>.
What error messages/validation errors do you get reported?

Thanks... Dominik.

On Fri, Feb 20, 2015 at 9:49 PM, Marc-Olivier Blanc
<ma...@acuity-solutions.fr> wrote:
> Hi,
>
>
>
> I am reading an XLSM file and have some processing to do including writing
> some data in it.
>
>
>
> Unfortunately there are some data validation of list type on the cells and
> I do not write these values in the cell. Don’t ask me why, I receive this
> file as is and these validation are usefull later in the process.
>
>
>
> Can you point to the correct way to work around these validations ? perhaps
> invalidate them for the time of my processing and revalidate them
> afterwards ?
>
>
>
> Thanks for your help.
>
>
>
> Friendly regards.
>
> Marco.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org