Data Validation

Topics: Developer Forum, User Forum
Aug 16, 2012 at 7:06 AM
Edited Aug 16, 2012 at 7:07 AM

 

Hi i have a problem about the data validation
i hava a validation which accept only number's 1 or 0
but when the user try to paste other number except 1 or 0
it accept it?
is there a way to prevent this? thanks

php version 5.3.9 running on iis7 phpexcel 1.7.6
Coordinator
Aug 16, 2012 at 4:50 PM
Edited Aug 16, 2012 at 4:52 PM

How have you set up your cell validation: what is your code for this?

 

Most likely cause is that you aren't using  

$objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_STOP );