Q:

PHPExcel how to link a sheet column to a cell using setFormula1()

I am using a PHPExcel for xls creation. how can i link a sheet column to a drop down cell. i have created a drop down in xls but how can i get sheet column like whole A column in drop down for drop down values. 
In excel i have done this manually when i link a sheet column to any cell its making formula like this 

=DropdownSheet!$A:$A

DropdonSheet is a sheet name A is a column that i am linking 
I have build a sheet using PHPExcel exactly i have done in excel DropdonSheet when i write this formula in PHPExcel to populate dropdown 
$objValidation->setFormula1("=DropdownSheet!$A:$A");

its not working giving me an error. what i am doing wrong can any one please guide me here is my whole code 
    $objPHPExcel = new PHPExcel();

// Create a first sheet, representing sales data
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Something');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Something');
$objPHPExcel->getActiveSheet()->setCellValue('A3', 'Something');
$objPHPExcel->getActiveSheet()->setCellValue('A4', 'Something');
$objPHPExcel->getActiveSheet()->setCellValue('A5', 'Something');
$objPHPExcel->getActiveSheet()->setCellValue('A6', 'Something');
$objPHPExcel->getActiveSheet()->setCellValue('A7', 'Something');
$objPHPExcel->getActiveSheet()->setCellValue('A8', 'Something');
$objPHPExcel->getActiveSheet()->setCellValue('A9', 'Something');

// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('DropdownSheet');

// Create a new worksheet, after the default sheet
$objPHPExcel->createSheet();

// Add some data to the second sheet, resembling some different data types
$objPHPExcel->setActiveSheetIndex(1);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'More data');
$objValidation = $objPHPExcel->getActiveSheet()->getCell("B1")->getDataValidation();
$objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_LIST );
$objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_INFORMATION );
$objValidation->setAllowBlank(false);
$objValidation->setShowInputMessage(true);
$objValidation->setShowErrorMessage(true);
$objValidation->setShowDropDown(true);
$objValidation->setErrorTitle('Input error');
$objValidation->setError('Value is not in list.');
$objValidation->setPromptTitle('Pick from list');
$objValidation->setPrompt('Please pick a value from the drop-down list.');
$objValidation->setFormula1("=DropdownSheet!$A:$A");

// Rename 2nd sheet
$objPHPExcel->getActiveSheet()->setTitle('Second sheet');

A:

This is the way to write this formula in PHPExcel
 $objValidation->setFormula1('DropdownSheet!$A$2:$A$6');

// Make sure NOT to put a range of cells or a formula between " and "  !!!

DropdownSheet is a sheet name 
A is a columname
I found this solution and its working fine may be it can help anyone in future here is the link for more details
link

