External References without calculating

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

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?
Sep 26, 2014 at 10:42 AM
Edited Sep 26, 2014 at 10:43 AM
Yes, instantiate your Writer
set the Writer object setPreCalculateFormulas to false
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel2007");
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 3:01 PM
that actually did it. Thanks a lot!