Coool I did it!:
$objPHPExcel->getActiveSheet()->getStyle('A1:Z1')
->getAlignment()->setWrapText(true);
Sincerely
Negin Nickparsa
On Fri, Feb 6, 2015 at 9:28 AM, Negin Nickparsa <nickparsa@xxxxxxxxx> wrote:
> 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/
>>
>
>
