32_Chart_read_write.php modifies Scatter charts in odd ways

[bridgeplayr]

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?

saved Excel Scatter Chart xlsx templates should mirror the template with no changes - (focused on Scatter Chart templates ONLY)

What is the current behavior?

Saved Excel ss with Scatter charts are modified

What are the steps to reproduce?

Run 32_Chart_read_write.php edited to select ONLY Scatter Charts, and to modify the data from the input template ss

32_Chart_read_writeScatterOnly.php.txt

### Which versions of PhpSpreadsheet and PHP are affected?
PHP version 7.4.29
phpoffice/phpspreadsheet version 1.22.0

[bridgeplayr]

I have been trying to create Excel spreadsheets with data extracted from a MySQL db. I start with a template ss containing several Scatter Charts, then add the data. None of the saved charts are accepted by Excel (Microsoft 365 MSO Version 2203.)

As a result, I tried to emulate the sample code contained in 32_Chart_read_write.php. I modified that code slightly to

1. limit the template xlsx Charts to Scatter Charts1-5. (See above code.)
2. modify the chart data by adding a constant offset for each table entry
3. to save the output file to a folder I could access instead of the unhelpful helper's choice of /tmp

My observations of the input vs output ss's are:

• In all output charts, the x-axis changes from 0-14 with no offset, to 1-12 with offset.

• The rich text font in the Chart Title is changed in all of the output charts.

• input template: 32readwriteScatterChart1.xlsx - "No join and Markers"

• output chart differences: points joined with lines; data point color changed from yellow to theme green

• (line type changed from "No line" to "automatic");

• input template: 32readwriteScatterChart2 - "Scatter - Join Bezier and Markers"

• output chart differences; points joined with straight lines instead of Bezier curves.

• Input template: 32readwriteScatterChart3 - "Scatter - Join Straight Lines and Markers"

• output chart differences; no additional changes

• input template: 32readwriteScatterChart4 - "Scatter - Join Bezier and No Markers"

• output chart differences; straight lines instead of Bezier curves

• input template: 32readwriteScatterChart5 - "Scatter - Join Straight Lines No Markers"

• output chart differences; no additional changes

It seems that the "Chart type" selection is munged (Chart1 especially). There are many Chart Types, with sub-types, some of which affect the Plot Area and Theme, some which affect the way data points are connected (or not connected at all).

(Unfortunately, despite duplicating this "read-modify-write" scheme for creating my ss-with-scatter-charts, Excel still complains and removes my scatter charts. This bug report is NOT about that problem - that will be a stackoverflow submission. However, I think there may be a connection between the behavior I observed from the Sample 32_Chart_r-w and my problem)

[oleibman]

@bridgeplayr Not sure why you closed this. For now, I am reopening it.

[bridgeplayr]

My apologies for this faux pas. I just created my Github acct so this is my first bug report, too. I want to get this right, and I’m trying to provide as much information as possible. Thank you for your forbearance. From: oleibman ***@***.***> Sent: Wednesday, April 20, 2022 8:21 PM To: PHPOffice/PhpSpreadsheet ***@***.***> Cc: bridgeplayr ***@***.***>; Mention ***@***.***> Subject: Re: [PHPOffice/PhpSpreadsheet] 32_Chart_read_write.php modifies Scatter charts in odd ways (Issue #2762) @bridgeplayr <https://github.com/bridgeplayr> Not sure why you closed this. For now, I am reopening it. — Reply to this email directly, view it on GitHub <#2762 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AYXANOBBFTS3LOTD2ODBIYDVGDCQ5ANCNFSM5T5VYUUA> . You are receiving this because you were mentioned. <https://github.com/notifications/beacon/AYXANOCMTELIP6KRDS54EKDVGDCQ5A5CNFSM5T5VYUUKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOIHL5VTI.gif> Message ID: ***@***.*** ***@***.***> >

[oleibman]

It appears to me that Reader/Xlsx/Chart has no support for the spPr tag, under which there is a noFill tag for Chart1, which is probably what handles the 'no join'. Likewise, there is markup under spPr for Chart2 which handles the Bezier curves. Even if the reader did support those, Writer/Xlsx/Chart generates nofill only for Stock Charts, and may not generate the Bezier tags at all. I'm guessing that there will also need to be changes to Chart/Chart and maybe its siblings to support this. So, this will not be a quick fix.

[bridgeplayr]

Details about the Chart Titles --
input ss: Calibri-Bold-12pt-Black Kerning enabled for fonts 12 pt and above
output ss: Calibri-Regular-18pt Black. No Kerning enabled, Normal spacing.