Excel Comments blacked out

Topics: Developer Forum, User Forum
May 2, 2011 at 3:24 PM

I am reading in a spreadsheet file, setting a few text values, then writing out the resulting file.  The input files are .xlsx.  The basic procedure is very simple - read in the file, change about a dozen text values, and then output the file as an xlsx.

The input files can be quite complicated, with conditional formatting, 

When I open the resulting output, everything is there but any comments which were in the original now have a black background.

How do I fix this?

I can supply example input files if it helps.