Reader/Excel5 'Unrecognized token 2D in formula' in latest version

Topics: Developer Forum, User Forum
Sep 10, 2009 at 1:46 AM

We've been using PHPExcel very successfully to read excel5 workbooks. With the latest PHPExcel version (1.7.0 and svn head) we're now getting 'Unrecognized token 2D in formula' errors when trying to open workbooks which open fine with the earlier version.

A sample problem workbook is at: http://www.box.net/shared/pbyp4rdzk6

- Chris

Developer
Sep 10, 2009 at 2:06 AM

Ok, thanks, I see the problem. Your Excel workbook is using so-called shared formulas. This was not supported by Excel5 reader in PHPExcel 1.6.7. There it was only reading the calculated value instead of the formulas. Excel5 reader is supposed to support shared formulas in PHPExcel 1.7.0, but you have apparently found a bug. I will see if I can fix this tomorrow. Will post back here.

Developer
Sep 10, 2009 at 3:13 AM

Fixed:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=10615

Look at patch at that link, or just wait for source code release tomorrow, and download from here:

http://phpexcel.codeplex.com/SourceControl/ListDownloadableCommits.aspx

Sep 11, 2009 at 12:44 PM

Brilliant koyama! I'll grab it and test over the weekend.

Thanks,

Chris

Nov 18, 2013 at 8:23 PM
Edited Nov 18, 2013 at 8:23 PM
Hi,
how about "2B unrecognized token in formula"? Could you release a patch also?

Thanks,
Tom