[Bug]: Excel import issue once use =RAND() in Excel

[cdmathukiya]

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?

9.26.1

What version of PHP are you using?

8.1

Describe your issue

I have create one excel with test data of 64k+ records.
In that I have generate two column latitude and longitude and fill it with =RAND() function in Excel

Now, I am trying to import in mysql via Laravel and this packge.
I create new random value for both column.

I think issue is because of WithCalculatedFormulas

How can the issue be reproduced?

To reproduce this issue add =RAND() Function in any of column and get that data in laravel array.

What should be the expected behaviour?

same value generated in excel should be getting in array when we read excel

same value shown in image should be getting in below array

$rows = Excel::toArray(new StoreImport(), $request->file('file'));

[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.

[cdmathukiya]

found any solutin in this case?

[patrickbrouwers]

I don't think you can use RAND() in that way

[cdmathukiya]

I am using it to create test excell file