Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
<?php

namespace Box\Spout\Writer\XLSX\Helper;

use Box\Spout\Common\Entity\Style\Border;
use Box\Spout\Common\Entity\Style\BorderPart;

class BorderHelper
{
    public static $xlsxStyleMap = [
        Border::STYLE_SOLID => [
            Border::WIDTH_THIN   => 'thin',
            Border::WIDTH_MEDIUM => 'medium',
            Border::WIDTH_THICK  => 'thick',
        ],
        Border::STYLE_DOTTED => [
            Border::WIDTH_THIN   => 'dotted',
            Border::WIDTH_MEDIUM => 'dotted',
            Border::WIDTH_THICK  => 'dotted',
        ],
        Border::STYLE_DASHED => [
            Border::WIDTH_THIN   => 'dashed',
            Border::WIDTH_MEDIUM => 'mediumDashed',
            Border::WIDTH_THICK  => 'mediumDashed',
        ],
        Border::STYLE_DOUBLE => [
            Border::WIDTH_THIN   => 'double',
            Border::WIDTH_MEDIUM => 'double',
            Border::WIDTH_THICK  => 'double',
        ],
        Border::STYLE_NONE => [
            Border::WIDTH_THIN   => 'none',
            Border::WIDTH_MEDIUM => 'none',
            Border::WIDTH_THICK  => 'none',
        ],
    ];

    /**
     * @param BorderPart $borderPart
     * @return string
     */
    public static function serializeBorderPart(BorderPart $borderPart)
    {
        $borderStyle = self::getBorderStyle($borderPart);

< $colorEl = $borderPart->getColor() ? sprintf('<color rgb="%s"/>', $borderPart->getColor()) : ''; < $partEl = sprintf(
> $colorEl = $borderPart->getColor() ? \sprintf('<color rgb="%s"/>', $borderPart->getColor()) : ''; > $partEl = \sprintf(
'<%s style="%s">%s</%s>', $borderPart->getName(), $borderStyle, $colorEl, $borderPart->getName() ); return $partEl . PHP_EOL; } /** * Get the style definition from the style map * * @param BorderPart $borderPart * @return string */ protected static function getBorderStyle(BorderPart $borderPart) { return self::$xlsxStyleMap[$borderPart->getStyle()][$borderPart->getWidth()]; } }