Style for new cell are not compatible with Excel when RowDimension exists and style is null

[ngyuki]

This is:

- [x] a bug report
- [ ] a feature request
- [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

When RowDimension exists but its style is null, prefer column style to row style.

What is the current behavior?

When RowDimension exists, its style prefer column style, even if the style is null.

What are the steps to reproduce?

1. Apply background color to entire Column A:A in Excel (Create columnDimension(A) and apply style)
2. Changes the height of row 1:1 in Excel (Create rowDimension(1))
3. Execute the following code to change value of cell A1 and save it
4. In the saved xlsx file, the background color of cell A1 is cleared

<?php

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

use PhpOffice\PhpSpreadsheet\IOFactory;
$book = IOFactory::load(__DIR__ . '/input.xlsx');
$sheet = $book->getSheet(0);

var_dump($sheet->getCellCollection()->getCoordinates()); // []
var_dump($sheet->getColumnDimension('A')->getXfIndex()); // int(1)
var_dump($sheet->getRowDimension(1)->getXfIndex());      // NULL

$sheet->getCell('A1')->setValue('x');

var_dump($sheet->getCellCollection()->getCoordinates()); // ['A1']
var_dump($sheet->getCell('A1')->getXfIndex());           // int(0)

IOFactory::createWriter($book, IOFactory::READER_XLSX)->save(__DIR__ . '/output.xlsx');

input.xlsx
output.xlsx

What features do you think are causing the issue

• Reader
• Writer
• Styles
• Data Validations
• Formula Calculations
• Charts
• AutoFilter
• Form Elements

Does an issue affect all spreadsheet file formats? If not, which formats are affected?

XLSX (as far as I know)

Which versions of PhpSpreadsheet and PHP are affected?

php 8.2.2
phpoffice/phpspreadsheet 1.28.0 and master(e9cf273)