Hide formula

Topics: Developer Forum, User Forum
Nov 17, 2013 at 12:03 PM
After much searching through documentation, examples, this forum and others, I have to ask.
What is the code to hide a formula? These formulas are proprietary and need to hidden in a protected cell.

Thanks
Nov 18, 2013 at 12:36 PM
Deep dive in documentation and classes... Found this :
$objPHPExcel->getActiveSheet()->getStyle('B1')->getProtection()->setHidden(PHPExcel_Style_Protection::PROTECTION_PROTECTED);
Nov 18, 2013 at 3:40 PM
Thank you very much. Guess I missed it. Going through every class is somewhat time consuming and sometimes you just don;t know what to grep for.
Thanks again. Now if I can just solve my problem of PHPExcel throwing an exception on the if(and()) formulas.