This project has moved and is read-only. For the latest updates, please go here.

Cannot convert theme color to color

Nov 1, 2016 at 3:29 PM
Edited Nov 1, 2016 at 3:30 PM
Hi everyone,
I'm new to CLosedXML and so far it seems really interesting. However I have a problem that I cannot solve... Basically, what I'm doing, is opening an Excel file (with some layout and colors already applied) and fill it with data. In my code, I only enter data and formulas. I don't apply any cell formatting except from centering some data. However, when I save the workbook, I get the error "Cannot convert theme color to Color". I suspect the problems come from the file that I open or a bug in ClosedXML because if I open the file and immediately save it, I still have the same error on save. Any ideas about what could be the problem or if anything should be changed in the source file (through Excel)? By the way, I have no problem opening the source file in Excel...

I'm using VB.NET in Visual Studio 2015 if it helps.