About selection field in Excel

[Ademgenc53]

Hello,

It's not a big deal but I was wondering Why is it selected starting from line 10 when exported? Page being longer or shorter does not change the result I completely removed the 9th and 10th lines, still the result did not change

[Ademgenc53]

I found this problem

$styleArray = [
    'borders' => [
        'horizontal' => [
            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_HAIR,
            'color' => ['argb' => 'DDDDDD'],
        ],
    ],
];
$sheet->getStyle("A2:A8")->applyFromArray($styleArray);
$sheet->getStyle("A10:A{$artibir}")->applyFromArray($styleArray);

$sheet->getStyle("B2:B8")->applyFromArray($styleArray);
$sheet->getStyle("B10:B{$artibir}")->applyFromArray($styleArray);

$sheet->getStyle("C2:C8")->applyFromArray($styleArray);
$sheet->getStyle("C10:C{$artibir}")->applyFromArray($styleArray);

$sheet->getStyle("D2:D8")->applyFromArray($styleArray);
$sheet->getStyle("D10:D{$artibir}")->applyFromArray($styleArray);

$sheet->getStyle("E2:E8")->applyFromArray($styleArray);
$sheet->getStyle("E10:E{$artibir}")->applyFromArray($styleArray);

$sheet->getStyle("F2:F8")->applyFromArray($styleArray);
$sheet->getStyle("F10:F{$artibir}")->applyFromArray($styleArray);

$sheet->getStyle("G2:G8")->applyFromArray($styleArray);
$sheet->getStyle("G10:G{$artibir}")->applyFromArray($styleArray);

$sheet->getStyle("G2:G8")->applyFromArray($styleArray);
$sheet->getStyle("G10:G{$artibir}")->applyFromArray($styleArray);

I changed it as below now it selects the whole field

$styleArray = [
    'borders' => [
        'horizontal' => [
            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_HAIR,
            'color' => ['argb' => 'DDDDDD'],
        ],
    ],
];
$sheet->getStyle("A1:H{$artibir}")->applyFromArray($styleArray);

[oleibman]

Closing. Issue appears to have been resolved by the person reporting it.