PHPOffice / PhpSpreadsheet

A pure PHP library for reading and writing spreadsheet files
https://phpspreadsheet.readthedocs.io
MIT License
13.29k stars 3.44k forks source link

PDF outputs chart labels horizontally, overriding template vertical setting. #2978

Open rolinger opened 2 years ago

rolinger commented 2 years ago

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?

For PDF charts to match whats set in the Excel Template file...where x-axis plot labels (the label per plot column) are set vertically.

What is the current behavior?

Template column graphs have X-axis plot labels (the label per column) set vertically, the output is correct for XLSX files but in PDF files the charts are rendered with the text set horizontally causing the labels to override each other and become unreadable

What are the steps to reproduce?

Create an excel template with a column (vertical) chart and assign vertical text orientation for each column label. Import excel template and output a PDF file, the labels are all reset to horizontal.

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

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

PDF

Which versions of PhpSpreadsheet and PHP are affected?

PhpSpreadsheet: 1.24 PHP: 7.3 JpGraph: 4.4.1

homersimpsons commented 6 months ago

@rolinger Is this still an issue? If yes, can you provide a failing file here? And a code sample (even if it is just a "open($filePath); save($filePath)")?