Re: PHP and excel sheets
| From: | Negin Nickparsa | Date: | Fri, 06 Feb 2015 17:28:21 +0000 |
| Subject: | Re: PHP and excel sheets | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-324408@lists.php.net to get a copy of this message | ||
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@cmsws.com> 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/
>