<?php

namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx;


> use PhpOffice\PhpSpreadsheet\Reader\Xlsx\Namespaces;


use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

> use PhpOffice\PhpSpreadsheet\Style\Alignment;


use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Style\Borders;
use PhpOffice\PhpSpreadsheet\Style\Conditional;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\Font;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;
use PhpOffice\PhpSpreadsheet\Style\Protection;

class Style extends WriterPart
{
    /**
     * Write styles to XML format.
     *

<      * @param Spreadsheet $spreadsheet
<      *
<      * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
<      *


     * @return string XML Output
     */
    public function writeStyles(Spreadsheet $spreadsheet)
    {
        // Create XML writer
        $objWriter = null;
        if ($this->getParentWriter()->getUseDiskCaching()) {
            $objWriter = new XMLWriter(XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
        } else {
            $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
        }

        // XML header
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');

        // styleSheet
        $objWriter->startElement('styleSheet');
        $objWriter->writeAttribute('xml:space', 'preserve');

<         $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');



>         $objWriter->writeAttribute('xmlns', Namespaces::MAIN);



        // numFmts
        $objWriter->startElement('numFmts');

<         $objWriter->writeAttribute('count', $this->getParentWriter()->getNumFmtHashTable()->count());



>         $objWriter->writeAttribute('count', (string) $this->getParentWriter()->getNumFmtHashTable()->count());



        // numFmt
        for ($i = 0; $i < $this->getParentWriter()->getNumFmtHashTable()->count(); ++$i) {
            $this->writeNumFmt($objWriter, $this->getParentWriter()->getNumFmtHashTable()->getByIndex($i), $i);
        }

        $objWriter->endElement();

        // fonts
        $objWriter->startElement('fonts');

<         $objWriter->writeAttribute('count', $this->getParentWriter()->getFontHashTable()->count());



>         $objWriter->writeAttribute('count', (string) $this->getParentWriter()->getFontHashTable()->count());



        // font
        for ($i = 0; $i < $this->getParentWriter()->getFontHashTable()->count(); ++$i) {

<             $this->writeFont($objWriter, $this->getParentWriter()->getFontHashTable()->getByIndex($i));



>             $thisfont = $this->getParentWriter()->getFontHashTable()->getByIndex($i);
>             if ($thisfont !== null) {
>                 $this->writeFont($objWriter, $thisfont);
>             }


        }

        $objWriter->endElement();

        // fills
        $objWriter->startElement('fills');

<         $objWriter->writeAttribute('count', $this->getParentWriter()->getFillHashTable()->count());



>         $objWriter->writeAttribute('count', (string) $this->getParentWriter()->getFillHashTable()->count());



        // fill
        for ($i = 0; $i < $this->getParentWriter()->getFillHashTable()->count(); ++$i) {

<             $this->writeFill($objWriter, $this->getParentWriter()->getFillHashTable()->getByIndex($i));



>             $thisfill = $this->getParentWriter()->getFillHashTable()->getByIndex($i);
>             if ($thisfill !== null) {
>                 $this->writeFill($objWriter, $thisfill);
>             }


        }

        $objWriter->endElement();

        // borders
        $objWriter->startElement('borders');

<         $objWriter->writeAttribute('count', $this->getParentWriter()->getBordersHashTable()->count());



>         $objWriter->writeAttribute('count', (string) $this->getParentWriter()->getBordersHashTable()->count());



        // border
        for ($i = 0; $i < $this->getParentWriter()->getBordersHashTable()->count(); ++$i) {

<             $this->writeBorder($objWriter, $this->getParentWriter()->getBordersHashTable()->getByIndex($i));



>             $thisborder = $this->getParentWriter()->getBordersHashTable()->getByIndex($i);
>             if ($thisborder !== null) {
>                 $this->writeBorder($objWriter, $thisborder);
>             }


        }

        $objWriter->endElement();

        // cellStyleXfs
        $objWriter->startElement('cellStyleXfs');

<         $objWriter->writeAttribute('count', 1);



>         $objWriter->writeAttribute('count', '1');



        // xf
        $objWriter->startElement('xf');

<         $objWriter->writeAttribute('numFmtId', 0);
<         $objWriter->writeAttribute('fontId', 0);
<         $objWriter->writeAttribute('fillId', 0);
<         $objWriter->writeAttribute('borderId', 0);



>         $objWriter->writeAttribute('numFmtId', '0');
>         $objWriter->writeAttribute('fontId', '0');
>         $objWriter->writeAttribute('fillId', '0');
>         $objWriter->writeAttribute('borderId', '0');


        $objWriter->endElement();

        $objWriter->endElement();

        // cellXfs
        $objWriter->startElement('cellXfs');

<         $objWriter->writeAttribute('count', count($spreadsheet->getCellXfCollection()));



>         $objWriter->writeAttribute('count', (string) count($spreadsheet->getCellXfCollection()));



        // xf

>         $alignment = new Alignment();
        foreach ($spreadsheet->getCellXfCollection() as $cellXf) {
>         $defaultAlignHash = $alignment->getHashCode();
            $this->writeCellStyleXf($objWriter, $cellXf, $spreadsheet);
>         if ($defaultAlignHash !== $spreadsheet->getDefaultStyle()->getAlignment()->getHashCode()) {
        }
>             $defaultAlignHash = '';

>         }



<             $this->writeCellStyleXf($objWriter, $cellXf, $spreadsheet);



>             $this->writeCellStyleXf($objWriter, $cellXf, $spreadsheet, $defaultAlignHash);



        // cellStyles
        $objWriter->startElement('cellStyles');

<         $objWriter->writeAttribute('count', 1);



>         $objWriter->writeAttribute('count', '1');



        // cellStyle
        $objWriter->startElement('cellStyle');
        $objWriter->writeAttribute('name', 'Normal');

<         $objWriter->writeAttribute('xfId', 0);
<         $objWriter->writeAttribute('builtinId', 0);



>         $objWriter->writeAttribute('xfId', '0');
>         $objWriter->writeAttribute('builtinId', '0');


        $objWriter->endElement();

        $objWriter->endElement();

        // dxfs
        $objWriter->startElement('dxfs');

<         $objWriter->writeAttribute('count', $this->getParentWriter()->getStylesConditionalHashTable()->count());



>         $objWriter->writeAttribute('count', (string) $this->getParentWriter()->getStylesConditionalHashTable()->count());



        // dxf
        for ($i = 0; $i < $this->getParentWriter()->getStylesConditionalHashTable()->count(); ++$i) {

<             $this->writeCellStyleDxf($objWriter, $this->getParentWriter()->getStylesConditionalHashTable()->getByIndex($i)->getStyle());



>             $thisstyle = $this->getParentWriter()->getStylesConditionalHashTable()->getByIndex($i);
>             if ($thisstyle !== null) {
>                 $this->writeCellStyleDxf($objWriter, $thisstyle->getStyle());
>             }


        }

        $objWriter->endElement();

        // tableStyles
        $objWriter->startElement('tableStyles');
        $objWriter->writeAttribute('defaultTableStyle', 'TableStyleMedium9');
        $objWriter->writeAttribute('defaultPivotStyle', 'PivotTableStyle1');
        $objWriter->endElement();

        $objWriter->endElement();

        // Return
        return $objWriter->getData();
    }

    /**
     * Write Fill.

<      *
<      * @param XMLWriter $objWriter XML Writer
<      * @param Fill $pFill Fill style


     */

<     private function writeFill(XMLWriter $objWriter, Fill $pFill)



>     private function writeFill(XMLWriter $objWriter, Fill $fill): void


    {
        // Check if this is a pattern type or gradient type

<         if ($pFill->getFillType() === Fill::FILL_GRADIENT_LINEAR ||
<             $pFill->getFillType() === Fill::FILL_GRADIENT_PATH) {



>         if (
>             $fill->getFillType() === Fill::FILL_GRADIENT_LINEAR ||
>             $fill->getFillType() === Fill::FILL_GRADIENT_PATH
>         ) {


            // Gradient fill

<             $this->writeGradientFill($objWriter, $pFill);
<         } elseif ($pFill->getFillType() !== null) {



>             $this->writeGradientFill($objWriter, $fill);
>         } elseif ($fill->getFillType() !== null) {


            // Pattern fill

<             $this->writePatternFill($objWriter, $pFill);



>             $this->writePatternFill($objWriter, $fill);


        }
    }

    /**
     * Write Gradient Fill.

<      *
<      * @param XMLWriter $objWriter XML Writer
<      * @param Fill $pFill Fill style


     */

<     private function writeGradientFill(XMLWriter $objWriter, Fill $pFill)



>     private function writeGradientFill(XMLWriter $objWriter, Fill $fill): void


    {
        // fill
        $objWriter->startElement('fill');

        // gradientFill
        $objWriter->startElement('gradientFill');

<         $objWriter->writeAttribute('type', $pFill->getFillType());
<         $objWriter->writeAttribute('degree', $pFill->getRotation());



>         $objWriter->writeAttribute('type', (string) $fill->getFillType());
>         $objWriter->writeAttribute('degree', (string) $fill->getRotation());



        // stop
        $objWriter->startElement('stop');
        $objWriter->writeAttribute('position', '0');

        // color

>         if ($fill->getStartColor()->getARGB() !== null) {


        $objWriter->startElement('color');

<         $objWriter->writeAttribute('rgb', $pFill->getStartColor()->getARGB());



>             $objWriter->writeAttribute('rgb', $fill->getStartColor()->getARGB());


        $objWriter->endElement();

>         }



        $objWriter->endElement();

        // stop
        $objWriter->startElement('stop');
        $objWriter->writeAttribute('position', '1');

        // color

>         if ($fill->getEndColor()->getARGB() !== null) {


        $objWriter->startElement('color');

<         $objWriter->writeAttribute('rgb', $pFill->getEndColor()->getARGB());



>             $objWriter->writeAttribute('rgb', $fill->getEndColor()->getARGB());


        $objWriter->endElement();

>         }



        $objWriter->endElement();

        $objWriter->endElement();

        $objWriter->endElement();
    }


>     private static function writePatternColors(Fill $fill): bool
    /**
>     {
     * Write Pattern Fill.
>         if ($fill->getFillType() === Fill::FILL_NONE) {
     *
>             return false;
     * @param XMLWriter $objWriter XML Writer
>         }
     * @param Fill $pFill Fill style
> 
     */
>         return $fill->getFillType() === Fill::FILL_SOLID || $fill->getColorsChanged();
    private function writePatternFill(XMLWriter $objWriter, Fill $pFill)
>     }
    {
> 



<      *
<      * @param XMLWriter $objWriter XML Writer
<      * @param Fill $pFill Fill style



<     private function writePatternFill(XMLWriter $objWriter, Fill $pFill)



>     private function writePatternFill(XMLWriter $objWriter, Fill $fill): void


        $objWriter->startElement('patternFill');

<         $objWriter->writeAttribute('patternType', $pFill->getFillType());



>         $objWriter->writeAttribute('patternType', (string) $fill->getFillType());




<         if ($pFill->getFillType() !== Fill::FILL_NONE) {



>         if (self::writePatternColors($fill)) {


            // fgColor

<             if ($pFill->getStartColor()->getARGB()) {



>             if ($fill->getStartColor()->getARGB()) {
>                 if (!$fill->getEndColor()->getARGB() && $fill->getFillType() === Fill::FILL_SOLID) {
>                     $objWriter->startElement('bgColor');
>                     $objWriter->writeAttribute('rgb', $fill->getStartColor()->getARGB());
>                 } else {


                $objWriter->startElement('fgColor');

<                 $objWriter->writeAttribute('rgb', $pFill->getStartColor()->getARGB());
<                 $objWriter->endElement();



>                     $objWriter->writeAttribute('rgb', $fill->getStartColor()->getARGB());


            }

>                 $objWriter->endElement();


        }

<         if ($pFill->getFillType() !== Fill::FILL_NONE) {


            // bgColor

<             if ($pFill->getEndColor()->getARGB()) {



>             if ($fill->getEndColor()->getARGB()) {


                $objWriter->startElement('bgColor');

<                 $objWriter->writeAttribute('rgb', $pFill->getEndColor()->getARGB());



>                 $objWriter->writeAttribute('rgb', $fill->getEndColor()->getARGB());


                $objWriter->endElement();
            }
        }

        $objWriter->endElement();

        $objWriter->endElement();
    }


>     private function startFont(XMLWriter $objWriter, bool &$fontStarted): void
    /**
>     {
     * Write Font.
>         if (!$fontStarted) {
     *
>             $fontStarted = true;
     * @param XMLWriter $objWriter XML Writer
>             $objWriter->startElement('font');
     * @param Font $pFont Font style
>         }
     */
>     }
    private function writeFont(XMLWriter $objWriter, Font $pFont)
> 



<      *
<      * @param XMLWriter $objWriter XML Writer
<      * @param Font $pFont Font style



<     private function writeFont(XMLWriter $objWriter, Font $pFont)



>     private function writeFont(XMLWriter $objWriter, Font $font): void


        //        files in Excel2003 with the compatibility pack. It's not documented behaviour,

>         $fontStarted = false;



<         $objWriter->startElement('font');



        // Bold. We explicitly write this element also when false (like MS Office Excel 2007 does
        // for conditional formatting). Otherwise it will apparently not be picked up in conditional
        // formatting style dialog

<         if ($pFont->getBold() !== null) {



>         if ($font->getBold() !== null) {
>             $this->startFont($objWriter, $fontStarted);


            $objWriter->startElement('b');

<             $objWriter->writeAttribute('val', $pFont->getBold() ? '1' : '0');



>             $objWriter->writeAttribute('val', $font->getBold() ? '1' : '0');


            $objWriter->endElement();
        }

        // Italic

<         if ($pFont->getItalic() !== null) {



>         if ($font->getItalic() !== null) {
>             $this->startFont($objWriter, $fontStarted);


            $objWriter->startElement('i');

<             $objWriter->writeAttribute('val', $pFont->getItalic() ? '1' : '0');



>             $objWriter->writeAttribute('val', $font->getItalic() ? '1' : '0');


            $objWriter->endElement();
        }

        // Strikethrough

<         if ($pFont->getStrikethrough() !== null) {



>         if ($font->getStrikethrough() !== null) {
>             $this->startFont($objWriter, $fontStarted);


            $objWriter->startElement('strike');

<             $objWriter->writeAttribute('val', $pFont->getStrikethrough() ? '1' : '0');



>             $objWriter->writeAttribute('val', $font->getStrikethrough() ? '1' : '0');


            $objWriter->endElement();
        }

        // Underline

<         if ($pFont->getUnderline() !== null) {



>         if ($font->getUnderline() !== null) {
>             $this->startFont($objWriter, $fontStarted);


            $objWriter->startElement('u');

<             $objWriter->writeAttribute('val', $pFont->getUnderline());



>             $objWriter->writeAttribute('val', $font->getUnderline());


            $objWriter->endElement();
        }

        // Superscript / subscript

<         if ($pFont->getSuperscript() === true || $pFont->getSubscript() === true) {



>         if ($font->getSuperscript() === true || $font->getSubscript() === true) {
>             $this->startFont($objWriter, $fontStarted);


            $objWriter->startElement('vertAlign');

<             if ($pFont->getSuperscript() === true) {



>             if ($font->getSuperscript() === true) {


                $objWriter->writeAttribute('val', 'superscript');

<             } elseif ($pFont->getSubscript() === true) {



>             } elseif ($font->getSubscript() === true) {


                $objWriter->writeAttribute('val', 'subscript');
            }
            $objWriter->endElement();
        }

        // Size

<         if ($pFont->getSize() !== null) {



>         if ($font->getSize() !== null) {
>             $this->startFont($objWriter, $fontStarted);


            $objWriter->startElement('sz');

<             $objWriter->writeAttribute('val', StringHelper::formatNumber($pFont->getSize()));



>             $objWriter->writeAttribute('val', StringHelper::formatNumber($font->getSize()));


            $objWriter->endElement();
        }

        // Foreground color

<         if ($pFont->getColor()->getARGB() !== null) {



>         if ($font->getColor()->getARGB() !== null) {
>             $this->startFont($objWriter, $fontStarted);


            $objWriter->startElement('color');

<             $objWriter->writeAttribute('rgb', $pFont->getColor()->getARGB());



>             $objWriter->writeAttribute('rgb', $font->getColor()->getARGB());


            $objWriter->endElement();
        }

        // Name

<         if ($pFont->getName() !== null) {



>         if ($font->getName() !== null) {
>             $this->startFont($objWriter, $fontStarted);


            $objWriter->startElement('name');

<             $objWriter->writeAttribute('val', $pFont->getName());



>             $objWriter->writeAttribute('val', $font->getName());


            $objWriter->endElement();
        }


>         if (!empty($font->getScheme())) {
        $objWriter->endElement();
>             $this->startFont($objWriter, $fontStarted);
    }
>             $objWriter->startElement('scheme');

>             $objWriter->writeAttribute('val', $font->getScheme());


    /**

>         if ($fontStarted) {
     * Write Border.
>             $objWriter->endElement();
     *
>         }
     * @param XMLWriter $objWriter XML Writer
>     }
     * @param Borders $pBorders Borders style
> 



<      *
<      * @param XMLWriter $objWriter XML Writer
<      * @param Borders $pBorders Borders style



<     private function writeBorder(XMLWriter $objWriter, Borders $pBorders)



>     private function writeBorder(XMLWriter $objWriter, Borders $borders): void


        $objWriter->startElement('border');
        // Diagonal?

<         switch ($pBorders->getDiagonalDirection()) {



>         switch ($borders->getDiagonalDirection()) {


            case Borders::DIAGONAL_UP:
                $objWriter->writeAttribute('diagonalUp', 'true');
                $objWriter->writeAttribute('diagonalDown', 'false');

                break;
            case Borders::DIAGONAL_DOWN:
                $objWriter->writeAttribute('diagonalUp', 'false');
                $objWriter->writeAttribute('diagonalDown', 'true');

                break;
            case Borders::DIAGONAL_BOTH:
                $objWriter->writeAttribute('diagonalUp', 'true');
                $objWriter->writeAttribute('diagonalDown', 'true');

                break;
        }

        // BorderPr

<         $this->writeBorderPr($objWriter, 'left', $pBorders->getLeft());
<         $this->writeBorderPr($objWriter, 'right', $pBorders->getRight());
<         $this->writeBorderPr($objWriter, 'top', $pBorders->getTop());
<         $this->writeBorderPr($objWriter, 'bottom', $pBorders->getBottom());
<         $this->writeBorderPr($objWriter, 'diagonal', $pBorders->getDiagonal());



>         $this->writeBorderPr($objWriter, 'left', $borders->getLeft());
>         $this->writeBorderPr($objWriter, 'right', $borders->getRight());
>         $this->writeBorderPr($objWriter, 'top', $borders->getTop());
>         $this->writeBorderPr($objWriter, 'bottom', $borders->getBottom());
>         $this->writeBorderPr($objWriter, 'diagonal', $borders->getDiagonal());


        $objWriter->endElement();
    }


>     /** @var mixed */
    /**
>     private static $scrutinizerFalse = false;
     * Write Cell Style Xf.
> 



<      *
<      * @param XMLWriter $objWriter XML Writer
<      * @param \PhpOffice\PhpSpreadsheet\Style\Style $pStyle Style
<      * @param Spreadsheet $spreadsheet Workbook
<      *
<      * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception


     */

<     private function writeCellStyleXf(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style $pStyle, Spreadsheet $spreadsheet)



>     private function writeCellStyleXf(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style $style, Spreadsheet $spreadsheet, string $defaultAlignHash): void


    {
        // xf
        $objWriter->startElement('xf');

<         $objWriter->writeAttribute('xfId', 0);
<         $objWriter->writeAttribute('fontId', (int) $this->getParentWriter()->getFontHashTable()->getIndexForHashCode($pStyle->getFont()->getHashCode()));
<         if ($pStyle->getQuotePrefix()) {
<             $objWriter->writeAttribute('quotePrefix', 1);



>         $objWriter->writeAttribute('xfId', '0');
>         $objWriter->writeAttribute('fontId', (string) (int) $this->getParentWriter()->getFontHashTable()->getIndexForHashCode($style->getFont()->getHashCode()));
>         if ($style->getQuotePrefix()) {
>             $objWriter->writeAttribute('quotePrefix', '1');


        }


<         if ($pStyle->getNumberFormat()->getBuiltInFormatCode() === false) {
<             $objWriter->writeAttribute('numFmtId', (int) ($this->getParentWriter()->getNumFmtHashTable()->getIndexForHashCode($pStyle->getNumberFormat()->getHashCode()) + 164));



>         if ($style->getNumberFormat()->getBuiltInFormatCode() === self::$scrutinizerFalse) {
>             $objWriter->writeAttribute('numFmtId', (string) (int) ($this->getParentWriter()->getNumFmtHashTable()->getIndexForHashCode($style->getNumberFormat()->getHashCode()) + 164));


        } else {

<             $objWriter->writeAttribute('numFmtId', (int) $pStyle->getNumberFormat()->getBuiltInFormatCode());



>             $objWriter->writeAttribute('numFmtId', (string) (int) $style->getNumberFormat()->getBuiltInFormatCode());


        }


<         $objWriter->writeAttribute('fillId', (int) $this->getParentWriter()->getFillHashTable()->getIndexForHashCode($pStyle->getFill()->getHashCode()));
<         $objWriter->writeAttribute('borderId', (int) $this->getParentWriter()->getBordersHashTable()->getIndexForHashCode($pStyle->getBorders()->getHashCode()));



>         $objWriter->writeAttribute('fillId', (string) (int) $this->getParentWriter()->getFillHashTable()->getIndexForHashCode($style->getFill()->getHashCode()));
>         $objWriter->writeAttribute('borderId', (string) (int) $this->getParentWriter()->getBordersHashTable()->getIndexForHashCode($style->getBorders()->getHashCode()));



        // Apply styles?

<         $objWriter->writeAttribute('applyFont', ($spreadsheet->getDefaultStyle()->getFont()->getHashCode() != $pStyle->getFont()->getHashCode()) ? '1' : '0');
<         $objWriter->writeAttribute('applyNumberFormat', ($spreadsheet->getDefaultStyle()->getNumberFormat()->getHashCode() != $pStyle->getNumberFormat()->getHashCode()) ? '1' : '0');
<         $objWriter->writeAttribute('applyFill', ($spreadsheet->getDefaultStyle()->getFill()->getHashCode() != $pStyle->getFill()->getHashCode()) ? '1' : '0');
<         $objWriter->writeAttribute('applyBorder', ($spreadsheet->getDefaultStyle()->getBorders()->getHashCode() != $pStyle->getBorders()->getHashCode()) ? '1' : '0');
<         $objWriter->writeAttribute('applyAlignment', ($spreadsheet->getDefaultStyle()->getAlignment()->getHashCode() != $pStyle->getAlignment()->getHashCode()) ? '1' : '0');
<         if ($pStyle->getProtection()->getLocked() != Protection::PROTECTION_INHERIT || $pStyle->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {



>         $objWriter->writeAttribute('applyFont', ($spreadsheet->getDefaultStyle()->getFont()->getHashCode() != $style->getFont()->getHashCode()) ? '1' : '0');
>         $objWriter->writeAttribute('applyNumberFormat', ($spreadsheet->getDefaultStyle()->getNumberFormat()->getHashCode() != $style->getNumberFormat()->getHashCode()) ? '1' : '0');
>         $objWriter->writeAttribute('applyFill', ($spreadsheet->getDefaultStyle()->getFill()->getHashCode() != $style->getFill()->getHashCode()) ? '1' : '0');
>         $objWriter->writeAttribute('applyBorder', ($spreadsheet->getDefaultStyle()->getBorders()->getHashCode() != $style->getBorders()->getHashCode()) ? '1' : '0');
>         if ($defaultAlignHash !== '' && $defaultAlignHash === $style->getAlignment()->getHashCode()) {
>             $applyAlignment = '0';
>         } else {
>             $applyAlignment = '1';
>         }
>         $objWriter->writeAttribute('applyAlignment', $applyAlignment);
>         if ($style->getProtection()->getLocked() != Protection::PROTECTION_INHERIT || $style->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {


            $objWriter->writeAttribute('applyProtection', 'true');
        }

        // alignment

>         if ($applyAlignment === '1') {


        $objWriter->startElement('alignment');

<         $objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal());
<         $objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical());



>             $vertical = Alignment::VERTICAL_ALIGNMENT_FOR_XLSX[$style->getAlignment()->getVertical()] ?? '';
>             $horizontal = Alignment::HORIZONTAL_ALIGNMENT_FOR_XLSX[$style->getAlignment()->getHorizontal()] ?? '';
>             if ($horizontal !== '') {
>                 $objWriter->writeAttribute('horizontal', $horizontal);
>             }
>             if ($vertical !== '') {
>                 $objWriter->writeAttribute('vertical', $vertical);
>             }




<         $textRotation = 0;
<         if ($pStyle->getAlignment()->getTextRotation() >= 0) {
<             $textRotation = $pStyle->getAlignment()->getTextRotation();
<         } elseif ($pStyle->getAlignment()->getTextRotation() < 0) {
<             $textRotation = 90 - $pStyle->getAlignment()->getTextRotation();



>             if ($style->getAlignment()->getTextRotation() >= 0) {
>                 $textRotation = $style->getAlignment()->getTextRotation();
>             } else {
>                 $textRotation = 90 - $style->getAlignment()->getTextRotation();


        }

<         $objWriter->writeAttribute('textRotation', $textRotation);



>             $objWriter->writeAttribute('textRotation', (string) $textRotation);




<         $objWriter->writeAttribute('wrapText', ($pStyle->getAlignment()->getWrapText() ? 'true' : 'false'));
<         $objWriter->writeAttribute('shrinkToFit', ($pStyle->getAlignment()->getShrinkToFit() ? 'true' : 'false'));



>             $objWriter->writeAttribute('wrapText', ($style->getAlignment()->getWrapText() ? 'true' : 'false'));
>             $objWriter->writeAttribute('shrinkToFit', ($style->getAlignment()->getShrinkToFit() ? 'true' : 'false'));




<         if ($pStyle->getAlignment()->getIndent() > 0) {
<             $objWriter->writeAttribute('indent', $pStyle->getAlignment()->getIndent());



>             if ($style->getAlignment()->getIndent() > 0) {
>                 $objWriter->writeAttribute('indent', (string) $style->getAlignment()->getIndent());


        }

<         if ($pStyle->getAlignment()->getReadOrder() > 0) {
<             $objWriter->writeAttribute('readingOrder', $pStyle->getAlignment()->getReadOrder());



>             if ($style->getAlignment()->getReadOrder() > 0) {
>                 $objWriter->writeAttribute('readingOrder', (string) $style->getAlignment()->getReadOrder());


        }
        $objWriter->endElement();

>         }



        // protection

<         if ($pStyle->getProtection()->getLocked() != Protection::PROTECTION_INHERIT || $pStyle->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {



>         if ($style->getProtection()->getLocked() != Protection::PROTECTION_INHERIT || $style->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {


            $objWriter->startElement('protection');

<             if ($pStyle->getProtection()->getLocked() != Protection::PROTECTION_INHERIT) {
<                 $objWriter->writeAttribute('locked', ($pStyle->getProtection()->getLocked() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));



>             if ($style->getProtection()->getLocked() != Protection::PROTECTION_INHERIT) {
>                 $objWriter->writeAttribute('locked', ($style->getProtection()->getLocked() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));


            }

<             if ($pStyle->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {
<                 $objWriter->writeAttribute('hidden', ($pStyle->getProtection()->getHidden() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));



>             if ($style->getProtection()->getHidden() != Protection::PROTECTION_INHERIT) {
>                 $objWriter->writeAttribute('hidden', ($style->getProtection()->getHidden() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));


            }
            $objWriter->endElement();
        }

        $objWriter->endElement();
    }

    /**
     * Write Cell Style Dxf.

<      *
<      * @param XMLWriter $objWriter XML Writer
<      * @param \PhpOffice\PhpSpreadsheet\Style\Style $pStyle Style


     */

<     private function writeCellStyleDxf(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style $pStyle)



>     private function writeCellStyleDxf(XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\Style\Style $style): void


    {
        // dxf
        $objWriter->startElement('dxf');

        // font

<         $this->writeFont($objWriter, $pStyle->getFont());



>         $this->writeFont($objWriter, $style->getFont());



        // numFmt

<         $this->writeNumFmt($objWriter, $pStyle->getNumberFormat());



>         $this->writeNumFmt($objWriter, $style->getNumberFormat());



        // fill

<         $this->writeFill($objWriter, $pStyle->getFill());



>         $this->writeFill($objWriter, $style->getFill());



        // alignment

>         $horizontal = Alignment::HORIZONTAL_ALIGNMENT_FOR_XLSX[$style->getAlignment()->getHorizontal()] ?? '';
        $objWriter->startElement('alignment');
>         $vertical = Alignment::VERTICAL_ALIGNMENT_FOR_XLSX[$style->getAlignment()->getVertical()] ?? '';
        if ($pStyle->getAlignment()->getHorizontal() !== null) {
>         $rotation = $style->getAlignment()->getTextRotation();
            $objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal());
>         if ($horizontal || $vertical || $rotation !== null) {



<         if ($pStyle->getAlignment()->getHorizontal() !== null) {
<             $objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal());



>             if ($horizontal) {
>                 $objWriter->writeAttribute('horizontal', $horizontal);



<         if ($pStyle->getAlignment()->getVertical() !== null) {
<             $objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical());



>             if ($vertical) {
>                 $objWriter->writeAttribute('vertical', $vertical);




<         if ($pStyle->getAlignment()->getTextRotation() !== null) {
<             $textRotation = 0;
<             if ($pStyle->getAlignment()->getTextRotation() >= 0) {
<                 $textRotation = $pStyle->getAlignment()->getTextRotation();
<             } elseif ($pStyle->getAlignment()->getTextRotation() < 0) {
<                 $textRotation = 90 - $pStyle->getAlignment()->getTextRotation();



>             if ($rotation !== null) {
>                 if ($rotation >= 0) {
>                     $textRotation = $rotation;
>                 } else {
>                     $textRotation = 90 - $rotation;


            }

<             $objWriter->writeAttribute('textRotation', $textRotation);



>                 $objWriter->writeAttribute('textRotation', (string) $textRotation);


        }
        $objWriter->endElement();

>         }



        // border

<         $this->writeBorder($objWriter, $pStyle->getBorders());



>         $this->writeBorder($objWriter, $style->getBorders());



        // protection

<         if (($pStyle->getProtection()->getLocked() !== null) || ($pStyle->getProtection()->getHidden() !== null)) {
<             if ($pStyle->getProtection()->getLocked() !== Protection::PROTECTION_INHERIT ||
<                 $pStyle->getProtection()->getHidden() !== Protection::PROTECTION_INHERIT) {



>         if ((!empty($style->getProtection()->getLocked())) || (!empty($style->getProtection()->getHidden()))) {
>             if (
>                 $style->getProtection()->getLocked() !== Protection::PROTECTION_INHERIT ||
>                 $style->getProtection()->getHidden() !== Protection::PROTECTION_INHERIT
>             ) {


                $objWriter->startElement('protection');

<                 if (($pStyle->getProtection()->getLocked() !== null) &&
<                     ($pStyle->getProtection()->getLocked() !== Protection::PROTECTION_INHERIT)) {
<                     $objWriter->writeAttribute('locked', ($pStyle->getProtection()->getLocked() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
<                 }
<                 if (($pStyle->getProtection()->getHidden() !== null) &&
<                     ($pStyle->getProtection()->getHidden() !== Protection::PROTECTION_INHERIT)) {
<                     $objWriter->writeAttribute('hidden', ($pStyle->getProtection()->getHidden() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));



>                 if (
>                     ($style->getProtection()->getLocked() !== null) &&
>                     ($style->getProtection()->getLocked() !== Protection::PROTECTION_INHERIT)
>                 ) {
>                     $objWriter->writeAttribute('locked', ($style->getProtection()->getLocked() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
>                 }
>                 if (
>                     ($style->getProtection()->getHidden() !== null) &&
>                     ($style->getProtection()->getHidden() !== Protection::PROTECTION_INHERIT)
>                 ) {
>                     $objWriter->writeAttribute('hidden', ($style->getProtection()->getHidden() == Protection::PROTECTION_PROTECTED ? 'true' : 'false'));


                }
                $objWriter->endElement();
            }
        }

        $objWriter->endElement();
    }

    /**
     * Write BorderPr.
     *

<      * @param XMLWriter $objWriter XML Writer
<      * @param string $pName Element name
<      * @param Border $pBorder Border style



>      * @param string $name Element name


     */

<     private function writeBorderPr(XMLWriter $objWriter, $pName, Border $pBorder)



>     private function writeBorderPr(XMLWriter $objWriter, $name, Border $border): void


    {
        // Write BorderPr

<         if ($pBorder->getBorderStyle() != Border::BORDER_NONE) {
<             $objWriter->startElement($pName);
<             $objWriter->writeAttribute('style', $pBorder->getBorderStyle());



>         if ($border->getBorderStyle() === Border::BORDER_OMIT) {
>             return;
>         }
>         $objWriter->startElement($name);
>         if ($border->getBorderStyle() !== Border::BORDER_NONE) {
>             $objWriter->writeAttribute('style', $border->getBorderStyle());



            // color

>             if ($border->getColor()->getARGB() !== null) {


            $objWriter->startElement('color');

<             $objWriter->writeAttribute('rgb', $pBorder->getColor()->getARGB());
<             $objWriter->endElement();
< 



>                 $objWriter->writeAttribute('rgb', $border->getColor()->getARGB());


            $objWriter->endElement();
        }
    }

>         $objWriter->endElement();

>     }


    /**
     * Write NumberFormat.
     *

<      * @param XMLWriter $objWriter XML Writer
<      * @param NumberFormat $pNumberFormat Number Format
<      * @param int $pId Number Format identifier



>      * @param int $id Number Format identifier


     */

<     private function writeNumFmt(XMLWriter $objWriter, NumberFormat $pNumberFormat, $pId = 0)



>     private function writeNumFmt(XMLWriter $objWriter, ?NumberFormat $numberFormat, $id = 0): void


    {
        // Translate formatcode

<         $formatCode = $pNumberFormat->getFormatCode();



>         $formatCode = ($numberFormat === null) ? null : $numberFormat->getFormatCode();



        // numFmt
        if ($formatCode !== null) {
            $objWriter->startElement('numFmt');

<             $objWriter->writeAttribute('numFmtId', ($pId + 164));



>             $objWriter->writeAttribute('numFmtId', (string) ($id + 164));


            $objWriter->writeAttribute('formatCode', $formatCode);
            $objWriter->endElement();
        }
    }

    /**
     * Get an array of all styles.
     *

<      * @param Spreadsheet $spreadsheet
<      *


     * @return \PhpOffice\PhpSpreadsheet\Style\Style[] All styles in PhpSpreadsheet
     */
    public function allStyles(Spreadsheet $spreadsheet)
    {
        return $spreadsheet->getCellXfCollection();
    }

    /**
     * Get an array of all conditional styles.
     *

<      * @param Spreadsheet $spreadsheet
<      *


     * @return Conditional[] All conditional styles in PhpSpreadsheet
     */
    public function allConditionalStyles(Spreadsheet $spreadsheet)
    {
        // Get an array of all styles
        $aStyles = [];

        $sheetCount = $spreadsheet->getSheetCount();
        for ($i = 0; $i < $sheetCount; ++$i) {
            foreach ($spreadsheet->getSheet($i)->getConditionalStylesCollection() as $conditionalStyles) {
                foreach ($conditionalStyles as $conditionalStyle) {
                    $aStyles[] = $conditionalStyle;
                }
            }
        }

        return $aStyles;
    }

    /**
     * Get an array of all fills.
     *

<      * @param Spreadsheet $spreadsheet
<      *


     * @return Fill[] All fills in PhpSpreadsheet
     */
    public function allFills(Spreadsheet $spreadsheet)
    {
        // Get an array of unique fills
        $aFills = [];

        // Two first fills are predefined
        $fill0 = new Fill();
        $fill0->setFillType(Fill::FILL_NONE);
        $aFills[] = $fill0;

        $fill1 = new Fill();
        $fill1->setFillType(Fill::FILL_PATTERN_GRAY125);
        $aFills[] = $fill1;
        // The remaining fills
        $aStyles = $this->allStyles($spreadsheet);
        /** @var \PhpOffice\PhpSpreadsheet\Style\Style $style */
        foreach ($aStyles as $style) {
            if (!isset($aFills[$style->getFill()->getHashCode()])) {
                $aFills[$style->getFill()->getHashCode()] = $style->getFill();
            }
        }

        return $aFills;
    }

    /**
     * Get an array of all fonts.
     *

<      * @param Spreadsheet $spreadsheet
<      *


     * @return Font[] All fonts in PhpSpreadsheet
     */
    public function allFonts(Spreadsheet $spreadsheet)
    {
        // Get an array of unique fonts
        $aFonts = [];
        $aStyles = $this->allStyles($spreadsheet);

        /** @var \PhpOffice\PhpSpreadsheet\Style\Style $style */
        foreach ($aStyles as $style) {
            if (!isset($aFonts[$style->getFont()->getHashCode()])) {
                $aFonts[$style->getFont()->getHashCode()] = $style->getFont();
            }
        }

        return $aFonts;
    }

    /**
     * Get an array of all borders.
     *

<      * @param Spreadsheet $spreadsheet
<      *


     * @return Borders[] All borders in PhpSpreadsheet
     */
    public function allBorders(Spreadsheet $spreadsheet)
    {
        // Get an array of unique borders
        $aBorders = [];
        $aStyles = $this->allStyles($spreadsheet);

        /** @var \PhpOffice\PhpSpreadsheet\Style\Style $style */
        foreach ($aStyles as $style) {
            if (!isset($aBorders[$style->getBorders()->getHashCode()])) {
                $aBorders[$style->getBorders()->getHashCode()] = $style->getBorders();
            }
        }

        return $aBorders;
    }

    /**
     * Get an array of all number formats.

<      *
<      * @param Spreadsheet $spreadsheet


     *
     * @return NumberFormat[] All number formats in PhpSpreadsheet
     */
    public function allNumberFormats(Spreadsheet $spreadsheet)
    {
        // Get an array of unique number formats
        $aNumFmts = [];
        $aStyles = $this->allStyles($spreadsheet);

        /** @var \PhpOffice\PhpSpreadsheet\Style\Style $style */
        foreach ($aStyles as $style) {
            if ($style->getNumberFormat()->getBuiltInFormatCode() === false && !isset($aNumFmts[$style->getNumberFormat()->getHashCode()])) {
                $aNumFmts[$style->getNumberFormat()->getHashCode()] = $style->getNumberFormat();
            }
        }

        return $aNumFmts;
    }
}