Named range bug

Jun 9, 2009 at 5:59 AM

Currently named ranges are stored in the PHPExcel.php for all worksheets using the name of the defined range as the key in the array.  In Excel 2007, you can define the same defined named in many different sheets as shown below using scope.  This causes PHPExcel to only load 1 of the 5 below since it keeps re-setting the named range ORB_V1_sh1_090527125941750.      



    <definedName name="ORB_V1_sh1_090527125941750" localSheetId="3">a!$B$7:$B$56</definedName>

    <definedName name="ORB_V1_sh1_090527125941750" localSheetId="0">'a test'!$B$7:$B$56</definedName>

    <definedName name="ORB_V1_sh1_090527125941750" localSheetId="2">b!$B$7:$B$56</definedName>

    <definedName name="ORB_V1_sh1_090527125941750" localSheetId="4">c!$B$8:$B$56</definedName>

<definedName name="ORB_V1_sh1_090527125941750">d!$B$7:$B$56</definedName>




Jun 9, 2009 at 7:09 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Jun 9, 2009 at 7:09 AM

Can you attach a sample file in the issue i've just created?