Using the setAutoFilter and setAutoSize on a Header with HORIZONTAL_CENTER

[cwolcott]

This is:

- [x] a bug report
- [x] 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?

I would have hoped that the calculateColumnWidth would take into consideration the alignment of the header.

What is the current behavior?

The calculation looks great if the header has a HORIZONTAL_LEFT, but if the header is HORIZONTAL_CENTER the calculation could be to small.

Header is HORIZONTAL_LEFT

Header is HORIZONTAL_CENTER

What features do you think are causing the issue

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

Which versions of PhpSpreadsheet and PHP are affected?

PhpSpreadsheet - 1.27.1
PHP - 8.1.13

[MarkBaker]

This isn't simply a header value in a cell, or about the alignment of the header; but these headers all have a filter icon.

Please see Issue #3356 and PR #3358 and test against the latest master branch to see if this resolves your issue.

If it is a resolution, then 1.28.0 is due for release in the next week.

[oleibman]

@MarkBaker I have 3 PR's which I think should be part of the next release PR #3372, PR #3391, PR #3392. I will try to merge them by tomorrow morning (California time).

[cwolcott]

I installed the master branch via composer

composer require "phpoffice/phpspreadsheet":dev-master

The master branch didn't fix the issue that I described when the header text is centered and has AutoFilter.

[cwolcott]

@MarkBaker loaded the latest master branch
composer require "phpoffice/phpspreadsheet":dev-master

Looks good, thank you so much.