Skip to content
This repository was archived by the owner on Jan 2, 2019. It is now read-only.

gradientFill  #317

Open
Open
@CiTRO33

Description

@CiTRO33

Hello,
if i create an Excelsheet (Excel2010) with filled Background like the image below
.
background
style

Load this sheet with this code:

$objReader = new PHPExcel_Reader_Excel2007 ();
$excel = $objReader->load ( "excel_file.xlsx" );

... do nothing ...

$objWriter = new PHPExcel_Writer_Excel2007 ( $excel );
$objWriter->save ( "newname.xlsx");

The backgroundStyle are moving away.

    <fill>
        <gradientFill degree="45">
            <stop position="0">
                <color theme="0"/>
            </stop>
            <stop position="0.5">
                <color theme="4"/>
            </stop>
            <stop position="1">
                <color theme="0"/>
            </stop>
        </gradientFill>
    </fill>

In the SourceCode i found: (Reader/Excel2007.php)

$docStyle->getFill()->getStartColor()->setARGB(self::_readColor( self::array_item($gradientFill->xpath("sml:stop[@position=0]"))->color) );
            $docStyle->getFill()->getEndColor()->setARGB(self::_readColor( self::array_item($gradientFill->xpath("sml:stop[@position=1]"))->color) );

maybe someone can fix this.

Thanks in advance.
Greetings

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions