[Bug]: When importing if I use WithCalculatedFormulas and WithMultipleSheets and associative array to select the sheets, error, when reference to another sheet: REF

[Javiedu]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• Yes, it's still reproducable

What version of Laravel Excel are you using?

3.1.48

What version of Laravel are you using?

10.18.0

What version of PHP are you using?

8.1.2

Describe your issue

In cell with this value: =$SHEET2.$O$57

With indexed array return correct value:

class ImportMultiple implements WithCalculatedFormulas, WithMultipleSheets
{
    public function sheets(): array
    {
        $temp = [
            0 => new ImportHoja(),
            2 => new ImportHoja(),
        ];

        return $temp;
    }
}

With associative array return #REF! error:

class ImportMultiple implements WithCalculatedFormulas, WithMultipleSheets
{
    public function sheets(): array
    {
        $temp = [
            "SHEET1" => new ImportHoja(),
            "SHEET3" => new ImportHoja(),
        ];

        return $temp;
    }
}

How can the issue be reproduced?

Importing xslm file with multiple sheets:

ImportHoja Class:

class ImportHoja implements ToArray, HasReferencesToOtherSheets, WithCalculatedFormulas
{
    public function array($row)
    {
        
    }

    public function collection($row)
    {
        
    }
}

Code:
$datosBruto = Excel::toCollection(new ImportMultiple, $file);

What should be the expected behaviour?

With associative array return correct value.

[patrickbrouwers]

Could you create a failing unit test for this as PR?

[stale]

This bug report has been automatically closed because it has not had recent activity. If this is still an active bug, please comment to reopen. Thank you for your contributions.