Your requested sheet index: -1 is out of bounds. The actual number of sheets is 1

[MathewMielvac]

This is:

- [ ] a bug report

What is the expected behavior?

not throwing an Exception ?

What is the current behavior?

[Exception]
HTTP 500 Internal Server Error
Your requested sheet index: -1 is out of bounds. The actual number of sheets is 1.

What are the steps to reproduce?

        $mySpreadsheet = new Spreadsheet();
        $mySpreadsheet->removeSheetByIndex(0);
        $worksheet = new Worksheet($mySpreadsheet, 'Insured List');
        $mySpreadsheet->addSheet($worksheet, 0);
        $row = 1;
        $col = 1;
        $worksheet->getCell([$col, $row])->setValue('id_uti');

What features do you think are causing the issue

• Worksheet

Which versions of PhpSpreadsheet and PHP are affected?

PhpSpreadsheet 2.2 / PHP 8.3

[oleibman]

Confirmed, introduced with 2.2. Researching.

[oleibman]

I see the problem and am working on a solution. As a workaround, you can add the following line after addSheet:

$mySpreadsheet->setActiveSheetIndex(0);

I think addSheet probably ought to set the Active Sheet anyhow when there is no other sheet in the workbook.

[oleibman]

Better workaround - don't specify sheet number 0 on your addSheet. This will cause Active Sheet to be set to the new sheet automatically if it's the only sheet:

$mySpreadsheet->addSheet($worksheet);