ClosedXML / ClosedXML/ClosedXML.Report

Conditionnal formating lost in Pivot table

Open
#294 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
647
Forks
122
PR merge metrics
No merged PRs in 30d

Description

Hello,

I've been trying to create an Excel Pivot Table based on a Flat List. It's working great, however in one of my cells, I've declared a conditionnal formatting to display a bar based on the value of the cell.

![image](https://user-images.githubusercontent.com/24409754/206741439-88d36e58-cbcd-4007-a8d3-523df7749b7a.png)

When my file is generated, the conditionnal formatting is not kept :
![image](https://user-images.githubusercontent.com/24409754/206741605-f040f95a-e2a6-448a-8f4f-9010f68d438e.png)

Expected result :

![image](https://user-images.githubusercontent.com/24409754/206741716-cdac0992-95f7-4895-99ea-692eacd8c311.png)

The template file used :
[Template](https://github.com/ClosedXML/ClosedXML.Report/files/10196106/test.xlsx)

The rendered file :
[Rendered file](https://github.com/ClosedXML/ClosedXML.Report/files/10196108/20221209164226259.xlsx)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.