Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

undefined index $ error when excel has an autofilter #976

Closed
ghost opened this issue May 6, 2019 · 3 comments
Closed

undefined index $ error when excel has an autofilter #976

ghost opened this issue May 6, 2019 · 3 comments

Comments

@ghost
Copy link

ghost commented May 6, 2019

This is:

  • [x ] a bug report

What is the expected behavior?

Importing an Excel with autofilter should work.

What is the current behavior?

undefined index $ error is generated.

What are the steps to reproduce?

Take one Excel file, add autofilter to first row. And try to load.

Which versions of PhpSpreadsheet and PHP are affected?

1.6.0

@stale
Copy link

stale bot commented Jul 5, 2019

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

@stale stale bot added the stale label Jul 5, 2019
@stale stale bot closed this as completed Jul 12, 2019
@lxShaDoWxl
Copy link

This problem actual in version 1.9.0
If added filter in google spreadsheets and download file
https://docs.google.com/spreadsheets/d/1qQhpDrSh9VGqNqrl22nDE7UQBaOL2NrIucq7vUkto_c/edit?usp=sharing
to error
PHP Notice: Undefined index: $ in vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/Coordinate.php on line 282

example code


use PhpOffice\PhpSpreadsheet\IOFactory;

require __DIR__.'/vendor/autoload.php';

$path = __DIR__.'/test2.xlsx';
/** @var \PhpOffice\PhpSpreadsheet\Reader\Xlsx $reader */
$reader = IOFactory::createReaderForFile($path);
$phpSpreadsheet = $reader->load($path);
$sheet = $phpSpreadsheet->getSheet(1);```

@astronati
Copy link
Contributor

IMHO It should be fixed by #1326

@oleibman oleibman removed the stale label Jul 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

3 participants