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

transparent color

Mar 29, 2011 at 12:56 AM

Hi

how i can set the backgroundcolor of a cell to a transparent color?

Coordinator
Mar 29, 2011 at 3:29 AM

You've just uncovered a bug in the library. Even though Excel doesn't really support a transparent background color you should be able to set the background to nothing or its equivalent. I'll work on it.

Thanks,

Coordinator
Mar 29, 2011 at 3:30 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Coordinator
Mar 29, 2011 at 3:56 PM

My bad, you can get the "transparent color" by setting the pattern type to none.
ws.Cell(1, 1).Style.Fill.PatternType = XLFillPatternValues.None;

I still need to resolve something with the default color but that's another issue .

Mar 29, 2011 at 7:09 PM

thanks, your work is so good