using ClosedXML.Report;
var data = new
{
Directors = new[]
{
new { Director = "Steven Spielberg", Movie = "Jaws" },
new { Director = "Quentin Tarantino", Movie = "Pulp Fiction" },
new { Director = "Steven Spielberg", Movie = "E.T." },
new { Director = "Quentin Tarantino", Movie = "" },
new { Director = "Steven Spielberg", Movie = "Jurassic Park" },
new { Director = "Quentin Tarantino", Movie = "" },
new { Director = "Steven Spielberg", Movie = "Indiana Jones" },
},
Genres = new[]
{
new { Movie = "Jaws", Genre = "Thriller" },
new { Movie = "Pulp Fiction", Genre = "" },
new { Movie = "E.T.", Genre = "Sci-Fi" },
new { Movie = "Kill Bill", Genre = "" },
new { Movie = "Jurassic Park", Genre = "Sci-Fi" },
new { Movie = "Reservoir Dogs", Genre = "Thriller" },
new { Movie = "Indiana Jones", Genre = "" },
new { Movie = "E.T.", Genre = "Family" },
new { Movie = "Jaws", Genre = "Horror" },
},
Actors = new[]
{
new { Movie = "Jaws", Actor = "Roy Scheider" },
new { Movie = "Pulp Fiction", Actor = "John Travolta" },
new { Movie = "E.T.", Actor = "" },
new { Movie = "E.T.", Actor = "Henry Thomas" },
new { Movie = "Kill Bill", Actor = "" }
},
};
void GenerateWithClosedXML()
{
const string outputFile = "./output.xlsx";
var template = new XLTemplate(@"./repro-template-broken.xlsx");
// var template = new XLTemplate(@"./repro-template-working.xlsx");
template.AddVariable(data);
template.Generate();
template.SaveAs(outputFile);
}
GenerateWithClosedXML();
Repro steps:
Run attached code
Observe conditional formatting is applied in wrong place
Results:
Template should color the cell in red if value is empty:
However after generating the output conditional formatting breaks for the second table:
Note: if the gap between tables is more than 4 lines conditional formatting is applied correctly (as seen in repro-template-working.xlsx)
Conditional formatting breaks when used inside template with multiple tables one after the other.
Template broken: repro-template-broken.xlsx
Template working: repro-template-working.xlsx
Code:
Repro steps:
Results: Template should color the cell in red if value is empty:![image](https://github.com/ClosedXML/ClosedXML.Report/assets/67858373/fec6a3ce-d657-4f0d-8ace-5dd478902620)
However after generating the output conditional formatting breaks for the second table:![image](https://github.com/ClosedXML/ClosedXML.Report/assets/67858373/cd2592c1-8ae5-46ee-bfb5-56133864f999)
Note: if the gap between tables is more than 4 lines conditional formatting is applied correctly (as seen in repro-template-working.xlsx)