Invalid setSelectedCells

[ghost]

Hi,

I am using this beautiful package to generate VAT reports at the end of each quarter. My own code hasn't changed in months but I am suddenly getting the error Invalid setSelectedCells B2:B311:B2:B311 B2:B311:B2:B311 which seems to originate from my Export:

    public function columnFormats(): array
    {
        return [
            'B2:B31' =>  NumberFormat::FORMAT_NUMBER,
            'C2:C31' =>  NumberFormat::FORMAT_PERCENTAGE,
            'D2:D31' =>  self::FORMAT_EUR_SIMPLE,
            'E2:E31' =>  self::FORMAT_EUR_SIMPLE,
            'F2:F31' =>  self::FORMAT_EUR_SIMPLE,
        ];
    }

I have no clue why it says B311 in the error instead of B31, if that's even related.

If I comment out the B2:B31 line then the error I get back is the same but from the C columns. Is this a PHPSpreadsheet thing or a Laravel-Excel thing? I have no clue where to look or start.

Running: PHP 7.4, Laravel 8.77.0, maatwebsite/excel 3.1.34, phpoffice/phpspreadsheet 1.20.0

[patrickbrouwers]

Current version doesn't support these kind of ranges yet (if it did before, it was something that phpspreadsheet handled, and stopped handling). However, in the next release we'll support it. #3460

[ghost]

Ah I guess PHPSpreadSheet was doing it because it definitely worked :-)

I have commented it out for now, thanks for the quick reply.

[patrickbrouwers]

Fixed has been released