Data Validation

Topics: Developer Forum, User Forum
Aug 16, 2012 at 8:06 AM
Edited Aug 16, 2012 at 8: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
Aug 16, 2012 at 5:50 PM
Edited Aug 16, 2012 at 5: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 );