Skip to content
This repository has been archived by the owner on Jan 2, 2019. It is now read-only.

Fixed undefined variable error when reading Gnumeric files #212

Closed
wants to merge 2 commits into from
Closed

Fixed undefined variable error when reading Gnumeric files #212

wants to merge 2 commits into from

Conversation

IndrekHaav
Copy link

Ran across the same issue as reported two years ago on Codeplex:
http://phpexcel.codeplex.com/workitem/16208

Basically, reading Gnumeric files throws undefined variable errors due to $styleArray being used before it's initialised.

Seemed like a simple fix.

Fix for formulae that reference a sheet whose name begins with a digit; these were erroneously identified as numeric values, causing the '!' to throw an undefined variable error.
@IndrekHaav
Copy link
Author

Added another commit - fix for an issue originally reported here on Codeplex:
http://phpexcel.codeplex.com/workitem/15884

Basically, when a cell references another cell in a worksheet whose name begins with a digit, PHPExcel mistakenly identifies that reference as a numeric value, and the rest of the reference causes an error. This is because the more general CALCULATION_REGEXP_NUMBER pattern is checked before the more specific CALCULATION_REGEXP_CELLREF pattern. By simply moving the latter before the former, the references are resolved correctly.

MarkBaker pushed a commit that referenced this pull request Nov 18, 2013
…ce a sheet whose name begins with a digit:

these were erroneously identified as numeric values, causing the parser to throw an undefined variable error.
@MarkBaker
Copy link
Member

Both fixes now merged into develop branch, thanks

@MarkBaker MarkBaker closed this Nov 18, 2013
@Progi1984 Progi1984 added this to the 1.8.0 milestone Aug 26, 2014
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants