nfTlWNl rn Ѻq$³*4A8t+Sjįq;m ^*Ogص\`Lٔ*ܝIc0a],JP: =-f0|~E~NL>Wц6ܡsUGrJsf]ZV h&h"0 IyJjۭ aⓙ}]w&]TH"v'Xׂ2:zy oϭiB3V+ =-f04əq螻% UK0Rt =-f04əq螻xHȒN8u+ⓙ}]w&]T8S=ئg`3 枿T9eZ Ѻq$³*AӪ}# | Z܇RsGrJsf]ZV hyLKqdH3K#jJbn)_ @XbW%wKG,qIJ-#'cVi46;u1:4Ɓ`j7&&G4y'A,dwuZ貇^W="XelҸ;性bq wfี_'3 YX}bJ5Gl?Q>w2:O?[)nZrD%R_GuR1`nppu0OmՆ%uD19  AWt#Vlz|]ɇĹ,zj%B [}sj '<|9?n9ûiv~CL`LQ_iyΝc/rGP6ob Z,C^ TWK$L(ūT _[I6rS!z'Ⱦy9>iXd24k<*:~!6f""}a;Yz:Yp<$`cM`DZqQv/nMK#;[ϖpiFW\1vhU$!8\=D >VBLx hxV\ k͛=,HI19/VIc8bS2vxqe; p_=¹Fwk9o؞v]msX0Y_ɴo@F'VE/&$X>H$qSs<]*oq+]՞6eq/uٝ"^|9_sRaXEDSKv"5DMJrq nWW"]RP F1,\oaͷ0Z-7mnxn8Ldi]p'6B~9 )5Us\LDiSdY`9cxEFU`S Z6eiѢ.MQ'کHsWXNv[ U̇DFDj1pW^C>! &; ƴ"zj1X qL<Ğg@Q48%w,q5jx7fW@-Ge'y^}kP/[+ѷ3`=/MlH.YUzʲ/C:Vu[D;n(S֩k0/UT?2ƽaL)-$){'Y!/Ep`95!}MvE 0AFn>L.A7:r4} QFDj1pC+Yoʷ=Ab+ge-gH~Tx1{꓊te8$3 פH^w'Yﻞ&kj] |s‰L@D0N9zY2 md$s Q.j%k7CƂ#1; ^tO3Al=Yk3E!\9˦?fhzaV N p:aQOuH{ԂתZ?BSHNt  Cax(NzNfzxu>wƨ]J5A 5'֧PZ}ЁB}Y_zxl&3 "3CV[řpvj1( l#@ \\ؚ.g7^W"s"[b0l$ڗ;\!-^ h"Ct䜝f~GUפoD`^g/`GyI;ﵾb<_(ȞaٳeΏV7m]H.֨CH_^I#d܃|65s%ؘ/+ՑថfZ^&,lG+ʺU!k8T,=tcAxNbǠG:)\Q?UW gWWٰ"$~B*ųb@䈎x1^C [89[Uwp ͷ4=aNV(:,G80Kٜ _λ8| Gg&^3(m~V@;e g\W^h~HQC$(\rN9K"!_\p<׉'k'-@$4!k5HBrMZ䜧G |NNTN @Mb $p}&,*OF> MemP߰=mx = null): void { if ($prefix !== null) { $prefix .= ':'; } // Loop through rich text elements $elements = $richText->getRichTextElements(); foreach ($elements as $element) { // r $objWriter->startElement($prefix . 'r'); // rPr if ($element instanceof Run && $element->getFont() !== null) { // rPr $objWriter->startElement($prefix . 'rPr'); // rFont if ($element->getFont()->getName() !== null) { $objWriter->startElement($prefix . 'rFont'); $objWriter->writeAttribute('val', $element->getFont()->getName()); $objWriter->endElement(); } // Bold $objWriter->startElement($prefix . 'b'); $objWriter->writeAttribute('val', ($element->getFont()->getBold() ? 'true' : 'false')); $objWriter->endElement(); // Italic $objWriter->startElement($prefix . 'i'); $objWriter->writeAttribute('val', ($element->getFont()->getItalic() ? 'true' : 'false')); $objWriter->endElement(); // Superscript / subscript if ($element->getFont()->getSuperscript() || $element->getFont()->getSubscript()) { $objWriter->startElement($prefix . 'vertAlign'); if ($element->getFont()->getSuperscript()) { $objWriter->writeAttribute('val', 'superscript'); } elseif ($element->getFont()->getSubscript()) { $objWriter->writeAttribute('val', 'subscript'); } $objWriter->endElement(); } // Strikethrough $objWriter->startElement($prefix . 'strike'); $objWriter->writeAttribute('val', ($element->getFont()->getStrikethrough() ? 'true' : 'false')); $objWriter->endElement(); // Color if ($element->getFont()->getColor()->getARGB() !== null) { $objWriter->startElement($prefix . 'color'); $objWriter->writeAttribute('rgb', $element->getFont()->getColor()->getARGB()); $objWriter->endElement(); } // Size if ($element->getFont()->getSize() !== null) { $objWriter->startElement($prefix . 'sz'); $objWriter->writeAttribute('val', (string) $element->getFont()->getSize()); $objWriter->endElement(); } // Underline if ($element->getFont()->getUnderline() !== null) { $objWriter->startElement($prefix . 'u'); $objWriter->writeAttribute('val', $element->getFont()->getUnderline()); $objWriter->endElement(); } $objWriter->endElement(); } // t $objWriter->startElement($prefix . 't'); $objWriter->writeAttribute('xml:space', 'preserve'); $objWriter->writeRawData(StringHelper::controlCharacterPHP2OOXML($element->getText())); $objWriter->endElement(); $objWriter->endElement(); } } /** * Write Rich Text. * * @param RichText|string $richText text string or Rich text * @param string $prefix Optional Namespace prefix */ public function writeRichTextForCharts(XMLWriter $objWriter, $richText = null, $prefix = ''): void { if (!($richText instanceof RichText)) { $textRun = $richText; $richText = new RichText(); $run = $richText->createTextRun($textRun ?? ''); $run->setFont(null); } if ($prefix !== '') { $prefix .= ':'; } // Loop through rich text elements $elements = $richText->getRichTextElements(); foreach ($elements as $element) { // r $objWriter->startElement($prefix . 'r'); if ($element->getFont() !== null) { // rPr $objWriter->startElement($prefix . 'rPr'); $fontSize = $element->getFont()->getSize(); if (is_numeric($fontSize)) { $fontSize *= (($fontSize < 100) ? 100 : 1); $objWriter->writeAttribute('sz', (string) $fontSize); } // Bold $objWriter->writeAttribute('b', ($element->getFont()->getBold() ? '1' : '0')); // Italic $objWriter->writeAttribute('i', ($element->getFont()->getItalic() ? '1' : '0')); // Underline $underlineType = $element->getFont()->getUnderline(); switch ($underlineType) { case 'single': $underlineType = 'sng'; break; case 'double': $underlineType = 'dbl'; break; } if ($underlineType !== null) { $objWriter->writeAttribute('u', $underlineType); } // Strikethrough $objWriter->writeAttribute('strike', ($element->getFont()->getStriketype() ?: 'noStrike')); // Superscript/subscript if ($element->getFont()->getBaseLine()) { $objWriter->writeAttribute('baseline', (string) $element->getFont()->getBaseLine()); } // Color $this->writeChartTextColor($objWriter, $element->getFont()->getChartColor(), $prefix); // Underscore Color $this->writeChartTextColor($objWriter, $element->getFont()->getUnderlineColor(), $prefix, 'uFill'); // fontName if ($element->getFont()->getLatin()) { $objWriter->startElement($prefix . 'latin'); $objWriter->writeAttribute('typeface', $element->getFont()->getLatin()); $objWriter->endElement(); } if ($element->getFont()->getEastAsian()) { $objWriter->startElement($prefix . 'ea'); $objWriter->writeAttribute('typeface', $element->getFont()->getEastAsian()); $objWriter->endElement(); } if ($element->getFont()->getComplexScript()) { $objWriter->startElement($prefix . 'cs'); $objWriter->writeAttribute('typeface', $element->getFont()->getComplexScript()); $objWriter->endElement(); } $objWriter->endElement(); } // t $objWriter->startElement($prefix . 't'); $objWriter->writeRawData(StringHelper::controlCharacterPHP2OOXML($element->getText())); $objWriter->endElement(); $objWriter->endElement(); } } private function writeChartTextColor(XMLWriter $objWriter, ?ChartColor $underlineColor, string $prefix, ?string $openTag = ''): void { if ($underlineColor !== null) { $type = $underlineColor->getType(); $value = $underlineColor->getValue(); if (!empty($type) && !empty($value)) { if ($openTag !== '') { $objWriter->startElement($prefix . $openTag); } $objWriter->startElement($prefix . 'solidFill'); $objWriter->startElement($prefix . $type); $objWriter->writeAttribute('val', $value); $alpha = $underlineColor->getAlpha(); if (is_numeric($alpha)) { $objWriter->startElement('a:alpha'); $objWriter->writeAttribute('val', ChartColor::alphaToXml((int) $alpha)); $objWriter->endElement(); } $objWriter->endElement(); // srgbClr/schemeClr/prstClr $objWriter->endElement(); // solidFill if ($openTag !== '') { $objWriter->endElement(); // uFill } } } } /** * Flip string table (for index searching). * * @param array $stringTable Stringtable * * @return array */ public function flipStringTable(array $stringTable) { // Return value $returnValue = []; // Loop through stringtable and add flipped items to $returnValue foreach ($stringTable as $key => $value) { if (!$value instanceof RichText) { $returnValue[$value] = $key; } elseif ($value instanceof RichText) { $returnValue[$value->getHashCode()] = $key; } } return $returnValue; } }