as I told .xlsx I tried this: $objPHPExcel->getActiveSheet()->getProtection()->setSheet(true); $objPHPExcel->getActiveSheet() ->getStyle('A1:Z1') ->getProtection()->setLocked( PHPExcel_Style_Protection::PROTECTION_UNPROTECTED ); The problem which I have is that I want to have line breaks but they don't show up until I click two times on the titles in the A 1 until Z1 cells Sincerely Negin Nickparsa On Fri, Feb 6, 2015 at 9:26 AM, Jim Lucas <lists@xxxxxxxxx> wrote: > On 02/06/2015 09:18 AM, Negin Nickparsa wrote: > > I have a sheet that I do some calculations and I should always click > enable > > editing to show the cells with results I wonder if there is any way so > that > > when I generate the 2010 excel sheets(.xlsx) make them by default enabled > > edit. > > > > Depends. What are you actually generating. The binary .xlsx file or a > .csv > or ??? > > -- > Jim Lucas > > http://www.cmsws.com/ > http://www.cmsws.com/examples/ >