Excel Error - That command cannot be used on multiple selections

Topics: Developer Forum, User Forum
Sep 21, 2010 at 5:49 PM

Hi everyone,

   I don't know if the issue has been discuss but here I go. I use the program to generate a Excel stylesheet ( XSLS format ).

It generate the stylesheet well. But when I try to select some information, after I open the generate file , and copy to another

Excel file, a popup window appear with this line : " That command cannot be used on multiple selections ".  It only

appear when I try to cut and paste some information of the generate stylesheet to another Excel file.

    Can anybody had the same problem and found a way to resolve it ?

My configuration :

    - Ms Office 2007

    - Excel ( .XLSX ) Really important

    - PHPExcel_Writer_Excel2007

Dec 18, 2013 at 11:18 AM
I have the same problem, does anyone knows how to fix it?
Dec 18, 2013 at 11:50 AM
zhaozhi406 wrote:
I have the same problem, does anyone knows how to fix it?
I just know what's wrong with it, I once use these sentences before save excel:
$excelWriter = new PHPExcel_Writer_Excel2007($phpExcel);
$excelWriter->setOffice2003Compatibility(1); // delete this line

You just need to delete the line with comments, everything will be fine!