External References without calculating

Topics: Developer Forum, User Forum
Sep 26, 2014 at 10:53 AM
Hi

I need a way to enter an external reference in an VLOOKUP but I don't need the calculation engine to calculate the value right way. It would be fine if the calculation only happens when I open the sheet in Excel on the desktop. Any way to do this?
Coordinator
Sep 26, 2014 at 11:42 AM
Edited Sep 26, 2014 at 11:43 AM
Yes, instantiate your Writer
set the Writer object setPreCalculateFormulas to false
save
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel2007");
$objWriter->setPreCalculateFormulas(false)
$objWriter->save("myFileName.xlsx");
though if you have autofit width columns, the writer needs to calculate that width, which requires recalculation, so don't use autofit width columns if you want to do this
Sep 26, 2014 at 4:01 PM
that actually did it. Thanks a lot!