Samples/Chart/32* Create Corrupt Files for Bubble and Surface Charts

[oleibman]

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?

Sample output should be valid.

What is the current behavior?

Excel reports errors trying to open:

• 32readwriteBubbleChart1.xlsx
• 32readwriteBubbleChart3D1.xlsx
• 32readwriteSurfaceChart1.xlsx
• 32readwriteSurfaceChart2.xlsx
• 32readwriteSurfaceChart3.xlsx
• 32readwriteSurfaceChart1.xlsx

LibreOffice does not report any corruption in the files. However, the Bubble charts are essentially missing; it shows charts in the Surface chart members, but not in the expected format (and different from how it displays the templates from which the output files are derived).

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:

Run Samples/Chart/32_Chart_read_write.php

Which versions of PhpSpreadsheet and PHP are affected?

[oleibman]

PR #2841, just merged, eliminates the corruption for Bubble Charts, and adds 3D support for those. Files now look good in Excel. LibreOffice still doesn't display them correctly. It is worth noting that LibreOffice also does not correctly display the templates on which the sample output is based. The same is true for Gnumeric.

Surface Charts were not addressed in that PR, and their samples continue to produce corrupt results.