respect conditional formatting in excel export

[sischi]

Hi there,

another small improvement for the excel export. This one respects the conditional formatting that you can set in excel.

Here we calculate the cell range of the generated data (those cells that replace the ${data} placeholder) to apply all conditional formattings set in the target sheet of the template to this range.

I added some conditional formattings to the custom-template.xlsx to present some examples in the demo.

Hope to see this extension in any future release, too.

Best regards

[sonarcloud[bot]]

Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

No Coverage information
0.0% Duplication

[javier-godoy]

Thanks for your contribution. Both PRs have been merged to 2.1.0-SNAPSHOT, which is available from our snapshot repository. The online demo is available at https://addonsv24-staging.flowingcode.com/gridexporter/hierarchical (Note that version 2 of the add-on requires Vaadin 24).

The snapshot repository is:

        <repository>
            <id>flowing-snapshots</id>
            <url>https://maven.flowingcode.com/snapshots</url>
        </repository>

We'll release it soon after addressing some other outstanding issues.

[sischi]

Good to see, that my extensions are already merged. We will use the snapshot builds until a new version will be released.

Thanks for the quick review!