Column fill not working

[ls-gh]

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?

All cells in the column are colored.

What is the current behavior?

Blank cells are not colored.

What are the steps to reproduce?

Please provide a Minimal, Complete, and Verifiable example of code that exhibits the issue without relying on an external Excel file or a web server:

<?php

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Style\Fill;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

$sheet->setCellValue('A5', 'ABC');
$sheet->getStyle('A:A')->getFill()->setFillType(Fill::FILL_SOLID)
  ->getStartColor()->setARGB('FFFFFF00');

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

If this is an issue with reading a specific spreadsheet file, then it may be appropriate to provide a sample file that demonstrates the problem; but please keep it as small as possible, and sanitize any confidential information before uploading.

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?

Which versions of PhpSpreadsheet and PHP are affected?

PHP 8.4.1
PhpSpreadsheet 3.6.0

[oleibman]

This is an admittedly kludgey solution, and I will look into whether something better can be done. In the meantime, after setting the column style the way you want, pick a cell with the correct styling and:

$xfIndex = $sheet->getCell('A5')->getXfIndex();
$sheet->getColumnDimension('A')->setXfIndex($xfIndex);

[ls-gh]

Thank you for your answer.

I found another workaround.
applyFromArray works as expected.

$sheet->getStyle('A:A')->getFill()->applyFromArray([
  'fillType' => 'solid',
  'startColor' => ['argb' => 'FFFFFF00'],
]);

[oleibman]

Thank you for sharing that information. Your solution is much less kludgey than mine. I confess that I do not understand why applyFromArray works differently than applying the style directly, but I can confirm that it does.