Access cached value in cells.

[clarg18]

Prerequisites

• [X] Checked if your Laravel Excel version is still supported: https://docs.laravel-excel.com/3.1/getting-started/support.html#supported-versions
• [X] Able to reproduce the behaviour outside of your code, the problem is isolated to Laravel Excel.
• [X] Checked that your issue isn't already filed.
• [X] Checked if no PR was submitted that fixes this problem.
• [X] Filled in the entire issue template

Versions

• PHP version: 7.4.3
• Laravel version: 7.0
• Package version: 3.1.19

Description

Excel spreadsheets cache the evaluation of formulae - such that a formula may reference an external document. If the link to the document is broken, the sheet will still show the evaluated value when opening the document.

I want to access this value when importing the spreadsheet. If I enable evaluate formulae on my class, it will fail as the links are broken but the value is there if you open the spreadsheet.

Steps to Reproduce

Have a spreadsheet that depends on an external spreadsheet. such as via a VLOOKUP. Have the spreadsheet evaluate the the formulae. Save the spreadsheet. Remove the external spreadsheet. Try to import with evaluate formulae enabled.

Is it possible to do this?

Many thanks,

[clarg18]

Ignore this, I didn't search correctly.

[Razka173]

@clarg18 can you tell me the solution? i have same problem with you