Upgrade phpoffice/phpspreadsheet from ~1.3.1 to ^1.5.2

[kgilden]

The version of phpoffice/phpspreadsheet should be bumped to fix CVE-2018-19277.

Fixes #18.

[kgilden]

@MewesK hi, do you think we could move forward with this PR?

[xarem]

Ping @MewesK would be nice if you could merge that one.

[kgilden]

In the meantime you could modify your composer.json as follows.

{
    "require": {
        "mewesk/twig-spreadsheet-bundle": "dev-upgrade-spreadsheet#fc1b231"
    },
    "repositories": [
        {
            "type": "vcs",
            "url":  "https://github.com/kgilden/twig-spreadsheet-bundle.git"
        }
    ]
}

Running composer update mewesk/twig-spreadsheet-bundle --with-dependencies should do the trick.

[jamalo]

https://github.com/MyWheels/TwigSpreadsheetBundle uses PhpSpreadsheet 1.6.0! you can use that one until @MewesK is active again. @kgilden @xarem

composer require mywheels/twig-spreadsheet-bundle

[geoff-maddock]

Curious to use this package, but not ready to with these old outstanding pulls. Anyone look at this lately?

[davidromani]

@MewesK can you apply this PR, please?

[JSortGarcia]

@MewesK Waiting for the update, please!

[davidromani]

@kgilden @jamalo at some point, after replacing the original vendor by your forks (both) my excel Twig template stopped to fill background colors and border styles.

Is there any problem with this code?

{% xlscell {
                merge: 9,
                style: {
                    borders: {
                        bottom: {
                            style: 'thin',
                            color: {
                                rgb: 'FF0000'
                            }
                        }
                    },
                    fill:
                       type: 'solid',
                       color:
                             rgb: 'D9E2F2'
                       }
                    }
                }
} %} 
    some text cell
{% endxlscell %}

Is related with the phpoffice/phpspreadsheet update?

Any hint, please?

[kgilden]

Is related with the phpoffice/phpspreadsheet update?

Any hint, please?

@davidromani not sure. You could try downgrading by adding "phpoffice/phpspreadsheet": "^1.5.2,<1.6" to your composer.json (or something similar, wrote off top of my head).

[davidromani]

@kgilden for me it's solved, was my mess reading a wrong documentation version. My apologies.