Sheetname issues

Jun 30, 2009 at 7:47 PM


When a worksheet name contains !, extractSheetTitle fails.  This causes issues with named ranges since it uses this call.

$pRange = 'Hi! There'!A1

$reference = explode('!', $pRange);

range[0] = 'Hi

range[1] = There'

range[2] = J3

expected range[0] = 'Hi! There'

range[1] = j3

When 2 worksheets, have the simialiar names followed by a space and more characters, reader calls setTitle and renames the worksheet name when actually it is a unique name.  


sheet1 name = hello

sheet2 name = hello (2)

once reader is done, hello changes to hello 1 because is compares the string up to the last space. if ($strName == $pValue || substr($strName, 0, strrpos($strName, ' ')) == $pValue) see worksheet->setTitle()

Jul 1, 2009 at 2:45 AM

I can confirm these errors.

Fixed in SVN: