Form Controls Within Drawing Xml

[oleibman]

This is:

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

What is the expected behavior?

The test spreadsheet uploaded at #3423 (comment) contains textboxes in its xml Drawing file. PR #3720 solves most of the issue's problems, but did not address the missing textboxes. PR #3130 added limit support for form controls, but expected to find those in vml files, not in drawing xml. It remains to be seen if this can be done, but perhaps form controls included with drawing could be handled as extensions to the Drawing class, so that they might be able to be read, written, and queried by the application.

What is the current behavior?

Textboxes within Drawing xml are ignored by Xlsx Reader, and not written by Xlsx Writer. I do not know if other form controls can also appear within Drawing xml.

What are the steps to reproduce?

Loading and saving the test file demonstrates the problem. The textboxes are not found in the output file.

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 is affected. Xls, Ods, Xml, and Gnumeric are doubtless affected as well, but they don't have any Form Control support at all.

Which versions of PhpSpreadsheet and PHP are affected?

All.