V
V
V Λ DIMB Λ Y Λ Z Ø V2016-04-15 14:11:10
PHP
V Λ DIMB Λ Y Λ Z Ø V, 2016-04-15 14:11:10

Formula not working in PHPExcel Can you help?

There is a formula: =$'01'.$E14
Which means: take from sheet 01, data from cell E14.
After creating an excel file with PHPExcel, this formula doesn't work.
But when in excel in this formula you erase some data (for example: 14), and return it again, the formula works.
The formula is set like this:
$objPHPExcel->getActiveSheet()->setCellValue('E14', "=\$'01'.\$E14");
If anything, the file is generated: Excel2007

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question