I just recently discovered an unwanted behavior when creating an excel 2007 file, where you copy and past formulas across a row or column and excel will auto populate the formulas changing the cell references ... then import / read the file using PHPExcel...
the formula value read by PHPExcel will be the same formula value as the first cell for all proceeding cells.
I discovered that when this occurs.. (In the Excel 2007 file) I click on the cell and place the cursor at the end of the formula and hit enter as if I just manually typed the formula and it was not an auto-populated formula from a copy action... the read
and get formula value by PHPExcel is correct!
Is this a known issue ?
What procedure is there to help prevent this ?