in reply to read the values of formulas from files created with Spreadsheet::XLSX

You already answer your own question: without Excel you cannot calculate the formulas. Consider moving to Win32::OLE (assuming you are on Windows and have Excel installed).

  • Comment on Re: read the values of formulas from files created with Spreadsheet::XLSX