Secondary y-axis not available in PHP Spreadsheet #560
Comments
|
Because I can't wait for a fix I have adapted Porrapat's fix to PHP Spreadsheet and it works. But of course it is hard coded ... would be better if it was integrated into the standard. If you need the code just let me know - and tell me how to post it please. |
|
Consider contributing a PR with the new code to increase the change of
seeing this integrated
|
|
I guess that requires I use github as version control solution which I currently don't. For your convenience I have attached the files that I changed and an example that I created. All is based on PHPSpreadsheet version 1.2.1, 10 April 2018 |
|
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. |
|
Followed rf1234's codes, merge with current version 1.15.0 and create a patch It enables secondary y-axis in PHP spreadsheet. |
Stock charts currently ignore upDownBars tag and its subsidiary gapWidth, upBars, and downBars tags when reading, and hard-codes those tags on write. As a result, the sample reproductions of stock charts in the 32* series aren't faithful to the originals. This PR fixes samples 1, 2, and 5. Samples 3 and 4 are reproduced better, but they require currently unsupported secondary axes (issue PHPOffice#560, issue PHPOffice#1072, and PR PHPOffice#1073 were closed as stale; see also PHPOffice/PHPExcel#1037). I will start to look at those, but it could take a while, and I don't think there's a reason to delay this in the meantime. Charts which depended on the hard-coded values written by the Xlsx Chart writer will be slightly different as a result of this change. To restore the hard-coded behavior: ```php $plotArea->setGapWidth(300); $plotArea->setUseUpBars(true); $plotArea->setUseDownBars(true); ``` The new behavior is demonstrated in 33_Chart_create_stock. The old behavior is demonstrated (with the code above) in new 33_Chart_create_stock2.
Stock charts currently ignore upDownBars tag and its subsidiary gapWidth, upBars, and downBars tags when reading, and hard-codes those tags on write. As a result, the sample reproductions of stock charts in the 32* series aren't faithful to the originals. This PR fixes samples 1, 2, and 5. Samples 3 and 4 are reproduced better, but they require currently unsupported secondary axes (issue #560, issue #1072, and PR #1073 were closed as stale; see also PHPOffice/PHPExcel#1037). I will start to look at those, but it could take a while, and I don't think there's a reason to delay this in the meantime. Charts which depended on the hard-coded values written by the Xlsx Chart writer will be slightly different as a result of this change. To restore the hard-coded behavior: ```php $plotArea->setGapWidth(300); $plotArea->setUseUpBars(true); $plotArea->setUseDownBars(true); ``` The new behavior is demonstrated in 33_Chart_create_stock. The old behavior is demonstrated (with the code above) in new 33_Chart_create_stock2.
This is:
What is the expected behavior?
PHP Spreadsheet should be able to handle a secondary Y axis.
What is the current behavior?
It is not possible to define a secondary Y axis.
What are the steps to reproduce?
Somebody has already posted a solution for PHP Excel which wasn't implemented because PHP Excel is deprecated. Could you integrate the feature based on this post please:
PHPOffice/PHPExcel#1037
Which versions of PhpSpreadsheet and PHP are affected?
The current version
The text was updated successfully, but these errors were encountered: