0

I read an Excel file with PhpOffice\PhpSpreadsheet

I Excel I have some values that are calculated and the field shows the right value.

When reading the XLSX file is been read with PhpOffice\PhpSpreadsheet the value changes to #VALUE! as if there was an error in the formular.

In my XLSX there are 297 rows and this error only occurs in 62 of them.

The formular is adding two numbers from another sheet.

='SDS Master data'!BE40+'SDS Master data'!AT40

I can't figure out where the problem is, I can't see any difference between rows that works and those that doesn't.

Jeppe Donslund
  • 469
  • 9
  • 25

0 Answers0