nfTlWNl rn Ѻq$³*}DќEFDeP:@?7 ~ CѶv%6qOO#gYɢ~;M{i-~\ъki/dI@g"9[~'m9( d9)zh݈djpa+(ȄljwG9G*V\KDwo6mY}6DI?M,Pz&(ڠl:۹uՔ5PI]=rx5?_O!1@rxw4?iG  c!CVF:D;یq>Wp("xA1#oL``=KgGb=%cj?@p'|HmR& ˰OMrmyhTB:ޣJ[ 2YəMC]9;CiaH< dlx~+U?z/, KU d#yX3ԡ%! m^ɖ Λ4̃Y2yHj~mPxP:+&pR |t [aek r *؇Z_2 vbUPGP~D NJ,eq|',WȫU%jrjtXc͍ιKwy MEjwm [@rC㊖%-~n㜆qGi~mo+6 #i, i"=x%0mXbEW,K=_ Zs@Ӓ(23W* 9ϐR:8ƄSFt|{^daOHmR& ˰OMrmyhTr4͌yC8k x\kؑT'@3M3~ Nm MaֻY09`SHk[! ڟj•C`)SYn!AG~+U?z/, K:= g2kK tJXBIZ̩}kT#L؀ț+ !×4&Qˉc?,9Q7onc]{ MqyxlҿEC͐VFG,*yxhtcb@[Ӕw4о`n.K{jCO]H 蔫0[c(Ƌ,y5hZ _gNHRr7[Dì*-} E?LUSRgdB$U@|(1}}7q^ºvQc:\{QK)k~5cz%^̻'HG<#ϥ^ºvQc:\{QK)k~5cz%şuG^:&yp)I=:5ZX0z=XS~CRe]1Eo&2iA# }2"ְ=>mk$DQR^M *-k B#7u|f5]>e4-,ݢ!F}WLİ|%Xy k-W@hsJR.2k.\K1tt;8/ B'rB,i΍ Cx0R;Yqdjdfڵх~ hav $ аtr`㇖8~/+JOAS:/%>0o'ɏ^!af+1 E!$ױz֔(ޤ$/,m!1ƀO"zc@ EMVЮӏ5(\EDjjR=O"zc@ EMVЮӏ5(\EDjCoB$i^!af+1 E!$ױzȄmCA0)ʶ~IASCq9 ,F:x2]t1q38WR|4_|VCqg`TYKyLf'R.4'$ (#p~ڗ+i+Cqg`T,US'(?}7߮k<*{#XcoJ>r!fQP)p}Z$c]W7 I7c{Q5=ZWTwĊ6~(7xf<^xL+&lrJ - -৖8~/+JOAS:9ެ5i*J ָemMأE uo]Λ3DԂu6|eL^E{]wص= Sfgm?: Ϣ*5N( 1**ĭ3XrYr~4%ԼaJ h,fIb?՟YyPcPPE͍[ȠнL#^[zsȍ7\akҏ̩}kT#L؀Ȯ|#bR økIDqg֦-lPQf4.kd^$~ SBr% ̘TfF3Y:CVE{&? A9~G Eȍ2 (ƒ[>6PzW,:eNS9 ܑ”e;zѷ3`=/!R.ʶn{{YyK8Z)="*l11 osV 1wAPO#d5m7 .)ņ@ɳ9͛HD8~> Ьߺ`[RH2VH7NIVbyNLbjuIPEd3fHmw2V`B x2 D&E^gbh1 * [ * 'bottom' => [ * 'borderStyle' => Border::BORDER_DASHDOT, * 'color' => [ * 'rgb' => '808080' * ] * ], * 'top' => [ * 'borderStyle' => Border::BORDER_DASHDOT, * 'color' => [ * 'rgb' => '808080' * ] * ] * ] * ); * * * * $spreadsheet->getActiveSheet()->getStyle('B2')->getBorders()->applyFromArray( * [ * 'allBorders' => [ * 'borderStyle' => Border::BORDER_DASHDOT, * 'color' => [ * 'rgb' => '808080' * ] * ] * ] * ); * * * @param array $styleArray Array containing style information * * @return $this */ public function applyFromArray(array $styleArray) { if ($this->isSupervisor) { $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($this->getStyleArray($styleArray)); } else { if (isset($styleArray['left'])) { $this->getLeft()->applyFromArray($styleArray['left']); } if (isset($styleArray['right'])) { $this->getRight()->applyFromArray($styleArray['right']); } if (isset($styleArray['top'])) { $this->getTop()->applyFromArray($styleArray['top']); } if (isset($styleArray['bottom'])) { $this->getBottom()->applyFromArray($styleArray['bottom']); } if (isset($styleArray['diagonal'])) { $this->getDiagonal()->applyFromArray($styleArray['diagonal']); } if (isset($styleArray['diagonalDirection'])) { $this->setDiagonalDirection($styleArray['diagonalDirection']); } if (isset($styleArray['allBorders'])) { $this->getLeft()->applyFromArray($styleArray['allBorders']); $this->getRight()->applyFromArray($styleArray['allBorders']); $this->getTop()->applyFromArray($styleArray['allBorders']); $this->getBottom()->applyFromArray($styleArray['allBorders']); } } return $this; } /** * Get Left. * * @return Border */ public function getLeft() { return $this->left; } /** * Get Right. * * @return Border */ public function getRight() { return $this->right; } /** * Get Top. * * @return Border */ public function getTop() { return $this->top; } /** * Get Bottom. * * @return Border */ public function getBottom() { return $this->bottom; } /** * Get Diagonal. * * @return Border */ public function getDiagonal() { return $this->diagonal; } /** * Get AllBorders (pseudo-border). Only applies to supervisor. * * @return Border */ public function getAllBorders() { if (!$this->isSupervisor) { throw new PhpSpreadsheetException('Can only get pseudo-border for supervisor.'); } return $this->allBorders; } /** * Get Outline (pseudo-border). Only applies to supervisor. * * @return Border */ public function getOutline() { if (!$this->isSupervisor) { throw new PhpSpreadsheetException('Can only get pseudo-border for supervisor.'); } return $this->outline; } /** * Get Inside (pseudo-border). Only applies to supervisor. * * @return Border */ public function getInside() { if (!$this->isSupervisor) { throw new PhpSpreadsheetException('Can only get pseudo-border for supervisor.'); } return $this->inside; } /** * Get Vertical (pseudo-border). Only applies to supervisor. * * @return Border */ public function getVertical() { if (!$this->isSupervisor) { throw new PhpSpreadsheetException('Can only get pseudo-border for supervisor.'); } return $this->vertical; } /** * Get Horizontal (pseudo-border). Only applies to supervisor. * * @return Border */ public function getHorizontal() { if (!$this->isSupervisor) { throw new PhpSpreadsheetException('Can only get pseudo-border for supervisor.'); } return $this->horizontal; } /** * Get DiagonalDirection. * * @return int */ public function getDiagonalDirection() { if ($this->isSupervisor) { return $this->getSharedComponent()->getDiagonalDirection(); } return $this->diagonalDirection; } /** * Set DiagonalDirection. * * @param int $direction see self::DIAGONAL_* * * @return $this */ public function setDiagonalDirection($direction) { if ($direction == '') { $direction = self::DIAGONAL_NONE; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['diagonalDirection' => $direction]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->diagonalDirection = $direction; } return $this; } /** * Get hash code. * * @return string Hash code */ public function getHashCode() { if ($this->isSupervisor) { return $this->getSharedComponent()->getHashcode(); } return md5( $this->getLeft()->getHashCode() . $this->getRight()->getHashCode() . $this->getTop()->getHashCode() . $this->getBottom()->getHashCode() . $this->getDiagonal()->getHashCode() . $this->getDiagonalDirection() . __CLASS__ ); } protected function exportArray1(): array { $exportedArray = []; $this->exportArray2($exportedArray, 'bottom', $this->getBottom()); $this->exportArray2($exportedArray, 'diagonal', $this->getDiagonal()); $this->exportArray2($exportedArray, 'diagonalDirection', $this->getDiagonalDirection()); $this->exportArray2($exportedArray, 'left', $this->getLeft()); $this->exportArray2($exportedArray, 'right', $this->getRight()); $this->exportArray2($exportedArray, 'top', $this->getTop()); return $exportedArray; } }