ILIAS  release_5-4 Revision v5.4.26-12-gabc799a52e6
Chart.php
Go to the documentation of this file.
1 <?php
2 
3 namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx;
4 
5 use PhpOffice\PhpSpreadsheet\Chart\Axis;
6 use PhpOffice\PhpSpreadsheet\Chart\DataSeries;
7 use PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues;
8 use PhpOffice\PhpSpreadsheet\Chart\GridLines;
9 use PhpOffice\PhpSpreadsheet\Chart\Layout;
10 use PhpOffice\PhpSpreadsheet\Chart\Legend;
11 use PhpOffice\PhpSpreadsheet\Chart\PlotArea;
12 use PhpOffice\PhpSpreadsheet\Chart\Title;
13 use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
14 use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;
15 use PhpOffice\PhpSpreadsheet\Writer\Exception as WriterException;
16 
17 class Chart extends WriterPart
18 {
19  protected $calculateCellValues;
20 
24  private $seriesIndex;
25 
33  public function writeChart(\PhpOffice\PhpSpreadsheet\Chart\Chart $pChart, $calculateCellValues = true)
34  {
35  $this->calculateCellValues = $calculateCellValues;
36 
37  // Create XML writer
38  $objWriter = null;
39  if ($this->getParentWriter()->getUseDiskCaching()) {
40  $objWriter = new XMLWriter(XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
41  } else {
42  $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
43  }
44  // Ensure that data series values are up-to-date before we save
45  if ($this->calculateCellValues) {
46  $pChart->refresh();
47  }
48 
49  // XML header
50  $objWriter->startDocument('1.0', 'UTF-8', 'yes');
51 
52  // c:chartSpace
53  $objWriter->startElement('c:chartSpace');
54  $objWriter->writeAttribute('xmlns:c', 'http://schemas.openxmlformats.org/drawingml/2006/chart');
55  $objWriter->writeAttribute('xmlns:a', 'http://schemas.openxmlformats.org/drawingml/2006/main');
56  $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
57 
58  $objWriter->startElement('c:date1904');
59  $objWriter->writeAttribute('val', 0);
60  $objWriter->endElement();
61  $objWriter->startElement('c:lang');
62  $objWriter->writeAttribute('val', 'en-GB');
63  $objWriter->endElement();
64  $objWriter->startElement('c:roundedCorners');
65  $objWriter->writeAttribute('val', 0);
66  $objWriter->endElement();
67 
68  $this->writeAlternateContent($objWriter);
69 
70  $objWriter->startElement('c:chart');
71 
72  $this->writeTitle($objWriter, $pChart->getTitle());
73 
74  $objWriter->startElement('c:autoTitleDeleted');
75  $objWriter->writeAttribute('val', 0);
76  $objWriter->endElement();
77 
78  $this->writePlotArea($objWriter, $pChart->getWorksheet(), $pChart->getPlotArea(), $pChart->getXAxisLabel(), $pChart->getYAxisLabel(), $pChart->getChartAxisX(), $pChart->getChartAxisY(), $pChart->getMajorGridlines(), $pChart->getMinorGridlines());
79 
80  $this->writeLegend($objWriter, $pChart->getLegend());
81 
82  $objWriter->startElement('c:plotVisOnly');
83  $objWriter->writeAttribute('val', (int) $pChart->getPlotVisibleOnly());
84  $objWriter->endElement();
85 
86  $objWriter->startElement('c:dispBlanksAs');
87  $objWriter->writeAttribute('val', $pChart->getDisplayBlanksAs());
88  $objWriter->endElement();
89 
90  $objWriter->startElement('c:showDLblsOverMax');
91  $objWriter->writeAttribute('val', 0);
92  $objWriter->endElement();
93 
94  $objWriter->endElement();
95 
96  $this->writePrintSettings($objWriter);
97 
98  $objWriter->endElement();
99 
100  // Return
101  return $objWriter->getData();
102  }
103 
110  private function writeTitle(XMLWriter $objWriter, ?Title $title = null): void
111  {
112  if ($title === null) {
113  return;
114  }
115 
116  $objWriter->startElement('c:title');
117  $objWriter->startElement('c:tx');
118  $objWriter->startElement('c:rich');
119 
120  $objWriter->startElement('a:bodyPr');
121  $objWriter->endElement();
122 
123  $objWriter->startElement('a:lstStyle');
124  $objWriter->endElement();
125 
126  $objWriter->startElement('a:p');
127 
128  $caption = $title->getCaption();
129  if ((is_array($caption)) && (count($caption) > 0)) {
130  $caption = $caption[0];
131  }
132  $this->getParentWriter()->getWriterPartstringtable()->writeRichTextForCharts($objWriter, $caption, 'a');
133 
134  $objWriter->endElement();
135  $objWriter->endElement();
136  $objWriter->endElement();
137 
138  $this->writeLayout($objWriter, $title->getLayout());
139 
140  $objWriter->startElement('c:overlay');
141  $objWriter->writeAttribute('val', 0);
142  $objWriter->endElement();
143 
144  $objWriter->endElement();
145  }
146 
153  private function writeLegend(XMLWriter $objWriter, ?Legend $legend = null): void
154  {
155  if ($legend === null) {
156  return;
157  }
158 
159  $objWriter->startElement('c:legend');
160 
161  $objWriter->startElement('c:legendPos');
162  $objWriter->writeAttribute('val', $legend->getPosition());
163  $objWriter->endElement();
164 
165  $this->writeLayout($objWriter, $legend->getLayout());
166 
167  $objWriter->startElement('c:overlay');
168  $objWriter->writeAttribute('val', ($legend->getOverlay()) ? '1' : '0');
169  $objWriter->endElement();
170 
171  $objWriter->startElement('c:txPr');
172  $objWriter->startElement('a:bodyPr');
173  $objWriter->endElement();
174 
175  $objWriter->startElement('a:lstStyle');
176  $objWriter->endElement();
177 
178  $objWriter->startElement('a:p');
179  $objWriter->startElement('a:pPr');
180  $objWriter->writeAttribute('rtl', 0);
181 
182  $objWriter->startElement('a:defRPr');
183  $objWriter->endElement();
184  $objWriter->endElement();
185 
186  $objWriter->startElement('a:endParaRPr');
187  $objWriter->writeAttribute('lang', 'en-US');
188  $objWriter->endElement();
189 
190  $objWriter->endElement();
191  $objWriter->endElement();
192 
193  $objWriter->endElement();
194  }
195 
205  private function writePlotArea(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, PlotArea $plotArea, ?Title $xAxisLabel = null, ?Title $yAxisLabel = null, ?Axis $xAxis = null, ?Axis $yAxis = null, ?GridLines $majorGridlines = null, ?GridLines $minorGridlines = null): void
206  {
207  if ($plotArea === null) {
208  return;
209  }
210 
211  $id1 = $id2 = 0;
212  $this->seriesIndex = 0;
213  $objWriter->startElement('c:plotArea');
214 
215  $layout = $plotArea->getLayout();
216 
217  $this->writeLayout($objWriter, $layout);
218 
219  $chartTypes = self::getChartType($plotArea);
220  $catIsMultiLevelSeries = $valIsMultiLevelSeries = false;
221  $plotGroupingType = '';
222  $chartType = null;
223  foreach ($chartTypes as $chartType) {
224  $objWriter->startElement('c:' . $chartType);
225 
226  $groupCount = $plotArea->getPlotGroupCount();
227  $plotGroup = null;
228  for ($i = 0; $i < $groupCount; ++$i) {
229  $plotGroup = $plotArea->getPlotGroupByIndex($i);
230  $groupType = $plotGroup->getPlotType();
231  if ($groupType == $chartType) {
232  $plotStyle = $plotGroup->getPlotStyle();
233  if ($groupType === DataSeries::TYPE_RADARCHART) {
234  $objWriter->startElement('c:radarStyle');
235  $objWriter->writeAttribute('val', $plotStyle);
236  $objWriter->endElement();
237  } elseif ($groupType === DataSeries::TYPE_SCATTERCHART) {
238  $objWriter->startElement('c:scatterStyle');
239  $objWriter->writeAttribute('val', $plotStyle);
240  $objWriter->endElement();
241  }
242 
243  $this->writePlotGroup($plotGroup, $chartType, $objWriter, $catIsMultiLevelSeries, $valIsMultiLevelSeries, $plotGroupingType);
244  }
245  }
246 
247  $this->writeDataLabels($objWriter, $layout);
248 
249  if ($chartType === DataSeries::TYPE_LINECHART && $plotGroup) {
250  // Line only, Line3D can't be smoothed
251  $objWriter->startElement('c:smooth');
252  $objWriter->writeAttribute('val', (int) $plotGroup->getSmoothLine());
253  $objWriter->endElement();
254  } elseif (($chartType === DataSeries::TYPE_BARCHART) || ($chartType === DataSeries::TYPE_BARCHART_3D)) {
255  $objWriter->startElement('c:gapWidth');
256  $objWriter->writeAttribute('val', 150);
257  $objWriter->endElement();
258 
259  if ($plotGroupingType == 'percentStacked' || $plotGroupingType == 'stacked') {
260  $objWriter->startElement('c:overlap');
261  $objWriter->writeAttribute('val', 100);
262  $objWriter->endElement();
263  }
264  } elseif ($chartType === DataSeries::TYPE_BUBBLECHART) {
265  $objWriter->startElement('c:bubbleScale');
266  $objWriter->writeAttribute('val', 25);
267  $objWriter->endElement();
268 
269  $objWriter->startElement('c:showNegBubbles');
270  $objWriter->writeAttribute('val', 0);
271  $objWriter->endElement();
272  } elseif ($chartType === DataSeries::TYPE_STOCKCHART) {
273  $objWriter->startElement('c:hiLowLines');
274  $objWriter->endElement();
275 
276  $objWriter->startElement('c:upDownBars');
277 
278  $objWriter->startElement('c:gapWidth');
279  $objWriter->writeAttribute('val', 300);
280  $objWriter->endElement();
281 
282  $objWriter->startElement('c:upBars');
283  $objWriter->endElement();
284 
285  $objWriter->startElement('c:downBars');
286  $objWriter->endElement();
287 
288  $objWriter->endElement();
289  }
290 
291  // Generate 2 unique numbers to use for axId values
292  $id1 = '75091328';
293  $id2 = '75089408';
294 
295  if (($chartType !== DataSeries::TYPE_PIECHART) && ($chartType !== DataSeries::TYPE_PIECHART_3D) && ($chartType !== DataSeries::TYPE_DONUTCHART)) {
296  $objWriter->startElement('c:axId');
297  $objWriter->writeAttribute('val', $id1);
298  $objWriter->endElement();
299  $objWriter->startElement('c:axId');
300  $objWriter->writeAttribute('val', $id2);
301  $objWriter->endElement();
302  } else {
303  $objWriter->startElement('c:firstSliceAng');
304  $objWriter->writeAttribute('val', 0);
305  $objWriter->endElement();
306 
307  if ($chartType === DataSeries::TYPE_DONUTCHART) {
308  $objWriter->startElement('c:holeSize');
309  $objWriter->writeAttribute('val', 50);
310  $objWriter->endElement();
311  }
312  }
313 
314  $objWriter->endElement();
315  }
316 
317  if (($chartType !== DataSeries::TYPE_PIECHART) && ($chartType !== DataSeries::TYPE_PIECHART_3D) && ($chartType !== DataSeries::TYPE_DONUTCHART)) {
318  if ($chartType === DataSeries::TYPE_BUBBLECHART) {
319  $this->writeValueAxis($objWriter, $xAxisLabel, $chartType, $id1, $id2, $catIsMultiLevelSeries, $xAxis, $majorGridlines, $minorGridlines);
320  } else {
321  $this->writeCategoryAxis($objWriter, $xAxisLabel, $id1, $id2, $catIsMultiLevelSeries, $xAxis);
322  }
323 
324  $this->writeValueAxis($objWriter, $yAxisLabel, $chartType, $id1, $id2, $valIsMultiLevelSeries, $yAxis, $majorGridlines, $minorGridlines);
325  }
326 
327  $objWriter->endElement();
328  }
329 
336  private function writeDataLabels(XMLWriter $objWriter, ?Layout $chartLayout = null): void
337  {
338  $objWriter->startElement('c:dLbls');
339 
340  $objWriter->startElement('c:showLegendKey');
341  $showLegendKey = (empty($chartLayout)) ? 0 : $chartLayout->getShowLegendKey();
342  $objWriter->writeAttribute('val', ((empty($showLegendKey)) ? 0 : 1));
343  $objWriter->endElement();
344 
345  $objWriter->startElement('c:showVal');
346  $showVal = (empty($chartLayout)) ? 0 : $chartLayout->getShowVal();
347  $objWriter->writeAttribute('val', ((empty($showVal)) ? 0 : 1));
348  $objWriter->endElement();
349 
350  $objWriter->startElement('c:showCatName');
351  $showCatName = (empty($chartLayout)) ? 0 : $chartLayout->getShowCatName();
352  $objWriter->writeAttribute('val', ((empty($showCatName)) ? 0 : 1));
353  $objWriter->endElement();
354 
355  $objWriter->startElement('c:showSerName');
356  $showSerName = (empty($chartLayout)) ? 0 : $chartLayout->getShowSerName();
357  $objWriter->writeAttribute('val', ((empty($showSerName)) ? 0 : 1));
358  $objWriter->endElement();
359 
360  $objWriter->startElement('c:showPercent');
361  $showPercent = (empty($chartLayout)) ? 0 : $chartLayout->getShowPercent();
362  $objWriter->writeAttribute('val', ((empty($showPercent)) ? 0 : 1));
363  $objWriter->endElement();
364 
365  $objWriter->startElement('c:showBubbleSize');
366  $showBubbleSize = (empty($chartLayout)) ? 0 : $chartLayout->getShowBubbleSize();
367  $objWriter->writeAttribute('val', ((empty($showBubbleSize)) ? 0 : 1));
368  $objWriter->endElement();
369 
370  $objWriter->startElement('c:showLeaderLines');
371  $showLeaderLines = (empty($chartLayout)) ? 1 : $chartLayout->getShowLeaderLines();
372  $objWriter->writeAttribute('val', ((empty($showLeaderLines)) ? 0 : 1));
373  $objWriter->endElement();
374 
375  $objWriter->endElement();
376  }
377 
387  private function writeCategoryAxis($objWriter, $xAxisLabel, $id1, $id2, $isMultiLevelSeries, Axis $yAxis): void
388  {
389  $objWriter->startElement('c:catAx');
390 
391  if ($id1 > 0) {
392  $objWriter->startElement('c:axId');
393  $objWriter->writeAttribute('val', $id1);
394  $objWriter->endElement();
395  }
396 
397  $objWriter->startElement('c:scaling');
398  $objWriter->startElement('c:orientation');
399  $objWriter->writeAttribute('val', $yAxis->getAxisOptionsProperty('orientation'));
400  $objWriter->endElement();
401  $objWriter->endElement();
402 
403  $objWriter->startElement('c:delete');
404  $objWriter->writeAttribute('val', 0);
405  $objWriter->endElement();
406 
407  $objWriter->startElement('c:axPos');
408  $objWriter->writeAttribute('val', 'b');
409  $objWriter->endElement();
410 
411  if ($xAxisLabel !== null) {
412  $objWriter->startElement('c:title');
413  $objWriter->startElement('c:tx');
414  $objWriter->startElement('c:rich');
415 
416  $objWriter->startElement('a:bodyPr');
417  $objWriter->endElement();
418 
419  $objWriter->startElement('a:lstStyle');
420  $objWriter->endElement();
421 
422  $objWriter->startElement('a:p');
423  $objWriter->startElement('a:r');
424 
425  $caption = $xAxisLabel->getCaption();
426  if (is_array($caption)) {
427  $caption = $caption[0];
428  }
429  $objWriter->startElement('a:t');
430  $objWriter->writeRawData(StringHelper::controlCharacterPHP2OOXML($caption));
431  $objWriter->endElement();
432 
433  $objWriter->endElement();
434  $objWriter->endElement();
435  $objWriter->endElement();
436  $objWriter->endElement();
437 
438  $layout = $xAxisLabel->getLayout();
439  $this->writeLayout($objWriter, $layout);
440 
441  $objWriter->startElement('c:overlay');
442  $objWriter->writeAttribute('val', 0);
443  $objWriter->endElement();
444 
445  $objWriter->endElement();
446  }
447 
448  $objWriter->startElement('c:numFmt');
449  $objWriter->writeAttribute('formatCode', $yAxis->getAxisNumberFormat());
450  $objWriter->writeAttribute('sourceLinked', $yAxis->getAxisNumberSourceLinked());
451  $objWriter->endElement();
452 
453  $objWriter->startElement('c:majorTickMark');
454  $objWriter->writeAttribute('val', $yAxis->getAxisOptionsProperty('major_tick_mark'));
455  $objWriter->endElement();
456 
457  $objWriter->startElement('c:minorTickMark');
458  $objWriter->writeAttribute('val', $yAxis->getAxisOptionsProperty('minor_tick_mark'));
459  $objWriter->endElement();
460 
461  $objWriter->startElement('c:tickLblPos');
462  $objWriter->writeAttribute('val', $yAxis->getAxisOptionsProperty('axis_labels'));
463  $objWriter->endElement();
464 
465  if ($id2 > 0) {
466  $objWriter->startElement('c:crossAx');
467  $objWriter->writeAttribute('val', $id2);
468  $objWriter->endElement();
469 
470  $objWriter->startElement('c:crosses');
471  $objWriter->writeAttribute('val', $yAxis->getAxisOptionsProperty('horizontal_crosses'));
472  $objWriter->endElement();
473  }
474 
475  $objWriter->startElement('c:auto');
476  $objWriter->writeAttribute('val', 1);
477  $objWriter->endElement();
478 
479  $objWriter->startElement('c:lblAlgn');
480  $objWriter->writeAttribute('val', 'ctr');
481  $objWriter->endElement();
482 
483  $objWriter->startElement('c:lblOffset');
484  $objWriter->writeAttribute('val', 100);
485  $objWriter->endElement();
486 
487  if ($isMultiLevelSeries) {
488  $objWriter->startElement('c:noMultiLvlLbl');
489  $objWriter->writeAttribute('val', 0);
490  $objWriter->endElement();
491  }
492  $objWriter->endElement();
493  }
494 
505  private function writeValueAxis($objWriter, $yAxisLabel, $groupType, $id1, $id2, $isMultiLevelSeries, Axis $xAxis, GridLines $majorGridlines, GridLines $minorGridlines): void
506  {
507  $objWriter->startElement('c:valAx');
508 
509  if ($id2 > 0) {
510  $objWriter->startElement('c:axId');
511  $objWriter->writeAttribute('val', $id2);
512  $objWriter->endElement();
513  }
514 
515  $objWriter->startElement('c:scaling');
516 
517  if ($xAxis->getAxisOptionsProperty('maximum') !== null) {
518  $objWriter->startElement('c:max');
519  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('maximum'));
520  $objWriter->endElement();
521  }
522 
523  if ($xAxis->getAxisOptionsProperty('minimum') !== null) {
524  $objWriter->startElement('c:min');
525  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('minimum'));
526  $objWriter->endElement();
527  }
528 
529  $objWriter->startElement('c:orientation');
530  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('orientation'));
531 
532  $objWriter->endElement();
533  $objWriter->endElement();
534 
535  $objWriter->startElement('c:delete');
536  $objWriter->writeAttribute('val', 0);
537  $objWriter->endElement();
538 
539  $objWriter->startElement('c:axPos');
540  $objWriter->writeAttribute('val', 'l');
541  $objWriter->endElement();
542 
543  $objWriter->startElement('c:majorGridlines');
544  $objWriter->startElement('c:spPr');
545 
546  if ($majorGridlines->getLineColorProperty('value') !== null) {
547  $objWriter->startElement('a:ln');
548  $objWriter->writeAttribute('w', $majorGridlines->getLineStyleProperty('width'));
549  $objWriter->startElement('a:solidFill');
550  $objWriter->startElement("a:{$majorGridlines->getLineColorProperty('type')}");
551  $objWriter->writeAttribute('val', $majorGridlines->getLineColorProperty('value'));
552  $objWriter->startElement('a:alpha');
553  $objWriter->writeAttribute('val', $majorGridlines->getLineColorProperty('alpha'));
554  $objWriter->endElement(); //end alpha
555  $objWriter->endElement(); //end srgbClr
556  $objWriter->endElement(); //end solidFill
557 
558  $objWriter->startElement('a:prstDash');
559  $objWriter->writeAttribute('val', $majorGridlines->getLineStyleProperty('dash'));
560  $objWriter->endElement();
561 
562  if ($majorGridlines->getLineStyleProperty('join') == 'miter') {
563  $objWriter->startElement('a:miter');
564  $objWriter->writeAttribute('lim', '800000');
565  $objWriter->endElement();
566  } else {
567  $objWriter->startElement('a:bevel');
568  $objWriter->endElement();
569  }
570 
571  if ($majorGridlines->getLineStyleProperty(['arrow', 'head', 'type']) !== null) {
572  $objWriter->startElement('a:headEnd');
573  $objWriter->writeAttribute('type', $majorGridlines->getLineStyleProperty(['arrow', 'head', 'type']));
574  $objWriter->writeAttribute('w', $majorGridlines->getLineStyleArrowParameters('head', 'w'));
575  $objWriter->writeAttribute('len', $majorGridlines->getLineStyleArrowParameters('head', 'len'));
576  $objWriter->endElement();
577  }
578 
579  if ($majorGridlines->getLineStyleProperty(['arrow', 'end', 'type']) !== null) {
580  $objWriter->startElement('a:tailEnd');
581  $objWriter->writeAttribute('type', $majorGridlines->getLineStyleProperty(['arrow', 'end', 'type']));
582  $objWriter->writeAttribute('w', $majorGridlines->getLineStyleArrowParameters('end', 'w'));
583  $objWriter->writeAttribute('len', $majorGridlines->getLineStyleArrowParameters('end', 'len'));
584  $objWriter->endElement();
585  }
586  $objWriter->endElement(); //end ln
587  }
588  $objWriter->startElement('a:effectLst');
589 
590  if ($majorGridlines->getGlowSize() !== null) {
591  $objWriter->startElement('a:glow');
592  $objWriter->writeAttribute('rad', $majorGridlines->getGlowSize());
593  $objWriter->startElement("a:{$majorGridlines->getGlowColor('type')}");
594  $objWriter->writeAttribute('val', $majorGridlines->getGlowColor('value'));
595  $objWriter->startElement('a:alpha');
596  $objWriter->writeAttribute('val', $majorGridlines->getGlowColor('alpha'));
597  $objWriter->endElement(); //end alpha
598  $objWriter->endElement(); //end schemeClr
599  $objWriter->endElement(); //end glow
600  }
601 
602  if ($majorGridlines->getShadowProperty('presets') !== null) {
603  $objWriter->startElement("a:{$majorGridlines->getShadowProperty('effect')}");
604  if ($majorGridlines->getShadowProperty('blur') !== null) {
605  $objWriter->writeAttribute('blurRad', $majorGridlines->getShadowProperty('blur'));
606  }
607  if ($majorGridlines->getShadowProperty('distance') !== null) {
608  $objWriter->writeAttribute('dist', $majorGridlines->getShadowProperty('distance'));
609  }
610  if ($majorGridlines->getShadowProperty('direction') !== null) {
611  $objWriter->writeAttribute('dir', $majorGridlines->getShadowProperty('direction'));
612  }
613  if ($majorGridlines->getShadowProperty('algn') !== null) {
614  $objWriter->writeAttribute('algn', $majorGridlines->getShadowProperty('algn'));
615  }
616  if ($majorGridlines->getShadowProperty(['size', 'sx']) !== null) {
617  $objWriter->writeAttribute('sx', $majorGridlines->getShadowProperty(['size', 'sx']));
618  }
619  if ($majorGridlines->getShadowProperty(['size', 'sy']) !== null) {
620  $objWriter->writeAttribute('sy', $majorGridlines->getShadowProperty(['size', 'sy']));
621  }
622  if ($majorGridlines->getShadowProperty(['size', 'kx']) !== null) {
623  $objWriter->writeAttribute('kx', $majorGridlines->getShadowProperty(['size', 'kx']));
624  }
625  if ($majorGridlines->getShadowProperty('rotWithShape') !== null) {
626  $objWriter->writeAttribute('rotWithShape', $majorGridlines->getShadowProperty('rotWithShape'));
627  }
628  $objWriter->startElement("a:{$majorGridlines->getShadowProperty(['color', 'type'])}");
629  $objWriter->writeAttribute('val', $majorGridlines->getShadowProperty(['color', 'value']));
630 
631  $objWriter->startElement('a:alpha');
632  $objWriter->writeAttribute('val', $majorGridlines->getShadowProperty(['color', 'alpha']));
633  $objWriter->endElement(); //end alpha
634 
635  $objWriter->endElement(); //end color:type
636  $objWriter->endElement(); //end shadow
637  }
638 
639  if ($majorGridlines->getSoftEdgesSize() !== null) {
640  $objWriter->startElement('a:softEdge');
641  $objWriter->writeAttribute('rad', $majorGridlines->getSoftEdgesSize());
642  $objWriter->endElement(); //end softEdge
643  }
644 
645  $objWriter->endElement(); //end effectLst
646  $objWriter->endElement(); //end spPr
647  $objWriter->endElement(); //end majorGridLines
648 
649  if ($minorGridlines->getObjectState()) {
650  $objWriter->startElement('c:minorGridlines');
651  $objWriter->startElement('c:spPr');
652 
653  if ($minorGridlines->getLineColorProperty('value') !== null) {
654  $objWriter->startElement('a:ln');
655  $objWriter->writeAttribute('w', $minorGridlines->getLineStyleProperty('width'));
656  $objWriter->startElement('a:solidFill');
657  $objWriter->startElement("a:{$minorGridlines->getLineColorProperty('type')}");
658  $objWriter->writeAttribute('val', $minorGridlines->getLineColorProperty('value'));
659  $objWriter->startElement('a:alpha');
660  $objWriter->writeAttribute('val', $minorGridlines->getLineColorProperty('alpha'));
661  $objWriter->endElement(); //end alpha
662  $objWriter->endElement(); //end srgbClr
663  $objWriter->endElement(); //end solidFill
664 
665  $objWriter->startElement('a:prstDash');
666  $objWriter->writeAttribute('val', $minorGridlines->getLineStyleProperty('dash'));
667  $objWriter->endElement();
668 
669  if ($minorGridlines->getLineStyleProperty('join') == 'miter') {
670  $objWriter->startElement('a:miter');
671  $objWriter->writeAttribute('lim', '800000');
672  $objWriter->endElement();
673  } else {
674  $objWriter->startElement('a:bevel');
675  $objWriter->endElement();
676  }
677 
678  if ($minorGridlines->getLineStyleProperty(['arrow', 'head', 'type']) !== null) {
679  $objWriter->startElement('a:headEnd');
680  $objWriter->writeAttribute('type', $minorGridlines->getLineStyleProperty(['arrow', 'head', 'type']));
681  $objWriter->writeAttribute('w', $minorGridlines->getLineStyleArrowParameters('head', 'w'));
682  $objWriter->writeAttribute('len', $minorGridlines->getLineStyleArrowParameters('head', 'len'));
683  $objWriter->endElement();
684  }
685 
686  if ($minorGridlines->getLineStyleProperty(['arrow', 'end', 'type']) !== null) {
687  $objWriter->startElement('a:tailEnd');
688  $objWriter->writeAttribute('type', $minorGridlines->getLineStyleProperty(['arrow', 'end', 'type']));
689  $objWriter->writeAttribute('w', $minorGridlines->getLineStyleArrowParameters('end', 'w'));
690  $objWriter->writeAttribute('len', $minorGridlines->getLineStyleArrowParameters('end', 'len'));
691  $objWriter->endElement();
692  }
693  $objWriter->endElement(); //end ln
694  }
695 
696  $objWriter->startElement('a:effectLst');
697 
698  if ($minorGridlines->getGlowSize() !== null) {
699  $objWriter->startElement('a:glow');
700  $objWriter->writeAttribute('rad', $minorGridlines->getGlowSize());
701  $objWriter->startElement("a:{$minorGridlines->getGlowColor('type')}");
702  $objWriter->writeAttribute('val', $minorGridlines->getGlowColor('value'));
703  $objWriter->startElement('a:alpha');
704  $objWriter->writeAttribute('val', $minorGridlines->getGlowColor('alpha'));
705  $objWriter->endElement(); //end alpha
706  $objWriter->endElement(); //end schemeClr
707  $objWriter->endElement(); //end glow
708  }
709 
710  if ($minorGridlines->getShadowProperty('presets') !== null) {
711  $objWriter->startElement("a:{$minorGridlines->getShadowProperty('effect')}");
712  if ($minorGridlines->getShadowProperty('blur') !== null) {
713  $objWriter->writeAttribute('blurRad', $minorGridlines->getShadowProperty('blur'));
714  }
715  if ($minorGridlines->getShadowProperty('distance') !== null) {
716  $objWriter->writeAttribute('dist', $minorGridlines->getShadowProperty('distance'));
717  }
718  if ($minorGridlines->getShadowProperty('direction') !== null) {
719  $objWriter->writeAttribute('dir', $minorGridlines->getShadowProperty('direction'));
720  }
721  if ($minorGridlines->getShadowProperty('algn') !== null) {
722  $objWriter->writeAttribute('algn', $minorGridlines->getShadowProperty('algn'));
723  }
724  if ($minorGridlines->getShadowProperty(['size', 'sx']) !== null) {
725  $objWriter->writeAttribute('sx', $minorGridlines->getShadowProperty(['size', 'sx']));
726  }
727  if ($minorGridlines->getShadowProperty(['size', 'sy']) !== null) {
728  $objWriter->writeAttribute('sy', $minorGridlines->getShadowProperty(['size', 'sy']));
729  }
730  if ($minorGridlines->getShadowProperty(['size', 'kx']) !== null) {
731  $objWriter->writeAttribute('kx', $minorGridlines->getShadowProperty(['size', 'kx']));
732  }
733  if ($minorGridlines->getShadowProperty('rotWithShape') !== null) {
734  $objWriter->writeAttribute('rotWithShape', $minorGridlines->getShadowProperty('rotWithShape'));
735  }
736  $objWriter->startElement("a:{$minorGridlines->getShadowProperty(['color', 'type'])}");
737  $objWriter->writeAttribute('val', $minorGridlines->getShadowProperty(['color', 'value']));
738  $objWriter->startElement('a:alpha');
739  $objWriter->writeAttribute('val', $minorGridlines->getShadowProperty(['color', 'alpha']));
740  $objWriter->endElement(); //end alpha
741  $objWriter->endElement(); //end color:type
742  $objWriter->endElement(); //end shadow
743  }
744 
745  if ($minorGridlines->getSoftEdgesSize() !== null) {
746  $objWriter->startElement('a:softEdge');
747  $objWriter->writeAttribute('rad', $minorGridlines->getSoftEdgesSize());
748  $objWriter->endElement(); //end softEdge
749  }
750 
751  $objWriter->endElement(); //end effectLst
752  $objWriter->endElement(); //end spPr
753  $objWriter->endElement(); //end minorGridLines
754  }
755 
756  if ($yAxisLabel !== null) {
757  $objWriter->startElement('c:title');
758  $objWriter->startElement('c:tx');
759  $objWriter->startElement('c:rich');
760 
761  $objWriter->startElement('a:bodyPr');
762  $objWriter->endElement();
763 
764  $objWriter->startElement('a:lstStyle');
765  $objWriter->endElement();
766 
767  $objWriter->startElement('a:p');
768  $objWriter->startElement('a:r');
769 
770  $caption = $yAxisLabel->getCaption();
771  if (is_array($caption)) {
772  $caption = $caption[0];
773  }
774 
775  $objWriter->startElement('a:t');
776  $objWriter->writeRawData(StringHelper::controlCharacterPHP2OOXML($caption));
777  $objWriter->endElement();
778 
779  $objWriter->endElement();
780  $objWriter->endElement();
781  $objWriter->endElement();
782  $objWriter->endElement();
783 
784  if ($groupType !== DataSeries::TYPE_BUBBLECHART) {
785  $layout = $yAxisLabel->getLayout();
786  $this->writeLayout($objWriter, $layout);
787  }
788 
789  $objWriter->startElement('c:overlay');
790  $objWriter->writeAttribute('val', 0);
791  $objWriter->endElement();
792 
793  $objWriter->endElement();
794  }
795 
796  $objWriter->startElement('c:numFmt');
797  $objWriter->writeAttribute('formatCode', $xAxis->getAxisNumberFormat());
798  $objWriter->writeAttribute('sourceLinked', $xAxis->getAxisNumberSourceLinked());
799  $objWriter->endElement();
800 
801  $objWriter->startElement('c:majorTickMark');
802  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('major_tick_mark'));
803  $objWriter->endElement();
804 
805  $objWriter->startElement('c:minorTickMark');
806  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('minor_tick_mark'));
807  $objWriter->endElement();
808 
809  $objWriter->startElement('c:tickLblPos');
810  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('axis_labels'));
811  $objWriter->endElement();
812 
813  $objWriter->startElement('c:spPr');
814 
815  if ($xAxis->getFillProperty('value') !== null) {
816  $objWriter->startElement('a:solidFill');
817  $objWriter->startElement('a:' . $xAxis->getFillProperty('type'));
818  $objWriter->writeAttribute('val', $xAxis->getFillProperty('value'));
819  $objWriter->startElement('a:alpha');
820  $objWriter->writeAttribute('val', $xAxis->getFillProperty('alpha'));
821  $objWriter->endElement();
822  $objWriter->endElement();
823  $objWriter->endElement();
824  }
825 
826  $objWriter->startElement('a:ln');
827 
828  $objWriter->writeAttribute('w', $xAxis->getLineStyleProperty('width'));
829  $objWriter->writeAttribute('cap', $xAxis->getLineStyleProperty('cap'));
830  $objWriter->writeAttribute('cmpd', $xAxis->getLineStyleProperty('compound'));
831 
832  if ($xAxis->getLineProperty('value') !== null) {
833  $objWriter->startElement('a:solidFill');
834  $objWriter->startElement('a:' . $xAxis->getLineProperty('type'));
835  $objWriter->writeAttribute('val', $xAxis->getLineProperty('value'));
836  $objWriter->startElement('a:alpha');
837  $objWriter->writeAttribute('val', $xAxis->getLineProperty('alpha'));
838  $objWriter->endElement();
839  $objWriter->endElement();
840  $objWriter->endElement();
841  }
842 
843  $objWriter->startElement('a:prstDash');
844  $objWriter->writeAttribute('val', $xAxis->getLineStyleProperty('dash'));
845  $objWriter->endElement();
846 
847  if ($xAxis->getLineStyleProperty('join') == 'miter') {
848  $objWriter->startElement('a:miter');
849  $objWriter->writeAttribute('lim', '800000');
850  $objWriter->endElement();
851  } else {
852  $objWriter->startElement('a:bevel');
853  $objWriter->endElement();
854  }
855 
856  if ($xAxis->getLineStyleProperty(['arrow', 'head', 'type']) !== null) {
857  $objWriter->startElement('a:headEnd');
858  $objWriter->writeAttribute('type', $xAxis->getLineStyleProperty(['arrow', 'head', 'type']));
859  $objWriter->writeAttribute('w', $xAxis->getLineStyleArrowWidth('head'));
860  $objWriter->writeAttribute('len', $xAxis->getLineStyleArrowLength('head'));
861  $objWriter->endElement();
862  }
863 
864  if ($xAxis->getLineStyleProperty(['arrow', 'end', 'type']) !== null) {
865  $objWriter->startElement('a:tailEnd');
866  $objWriter->writeAttribute('type', $xAxis->getLineStyleProperty(['arrow', 'end', 'type']));
867  $objWriter->writeAttribute('w', $xAxis->getLineStyleArrowWidth('end'));
868  $objWriter->writeAttribute('len', $xAxis->getLineStyleArrowLength('end'));
869  $objWriter->endElement();
870  }
871 
872  $objWriter->endElement();
873 
874  $objWriter->startElement('a:effectLst');
875 
876  if ($xAxis->getGlowProperty('size') !== null) {
877  $objWriter->startElement('a:glow');
878  $objWriter->writeAttribute('rad', $xAxis->getGlowProperty('size'));
879  $objWriter->startElement("a:{$xAxis->getGlowProperty(['color', 'type'])}");
880  $objWriter->writeAttribute('val', $xAxis->getGlowProperty(['color', 'value']));
881  $objWriter->startElement('a:alpha');
882  $objWriter->writeAttribute('val', $xAxis->getGlowProperty(['color', 'alpha']));
883  $objWriter->endElement();
884  $objWriter->endElement();
885  $objWriter->endElement();
886  }
887 
888  if ($xAxis->getShadowProperty('presets') !== null) {
889  $objWriter->startElement("a:{$xAxis->getShadowProperty('effect')}");
890 
891  if ($xAxis->getShadowProperty('blur') !== null) {
892  $objWriter->writeAttribute('blurRad', $xAxis->getShadowProperty('blur'));
893  }
894  if ($xAxis->getShadowProperty('distance') !== null) {
895  $objWriter->writeAttribute('dist', $xAxis->getShadowProperty('distance'));
896  }
897  if ($xAxis->getShadowProperty('direction') !== null) {
898  $objWriter->writeAttribute('dir', $xAxis->getShadowProperty('direction'));
899  }
900  if ($xAxis->getShadowProperty('algn') !== null) {
901  $objWriter->writeAttribute('algn', $xAxis->getShadowProperty('algn'));
902  }
903  if ($xAxis->getShadowProperty(['size', 'sx']) !== null) {
904  $objWriter->writeAttribute('sx', $xAxis->getShadowProperty(['size', 'sx']));
905  }
906  if ($xAxis->getShadowProperty(['size', 'sy']) !== null) {
907  $objWriter->writeAttribute('sy', $xAxis->getShadowProperty(['size', 'sy']));
908  }
909  if ($xAxis->getShadowProperty(['size', 'kx']) !== null) {
910  $objWriter->writeAttribute('kx', $xAxis->getShadowProperty(['size', 'kx']));
911  }
912  if ($xAxis->getShadowProperty('rotWithShape') !== null) {
913  $objWriter->writeAttribute('rotWithShape', $xAxis->getShadowProperty('rotWithShape'));
914  }
915 
916  $objWriter->startElement("a:{$xAxis->getShadowProperty(['color', 'type'])}");
917  $objWriter->writeAttribute('val', $xAxis->getShadowProperty(['color', 'value']));
918  $objWriter->startElement('a:alpha');
919  $objWriter->writeAttribute('val', $xAxis->getShadowProperty(['color', 'alpha']));
920  $objWriter->endElement();
921  $objWriter->endElement();
922 
923  $objWriter->endElement();
924  }
925 
926  if ($xAxis->getSoftEdgesSize() !== null) {
927  $objWriter->startElement('a:softEdge');
928  $objWriter->writeAttribute('rad', $xAxis->getSoftEdgesSize());
929  $objWriter->endElement();
930  }
931 
932  $objWriter->endElement(); //effectList
933  $objWriter->endElement(); //end spPr
934 
935  if ($id1 > 0) {
936  $objWriter->startElement('c:crossAx');
937  $objWriter->writeAttribute('val', $id2);
938  $objWriter->endElement();
939 
940  if ($xAxis->getAxisOptionsProperty('horizontal_crosses_value') !== null) {
941  $objWriter->startElement('c:crossesAt');
942  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('horizontal_crosses_value'));
943  $objWriter->endElement();
944  } else {
945  $objWriter->startElement('c:crosses');
946  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('horizontal_crosses'));
947  $objWriter->endElement();
948  }
949 
950  $objWriter->startElement('c:crossBetween');
951  $objWriter->writeAttribute('val', 'midCat');
952  $objWriter->endElement();
953 
954  if ($xAxis->getAxisOptionsProperty('major_unit') !== null) {
955  $objWriter->startElement('c:majorUnit');
956  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('major_unit'));
957  $objWriter->endElement();
958  }
959 
960  if ($xAxis->getAxisOptionsProperty('minor_unit') !== null) {
961  $objWriter->startElement('c:minorUnit');
962  $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('minor_unit'));
963  $objWriter->endElement();
964  }
965  }
966 
967  if ($isMultiLevelSeries) {
968  if ($groupType !== DataSeries::TYPE_BUBBLECHART) {
969  $objWriter->startElement('c:noMultiLvlLbl');
970  $objWriter->writeAttribute('val', 0);
971  $objWriter->endElement();
972  }
973  }
974 
975  $objWriter->endElement();
976  }
977 
985  private static function getChartType($plotArea)
986  {
987  $groupCount = $plotArea->getPlotGroupCount();
988 
989  if ($groupCount == 1) {
990  $chartType = [$plotArea->getPlotGroupByIndex(0)->getPlotType()];
991  } else {
992  $chartTypes = [];
993  for ($i = 0; $i < $groupCount; ++$i) {
994  $chartTypes[] = $plotArea->getPlotGroupByIndex($i)->getPlotType();
995  }
996  $chartType = array_unique($chartTypes);
997  if (count($chartTypes) == 0) {
998  throw new WriterException('Chart is not yet implemented');
999  }
1000  }
1001 
1002  return $chartType;
1003  }
1004 
1014  private function writePlotSeriesValuesElement($objWriter, $val = 3, $fillColor = 'FF9900')
1015  {
1016  $objWriter->startElement('c:dPt');
1017  $objWriter->startElement('c:idx');
1018  $objWriter->writeAttribute('val', $val);
1019  $objWriter->endElement();
1020 
1021  $objWriter->startElement('c:bubble3D');
1022  $objWriter->writeAttribute('val', 0);
1023  $objWriter->endElement();
1024 
1025  $objWriter->startElement('c:spPr');
1026  $objWriter->startElement('a:solidFill');
1027  $objWriter->startElement('a:srgbClr');
1028  $objWriter->writeAttribute('val', $fillColor);
1029  $objWriter->endElement();
1030  $objWriter->endElement();
1031  $objWriter->endElement();
1032  $objWriter->endElement();
1033 
1034  return $objWriter;
1035  }
1036 
1047  private function writePlotGroup($plotGroup, $groupType, $objWriter, &$catIsMultiLevelSeries, &$valIsMultiLevelSeries, &$plotGroupingType): void
1048  {
1049  if ($plotGroup === null) {
1050  return;
1051  }
1052 
1053  if (($groupType == DataSeries::TYPE_BARCHART) || ($groupType == DataSeries::TYPE_BARCHART_3D)) {
1054  $objWriter->startElement('c:barDir');
1055  $objWriter->writeAttribute('val', $plotGroup->getPlotDirection());
1056  $objWriter->endElement();
1057  }
1058 
1059  if ($plotGroup->getPlotGrouping() !== null) {
1060  $plotGroupingType = $plotGroup->getPlotGrouping();
1061  $objWriter->startElement('c:grouping');
1062  $objWriter->writeAttribute('val', $plotGroupingType);
1063  $objWriter->endElement();
1064  }
1065 
1066  // Get these details before the loop, because we can use the count to check for varyColors
1067  $plotSeriesOrder = $plotGroup->getPlotOrder();
1068  $plotSeriesCount = count($plotSeriesOrder);
1069 
1070  if (($groupType !== DataSeries::TYPE_RADARCHART) && ($groupType !== DataSeries::TYPE_STOCKCHART)) {
1071  if ($groupType !== DataSeries::TYPE_LINECHART) {
1072  if (($groupType == DataSeries::TYPE_PIECHART) || ($groupType == DataSeries::TYPE_PIECHART_3D) || ($groupType == DataSeries::TYPE_DONUTCHART) || ($plotSeriesCount > 1)) {
1073  $objWriter->startElement('c:varyColors');
1074  $objWriter->writeAttribute('val', 1);
1075  $objWriter->endElement();
1076  } else {
1077  $objWriter->startElement('c:varyColors');
1078  $objWriter->writeAttribute('val', 0);
1079  $objWriter->endElement();
1080  }
1081  }
1082  }
1083 
1084  $plotSeriesIdx = 0;
1085  foreach ($plotSeriesOrder as $plotSeriesIdx => $plotSeriesRef) {
1086  $objWriter->startElement('c:ser');
1087 
1088  $plotLabel = $plotGroup->getPlotLabelByIndex($plotSeriesIdx);
1089  if ($plotLabel) {
1090  $fillColor = $plotLabel->getFillColor();
1091  if ($fillColor !== null && !is_array($fillColor)) {
1092  $objWriter->startElement('c:spPr');
1093  $objWriter->startElement('a:solidFill');
1094  $objWriter->startElement('a:srgbClr');
1095  $objWriter->writeAttribute('val', $fillColor);
1096  $objWriter->endElement();
1097  $objWriter->endElement();
1098  $objWriter->endElement();
1099  }
1100  }
1101 
1102  $objWriter->startElement('c:idx');
1103  $objWriter->writeAttribute('val', $this->seriesIndex + $plotSeriesIdx);
1104  $objWriter->endElement();
1105 
1106  $objWriter->startElement('c:order');
1107  $objWriter->writeAttribute('val', $this->seriesIndex + $plotSeriesRef);
1108  $objWriter->endElement();
1109 
1110  // Values
1111  $plotSeriesValues = $plotGroup->getPlotValuesByIndex($plotSeriesRef);
1112 
1113  if (($groupType == DataSeries::TYPE_PIECHART) || ($groupType == DataSeries::TYPE_PIECHART_3D) || ($groupType == DataSeries::TYPE_DONUTCHART)) {
1114  $fillColorValues = $plotSeriesValues->getFillColor();
1115  if ($fillColorValues !== null && is_array($fillColorValues)) {
1116  foreach ($plotSeriesValues->getDataValues() as $dataKey => $dataValue) {
1117  $this->writePlotSeriesValuesElement($objWriter, $dataKey, ($fillColorValues[$dataKey] ?? 'FF9900'));
1118  }
1119  } else {
1120  $this->writePlotSeriesValuesElement($objWriter);
1121  }
1122  }
1123 
1124  // Labels
1125  $plotSeriesLabel = $plotGroup->getPlotLabelByIndex($plotSeriesRef);
1126  if ($plotSeriesLabel && ($plotSeriesLabel->getPointCount() > 0)) {
1127  $objWriter->startElement('c:tx');
1128  $objWriter->startElement('c:strRef');
1129  $this->writePlotSeriesLabel($plotSeriesLabel, $objWriter);
1130  $objWriter->endElement();
1131  $objWriter->endElement();
1132  }
1133 
1134  // Formatting for the points
1135  if (($groupType == DataSeries::TYPE_LINECHART) || ($groupType == DataSeries::TYPE_STOCKCHART)) {
1136  $plotLineWidth = 12700;
1137  if ($plotSeriesValues) {
1138  $plotLineWidth = $plotSeriesValues->getLineWidth();
1139  }
1140 
1141  $objWriter->startElement('c:spPr');
1142  $objWriter->startElement('a:ln');
1143  $objWriter->writeAttribute('w', $plotLineWidth);
1144  if ($groupType == DataSeries::TYPE_STOCKCHART) {
1145  $objWriter->startElement('a:noFill');
1146  $objWriter->endElement();
1147  }
1148  $objWriter->endElement();
1149  $objWriter->endElement();
1150  }
1151 
1152  if ($plotSeriesValues) {
1153  $plotSeriesMarker = $plotSeriesValues->getPointMarker();
1154  if ($plotSeriesMarker) {
1155  $objWriter->startElement('c:marker');
1156  $objWriter->startElement('c:symbol');
1157  $objWriter->writeAttribute('val', $plotSeriesMarker);
1158  $objWriter->endElement();
1159 
1160  if ($plotSeriesMarker !== 'none') {
1161  $objWriter->startElement('c:size');
1162  $objWriter->writeAttribute('val', 3);
1163  $objWriter->endElement();
1164  }
1165 
1166  $objWriter->endElement();
1167  }
1168  }
1169 
1170  if (($groupType === DataSeries::TYPE_BARCHART) || ($groupType === DataSeries::TYPE_BARCHART_3D) || ($groupType === DataSeries::TYPE_BUBBLECHART)) {
1171  $objWriter->startElement('c:invertIfNegative');
1172  $objWriter->writeAttribute('val', 0);
1173  $objWriter->endElement();
1174  }
1175 
1176  // Category Labels
1177  $plotSeriesCategory = $plotGroup->getPlotCategoryByIndex($plotSeriesRef);
1178  if ($plotSeriesCategory && ($plotSeriesCategory->getPointCount() > 0)) {
1179  $catIsMultiLevelSeries = $catIsMultiLevelSeries || $plotSeriesCategory->isMultiLevelSeries();
1180 
1181  if (($groupType == DataSeries::TYPE_PIECHART) || ($groupType == DataSeries::TYPE_PIECHART_3D) || ($groupType == DataSeries::TYPE_DONUTCHART)) {
1182  if ($plotGroup->getPlotStyle() !== null) {
1183  $plotStyle = $plotGroup->getPlotStyle();
1184  if ($plotStyle) {
1185  $objWriter->startElement('c:explosion');
1186  $objWriter->writeAttribute('val', 25);
1187  $objWriter->endElement();
1188  }
1189  }
1190  }
1191 
1192  if (($groupType === DataSeries::TYPE_BUBBLECHART) || ($groupType === DataSeries::TYPE_SCATTERCHART)) {
1193  $objWriter->startElement('c:xVal');
1194  } else {
1195  $objWriter->startElement('c:cat');
1196  }
1197 
1198  $this->writePlotSeriesValues($plotSeriesCategory, $objWriter, $groupType, 'str');
1199  $objWriter->endElement();
1200  }
1201 
1202  // Values
1203  if ($plotSeriesValues) {
1204  $valIsMultiLevelSeries = $valIsMultiLevelSeries || $plotSeriesValues->isMultiLevelSeries();
1205 
1206  if (($groupType === DataSeries::TYPE_BUBBLECHART) || ($groupType === DataSeries::TYPE_SCATTERCHART)) {
1207  $objWriter->startElement('c:yVal');
1208  } else {
1209  $objWriter->startElement('c:val');
1210  }
1211 
1212  $this->writePlotSeriesValues($plotSeriesValues, $objWriter, $groupType, 'num');
1213  $objWriter->endElement();
1214  }
1215 
1216  if ($groupType === DataSeries::TYPE_BUBBLECHART) {
1217  $this->writeBubbles($plotSeriesValues, $objWriter);
1218  }
1219 
1220  $objWriter->endElement();
1221  }
1222 
1223  $this->seriesIndex += $plotSeriesIdx + 1;
1224  }
1225 
1232  private function writePlotSeriesLabel($plotSeriesLabel, $objWriter): void
1233  {
1234  if ($plotSeriesLabel === null) {
1235  return;
1236  }
1237 
1238  $objWriter->startElement('c:f');
1239  $objWriter->writeRawData($plotSeriesLabel->getDataSource());
1240  $objWriter->endElement();
1241 
1242  $objWriter->startElement('c:strCache');
1243  $objWriter->startElement('c:ptCount');
1244  $objWriter->writeAttribute('val', $plotSeriesLabel->getPointCount());
1245  $objWriter->endElement();
1246 
1247  foreach ($plotSeriesLabel->getDataValues() as $plotLabelKey => $plotLabelValue) {
1248  $objWriter->startElement('c:pt');
1249  $objWriter->writeAttribute('idx', $plotLabelKey);
1250 
1251  $objWriter->startElement('c:v');
1252  $objWriter->writeRawData($plotLabelValue);
1253  $objWriter->endElement();
1254  $objWriter->endElement();
1255  }
1256  $objWriter->endElement();
1257  }
1258 
1267  private function writePlotSeriesValues($plotSeriesValues, XMLWriter $objWriter, $groupType, $dataType = 'str'): void
1268  {
1269  if ($plotSeriesValues === null) {
1270  return;
1271  }
1272 
1273  if ($plotSeriesValues->isMultiLevelSeries()) {
1274  $levelCount = $plotSeriesValues->multiLevelCount();
1275 
1276  $objWriter->startElement('c:multiLvlStrRef');
1277 
1278  $objWriter->startElement('c:f');
1279  $objWriter->writeRawData($plotSeriesValues->getDataSource());
1280  $objWriter->endElement();
1281 
1282  $objWriter->startElement('c:multiLvlStrCache');
1283 
1284  $objWriter->startElement('c:ptCount');
1285  $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount());
1286  $objWriter->endElement();
1287 
1288  for ($level = 0; $level < $levelCount; ++$level) {
1289  $objWriter->startElement('c:lvl');
1290 
1291  foreach ($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) {
1292  if (isset($plotSeriesValue[$level])) {
1293  $objWriter->startElement('c:pt');
1294  $objWriter->writeAttribute('idx', $plotSeriesKey);
1295 
1296  $objWriter->startElement('c:v');
1297  $objWriter->writeRawData($plotSeriesValue[$level]);
1298  $objWriter->endElement();
1299  $objWriter->endElement();
1300  }
1301  }
1302 
1303  $objWriter->endElement();
1304  }
1305 
1306  $objWriter->endElement();
1307 
1308  $objWriter->endElement();
1309  } else {
1310  $objWriter->startElement('c:' . $dataType . 'Ref');
1311 
1312  $objWriter->startElement('c:f');
1313  $objWriter->writeRawData($plotSeriesValues->getDataSource());
1314  $objWriter->endElement();
1315 
1316  $objWriter->startElement('c:' . $dataType . 'Cache');
1317 
1318  if (($groupType != DataSeries::TYPE_PIECHART) && ($groupType != DataSeries::TYPE_PIECHART_3D) && ($groupType != DataSeries::TYPE_DONUTCHART)) {
1319  if (($plotSeriesValues->getFormatCode() !== null) && ($plotSeriesValues->getFormatCode() !== '')) {
1320  $objWriter->startElement('c:formatCode');
1321  $objWriter->writeRawData($plotSeriesValues->getFormatCode());
1322  $objWriter->endElement();
1323  }
1324  }
1325 
1326  $objWriter->startElement('c:ptCount');
1327  $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount());
1328  $objWriter->endElement();
1329 
1330  $dataValues = $plotSeriesValues->getDataValues();
1331  if (!empty($dataValues)) {
1332  if (is_array($dataValues)) {
1333  foreach ($dataValues as $plotSeriesKey => $plotSeriesValue) {
1334  $objWriter->startElement('c:pt');
1335  $objWriter->writeAttribute('idx', $plotSeriesKey);
1336 
1337  $objWriter->startElement('c:v');
1338  $objWriter->writeRawData($plotSeriesValue);
1339  $objWriter->endElement();
1340  $objWriter->endElement();
1341  }
1342  }
1343  }
1344 
1345  $objWriter->endElement();
1346 
1347  $objWriter->endElement();
1348  }
1349  }
1350 
1357  private function writeBubbles($plotSeriesValues, $objWriter): void
1358  {
1359  if ($plotSeriesValues === null) {
1360  return;
1361  }
1362 
1363  $objWriter->startElement('c:bubbleSize');
1364  $objWriter->startElement('c:numLit');
1365 
1366  $objWriter->startElement('c:formatCode');
1367  $objWriter->writeRawData('General');
1368  $objWriter->endElement();
1369 
1370  $objWriter->startElement('c:ptCount');
1371  $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount());
1372  $objWriter->endElement();
1373 
1374  $dataValues = $plotSeriesValues->getDataValues();
1375  if (!empty($dataValues)) {
1376  if (is_array($dataValues)) {
1377  foreach ($dataValues as $plotSeriesKey => $plotSeriesValue) {
1378  $objWriter->startElement('c:pt');
1379  $objWriter->writeAttribute('idx', $plotSeriesKey);
1380  $objWriter->startElement('c:v');
1381  $objWriter->writeRawData(1);
1382  $objWriter->endElement();
1383  $objWriter->endElement();
1384  }
1385  }
1386  }
1387 
1388  $objWriter->endElement();
1389  $objWriter->endElement();
1390 
1391  $objWriter->startElement('c:bubble3D');
1392  $objWriter->writeAttribute('val', 0);
1393  $objWriter->endElement();
1394  }
1395 
1402  private function writeLayout(XMLWriter $objWriter, ?Layout $layout = null): void
1403  {
1404  $objWriter->startElement('c:layout');
1405 
1406  if ($layout !== null) {
1407  $objWriter->startElement('c:manualLayout');
1408 
1409  $layoutTarget = $layout->getLayoutTarget();
1410  if ($layoutTarget !== null) {
1411  $objWriter->startElement('c:layoutTarget');
1412  $objWriter->writeAttribute('val', $layoutTarget);
1413  $objWriter->endElement();
1414  }
1415 
1416  $xMode = $layout->getXMode();
1417  if ($xMode !== null) {
1418  $objWriter->startElement('c:xMode');
1419  $objWriter->writeAttribute('val', $xMode);
1420  $objWriter->endElement();
1421  }
1422 
1423  $yMode = $layout->getYMode();
1424  if ($yMode !== null) {
1425  $objWriter->startElement('c:yMode');
1426  $objWriter->writeAttribute('val', $yMode);
1427  $objWriter->endElement();
1428  }
1429 
1430  $x = $layout->getXPosition();
1431  if ($x !== null) {
1432  $objWriter->startElement('c:x');
1433  $objWriter->writeAttribute('val', $x);
1434  $objWriter->endElement();
1435  }
1436 
1437  $y = $layout->getYPosition();
1438  if ($y !== null) {
1439  $objWriter->startElement('c:y');
1440  $objWriter->writeAttribute('val', $y);
1441  $objWriter->endElement();
1442  }
1443 
1444  $w = $layout->getWidth();
1445  if ($w !== null) {
1446  $objWriter->startElement('c:w');
1447  $objWriter->writeAttribute('val', $w);
1448  $objWriter->endElement();
1449  }
1450 
1451  $h = $layout->getHeight();
1452  if ($h !== null) {
1453  $objWriter->startElement('c:h');
1454  $objWriter->writeAttribute('val', $h);
1455  $objWriter->endElement();
1456  }
1457 
1458  $objWriter->endElement();
1459  }
1460 
1461  $objWriter->endElement();
1462  }
1463 
1469  private function writeAlternateContent($objWriter): void
1470  {
1471  $objWriter->startElement('mc:AlternateContent');
1472  $objWriter->writeAttribute('xmlns:mc', 'http://schemas.openxmlformats.org/markup-compatibility/2006');
1473 
1474  $objWriter->startElement('mc:Choice');
1475  $objWriter->writeAttribute('xmlns:c14', 'http://schemas.microsoft.com/office/drawing/2007/8/2/chart');
1476  $objWriter->writeAttribute('Requires', 'c14');
1477 
1478  $objWriter->startElement('c14:style');
1479  $objWriter->writeAttribute('val', '102');
1480  $objWriter->endElement();
1481  $objWriter->endElement();
1482 
1483  $objWriter->startElement('mc:Fallback');
1484  $objWriter->startElement('c:style');
1485  $objWriter->writeAttribute('val', '2');
1486  $objWriter->endElement();
1487  $objWriter->endElement();
1488 
1489  $objWriter->endElement();
1490  }
1491 
1497  private function writePrintSettings($objWriter): void
1498  {
1499  $objWriter->startElement('c:printSettings');
1500 
1501  $objWriter->startElement('c:headerFooter');
1502  $objWriter->endElement();
1503 
1504  $objWriter->startElement('c:pageMargins');
1505  $objWriter->writeAttribute('footer', 0.3);
1506  $objWriter->writeAttribute('header', 0.3);
1507  $objWriter->writeAttribute('r', 0.7);
1508  $objWriter->writeAttribute('l', 0.7);
1509  $objWriter->writeAttribute('t', 0.75);
1510  $objWriter->writeAttribute('b', 0.75);
1511  $objWriter->endElement();
1512 
1513  $objWriter->startElement('c:pageSetup');
1514  $objWriter->writeAttribute('orientation', 'portrait');
1515  $objWriter->endElement();
1516 
1517  $objWriter->endElement();
1518  }
1519 }
PhpOffice\PhpSpreadsheet\Chart\Axis\getLineStyleProperty
getLineStyleProperty($elements)
Get Line Style Property.
Definition: Axis.php:297
PhpOffice\PhpSpreadsheet\Shared\StringHelper\controlCharacterPHP2OOXML
static controlCharacterPHP2OOXML($value)
Convert from PHP control character to OpenXML escaped control character.
Definition: StringHelper.php:323
PhpOffice\PhpSpreadsheet\Shared\XMLWriter\writeRawData
writeRawData($text)
Wrapper method for writeRaw.
Definition: XMLWriter.php:84
PhpOffice\PhpSpreadsheet\Chart\GridLines\getShadowProperty
getShadowProperty($elements)
Get Shadow Property.
Definition: GridLines.php:427
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writePlotArea
writePlotArea(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, PlotArea $plotArea, ?Title $xAxisLabel=null, ?Title $yAxisLabel=null, ?Axis $xAxis=null, ?Axis $yAxis=null, ?GridLines $majorGridlines=null, ?GridLines $minorGridlines=null)
Write Chart Plot Area.
Definition: Chart.php:205
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\getChartType
static getChartType($plotArea)
Get the data series type(s) for a chart plot series.
Definition: Chart.php:985
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writePlotSeriesLabel
writePlotSeriesLabel($plotSeriesLabel, $objWriter)
Write Plot Series Label.
Definition: Chart.php:1232
$h
$h
Definition: example_009.php:101
$legend
$legend
Definition: example_057.php:131
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writeBubbles
writeBubbles($plotSeriesValues, $objWriter)
Write Bubble Chart Details.
Definition: Chart.php:1357
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writePrintSettings
writePrintSettings($objWriter)
Write Printer Settings.
Definition: Chart.php:1497
PhpOffice\PhpSpreadsheet\Chart\PlotArea\getPlotGroupByIndex
getPlotGroupByIndex($index)
Get Plot Series by Index.
Definition: PlotArea.php:84
PhpOffice\PhpSpreadsheet\Chart\Axis\getFillProperty
getFillProperty($property)
Get Fill Property.
Definition: Axis.php:247
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writeTitle
writeTitle(XMLWriter $objWriter, ?Title $title=null)
Write Chart Title.
Definition: Chart.php:110
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writePlotSeriesValuesElement
writePlotSeriesValuesElement($objWriter, $val=3, $fillColor='FF9900')
Method writing plot series values.
Definition: Chart.php:1014
PhpOffice\PhpSpreadsheet\Writer\BaseWriter\getDiskCachingDirectory
getDiskCachingDirectory()
Get disk caching directory.
Definition: BaseWriter.php:92
PhpOffice\PhpSpreadsheet\Chart\Axis\getAxisNumberFormat
getAxisNumberFormat()
Get Axis Number Format Data Type.
Definition: Axis.php:150
PhpOffice\PhpSpreadsheet\Chart\GridLines\getLineStyleProperty
getLineStyleProperty($elements)
Get Line Style Property.
Definition: GridLines.php:184
PhpOffice\PhpSpreadsheet\Chart\Axis\getGlowProperty
getGlowProperty($property)
Get Glow Property.
Definition: Axis.php:496
$w
$w
Definition: example_009.php:100
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writeLegend
writeLegend(XMLWriter $objWriter, ?Legend $legend=null)
Write Chart Legend.
Definition: Chart.php:153
PhpOffice\PhpSpreadsheet\Chart\GridLines\getLineColorProperty
getLineColorProperty($parameter)
Get Line Color Property.
Definition: GridLines.php:172
PhpOffice\PhpSpreadsheet\Chart\GridLines\getSoftEdgesSize
getSoftEdgesSize()
Get Soft Edges Size.
Definition: GridLines.php:450
PhpOffice\PhpSpreadsheet\Chart\Axis\getAxisNumberSourceLinked
getAxisNumberSourceLinked()
Get Axis Number Source Linked.
Definition: Axis.php:160
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writePlotGroup
writePlotGroup($plotGroup, $groupType, $objWriter, &$catIsMultiLevelSeries, &$valIsMultiLevelSeries, &$plotGroupingType)
Write Plot Group (series of related plots).
Definition: Chart.php:1047
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writeAlternateContent
writeAlternateContent($objWriter)
Write Alternate Content block.
Definition: Chart.php:1469
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writeValueAxis
writeValueAxis($objWriter, $yAxisLabel, $groupType, $id1, $id2, $isMultiLevelSeries, Axis $xAxis, GridLines $majorGridlines, GridLines $minorGridlines)
Write Value Axis.
Definition: Chart.php:505
PhpOffice\PhpSpreadsheet\Chart\GridLines\getLineStyleArrowParameters
getLineStyleArrowParameters($arrow_selector, $property_selector)
Get Line Style Arrow Parameters.
Definition: GridLines.php:273
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writeChart
writeChart(\PhpOffice\PhpSpreadsheet\Chart\Chart $pChart, $calculateCellValues=true)
Write charts to XML format.
Definition: Chart.php:33
$y
$y
Definition: example_007.php:83
PhpOffice\PhpSpreadsheet\Chart\Axis
Created by PhpStorm.
Definition: Axis.php:11
PhpOffice\PhpSpreadsheet\Chart\Axis\getLineProperty
getLineProperty($property)
Get Line Property.
Definition: Axis.php:259
PhpOffice\PhpSpreadsheet\Chart\Axis\getLineStyleArrowLength
getLineStyleArrowLength($arrow)
Get Line Style Arrow Excel Length.
Definition: Axis.php:321
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writeDataLabels
writeDataLabels(XMLWriter $objWriter, ?Layout $chartLayout=null)
Write Data Labels.
Definition: Chart.php:336
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writeCategoryAxis
writeCategoryAxis($objWriter, $xAxisLabel, $id1, $id2, $isMultiLevelSeries, Axis $yAxis)
Write Category Axis.
Definition: Chart.php:387
PhpOffice\PhpSpreadsheet\Chart\Axis\getLineStyleArrowWidth
getLineStyleArrowWidth($arrow)
Get Line Style Arrow Excel Width.
Definition: Axis.php:309
PhpOffice\PhpSpreadsheet\Chart\Axis\getShadowProperty
getShadowProperty($elements)
Get Shadow Property.
Definition: Axis.php:466
$i
$i
Definition: disco.tpl.php:19
PhpOffice\PhpSpreadsheet\Writer\BaseWriter\getUseDiskCaching
getUseDiskCaching()
Get use disk caching where possible?
Definition: BaseWriter.php:72
PhpOffice\PhpSpreadsheet\Chart\Axis\getSoftEdgesSize
getSoftEdgesSize()
Get Soft Edges Size.
Definition: Axis.php:550
PhpOffice\PhpSpreadsheet\Chart\GridLines\getGlowColor
getGlowColor($property)
Get Glow Color Property.
Definition: GridLines.php:212
PhpOffice\PhpSpreadsheet\Chart\PlotArea\getPlotGroupCount
getPlotGroupCount()
Get Number of Plot Groups.
Definition: PlotArea.php:47
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writePlotSeriesValues
writePlotSeriesValues($plotSeriesValues, XMLWriter $objWriter, $groupType, $dataType='str')
Write Plot Series Values.
Definition: Chart.php:1267
$x
$x
Definition: complexTest.php:9
PhpOffice\PhpSpreadsheet\Chart\Axis\getAxisOptionsProperty
getAxisOptionsProperty($property)
Get Axis Options Property.
Definition: Axis.php:201
PhpOffice\PhpSpreadsheet\Writer\Xlsx\Chart\writeLayout
writeLayout(XMLWriter $objWriter, ?Layout $layout=null)
Write Layout.
Definition: Chart.php:1402