Strange excel 2007 and import behavior!

Jun 2, 2008 at 8:50 PM

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 ?

Coordinator
Jun 3, 2008 at 5:59 AM
This has been fixed in the latest source release: http://www.codeplex.com/PHPExcel/SourceControl/ListDownloadableCommits.aspx
Jun 3, 2008 at 12:16 PM


maartenba wrote:
This has been fixed in the latest source release: http://www.codeplex.com/PHPExcel/SourceControl/ListDownloadableCommits.aspx


Grabbed it, tested it... seems fixed... thank you so much for the quick response !