Why did the style apply to all the column rather than the specified cell?

[411x]

I'm trying to create a first row with 3 different coloured cells. But the colour is applied to the whole column. I just want the style on the specified cell. How can I achieve this?

$spreadsheet = new Spreadsheet();

$sheet = $spreadsheet->getActiveSheet();

$sheet->setCellValue('A1', 'N')
      ->setCellValue('B1', 'Name')
      ->setCellValue('C1', 'Firstname');

$sheet->getStyle('A1')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('FFFF00');

$sheet->getStyle('B1')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('00b0f0');

$sheet->getStyle('C1')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('a8d08d');


for ($i = 1; $i <= 10; $i++) {
    $row = $sheet->getHighestRow()+1;
    $sheet->insertNewRowBefore($row);
    $sheet->setCellValue('A'.$row, $i);
}

$writer = new Xlsx($spreadsheet);
$writer->save('hello world.xlsx');

Result : https://i.imgur.com/nrthnfq.png

[oleibman]

This appears to be a bug in how insertNewRowBefore handles duplication of styles - sometimes it should; sometimes, like this one, it shouldn't. Please open this as an issue rather than a question.

[oleibman]

My comment was in error. PhpSpreadsheet is operating exactly as Excel does for this example.