PHPOffice / PhpSpreadsheet

        // Cannot be resolved already in XF record, because PALETTE record comes afterwards

        if (!$this->readDataOnly) {

            foreach ($this->objFonts as $objFont) {

                if (isset($objFont->colorIndex)) {

                    $color = Excel5\Color::map($objFont->colorIndex, $this->palette, $this->version);

                    $objFont->getColor()->setRGB($color['rgb']);

                }

            }

            foreach ($this->spreadsheet->getCellXfCollection() as $objStyle) {

                $left     = $objStyle->getBorders()->getLeft();

                $diagonal = $objStyle->getBorders()->getDiagonal();

                if (isset($top->colorIndex)) {

                    $borderTopColor = Excel5\Color::map($top->colorIndex, $this->palette, $this->version);

                    $top->getColor()->setRGB($borderTopColor['rgb']);

                }

                if (isset($right->colorIndex)) {

                    $borderRightColor = Excel5\Color::map($right->colorIndex, $this->palette, $this->version);

                    $right->getColor()->setRGB($borderRightColor['rgb']);

                    $borderTopColor = Excel5\Color::map($top->colorIndex, $this->palette, $this->version);

                    $top->getColor()->setRGB($borderTopColor['rgb']);

                }

                if (isset($right->colorIndex)) {

                    $borderRightColor = Excel5\Color::map($right->colorIndex, $this->palette, $this->version);

                    $right->getColor()->setRGB($borderRightColor['rgb']);

                }

                if (isset($bottom->colorIndex)) {

                    $borderBottomColor = Excel5\Color::map($bottom->colorIndex, $this->palette, $this->version);

                    $bottom->getColor()->setRGB($borderBottomColor['rgb']);

                    $borderRightColor = Excel5\Color::map($right->colorIndex, $this->palette, $this->version);

                    $right->getColor()->setRGB($borderRightColor['rgb']);

                }

                if (isset($bottom->colorIndex)) {

                    $borderBottomColor = Excel5\Color::map($bottom->colorIndex, $this->palette, $this->version);

                    $bottom->getColor()->setRGB($borderBottomColor['rgb']);

                }

                if (isset($left->colorIndex)) {

                    $borderLeftColor = Excel5\Color::map($left->colorIndex, $this->palette, $this->version);

                    $left->getColor()->setRGB($borderLeftColor['rgb']);

                    $borderBottomColor = Excel5\Color::map($bottom->colorIndex, $this->palette, $this->version);

                    $bottom->getColor()->setRGB($borderBottomColor['rgb']);

                }

                if (isset($left->colorIndex)) {

                    $borderLeftColor = Excel5\Color::map($left->colorIndex, $this->palette, $this->version);

                    $left->getColor()->setRGB($borderLeftColor['rgb']);

                }

                if (isset($diagonal->colorIndex)) {

                    $borderDiagonalColor = Excel5\Color::map($diagonal->colorIndex, $this->palette, $this->version);

                    $diagonal->getColor()->setRGB($borderDiagonalColor['rgb']);

                    $borderLeftColor = Excel5\Color::map($left->colorIndex, $this->palette, $this->version);

                    $left->getColor()->setRGB($borderLeftColor['rgb']);

                }

                if (isset($diagonal->colorIndex)) {

                    $borderDiagonalColor = Excel5\Color::map($diagonal->colorIndex, $this->palette, $this->version);

                    $diagonal->getColor()->setRGB($borderDiagonalColor['rgb']);

                }

            }

        }