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

transparent color

Mar 29, 2011 at 1:56 AM

Hi

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

Mar 29, 2011 at 4: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,

Mar 29, 2011 at 4:30 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Mar 29, 2011 at 4: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 8:09 PM

thanks, your work is so good