PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.2k forks source link

Undefined offset: 2 in PHPExcel/Calculation.php on line 3356 #1311

Open DeepPhil opened 6 years ago

DeepPhil commented 6 years ago

Hi, thanks for a wonderful package! Has been a real life saver.

I am getting this error, it's a seemingly benign message thrown up when PHP error reporting is switched on, but doesn't seem to affect anything.

However I thought I would raise it to see if anyone else has encountered it or can offer any suggestions for fixing it.

The project simply opens an XLS or XLSX file and iterates the worksheets saving each one as a CSV file. The error happens in the line:

$objWriter->save($saveName);

(Further info) -- I just changed the order of the first and second worksheets in one of our spreadsheets and the error followed the first worksheet, so it looks as if it may be related to the worksheet itself.

Thank you in advance.