OnEachRow toArray() does not preCalculate the row

[SebastianUhlig]

Hello together.

I'm working on an Excel Importer right now and I'm running into the following problem:
In the Excel itself, for example, I specify the shipping info by =Shippinginfo!A1, which is in another sheet.

When importing, I go through each row and would like to get the corresponding shipping info row precalculated.

According to my search on an old github issue (#2612 ), it should work for onRow() with $row->toArray(null, true), since it probably can't work with WithCalculatedFormulas. However, I always get only 0.
And if I do toArray(null, false), I get =ShippingInfo!A1 (so not precalculated).

What am i doing wrong here? I dont understand. Hope someone can explain it or help me.

[patrickbrouwers]

I think you need the HasReferencesToOtherSheets concern

[SebastianUhlig]

Thank you, but unfortunately not the solution to my problem.
If I set HasReferencesToOtherSheets within the implements, ShippingInfo is still 0.
I get the related shipping info from a second sheet, but I only want to import the first one, so I skip the second sheet with

public function sheets(): array
{
    return [
        0 => $this
    ];
}

When I chosed the ToCollection method, it had worked that way, but that gave me problems elsewhere, so I chosed eachRow.

[SebastianUhlig]

After some debugging, i found out that the problem is WithChunkReading and ShouldQueue. Therefore i get the shipping info row neither calculated nor the function itself. Can someone explain why that happens and how can i solve this?

[patrickbrouwers]

But chunk reading and to collection together gives you the calculated row? You could try to set this setting to false https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/config/excel.php#L87

[SebastianUhlig]

No, I made a slight mistake there. At the time i used ToCollection, I do not used ShouldQueue. First when I switched to OnRow, I implemented the ShouldQueue.

Do you think this will work if I set read_only to true? From the documentation I had the feeling that it is not remotely related to the CalculatedFormula. I'll give it a try and let you know.

[patrickbrouwers]

With read_only (actually read data only) some information related to styling, formatting etc. goes missing to save memory. So might be related.