This project has moved. For the latest updates, please go here.

Bug with OpenXML

Nov 15, 2012 at 8:49 PM
Edited Nov 15, 2012 at 8:52 PM

I have a column range that is formatted when a different column is 1 to be non-Bold and no background fill using conditional formatting.  After opening this template spreadsheet in OpenXML and saving it after filling in data.  The file when opened in excel has changed the conditional format to BOLD and a background fill similar to a prior row condition on same range.    When debugging the worksheet conditional formatting settings are all correct even at time of saving.  But when opening the file it is wrong.  

 

Pleease help.  At a loss at what to try.   This problem is a non-Starter for using ClosedXML for us.

 

=$Z24<>1  Is the formula.  

The previous formula in list for same range is highlighting background fill and Bold for cells containing OFFER.  For some reason this guys formatting is showing up in the other formulas formatting.

Coordinator
Nov 15, 2012 at 9:04 PM

Create an issue and attach a sample project that reproduces the error.