Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

NPOI removes background color from conditional formattings #186

Closed
claasd opened this issue Mar 13, 2019 · 2 comments
Closed

NPOI removes background color from conditional formattings #186

claasd opened this issue Mar 13, 2019 · 2 comments

Comments

@claasd
Copy link

claasd commented Mar 13, 2019

Hi,

I am having an issue with NPOI removing background colors from my conditional formattings when reading and writing XLSX files.

I am using Version 2.4.1. When using the following code on my Excel document, the background colors of conditional formattings are removed (foreground colors and borders are preservered):

IWorkbook workbook;
using (var fs = new FileStream("input.xlsx", FileMode.Open, FileAccess.Read))
{
    workbook = new XSSFWorkbook(fs);
}
using (var fs = new FileStream("output.xlsx", FileMode.Create, FileAccess.Write))
{
    workbook.Write(fs);
}

Here are my test documents:

input.xlsx
output.xlsx

Thanks,
Claas

@tonyqus
Copy link
Member

tonyqus commented May 30, 2021

@claasd sorry, I figure out what's going on. It's not your fault. I'll ask github team to handle this case and see if we can block @cn00 as a punishment.

@tonyqus
Copy link
Member

tonyqus commented May 30, 2021

@claasd Looks I can reproduce it with NPOI 2.5.3. I'll investigate this issue. Thank you for your report

@tonyqus tonyqus added this to the NPOI 2.5.5 milestone May 30, 2021
@tonyqus tonyqus modified the milestones: NPOI 2.5.5, NPOI 2.5.4 Jul 5, 2021
# for free to join this conversation on GitHub. Already have an account? # to comment
Projects
None yet
Development

No branches or pull requests

2 participants