Setting HSSFColor via RGB Does Not Work

[dotnetcore]

Setting HSSFColor via RGB Does Not Work

[yang-xiaodong]

This is not a bug.

Each Microsoft Excel workbook has a palette of 56 colors that you can apply to cells, fonts, gridlines, graphic objects, and fills and lines in a chart.

see:
http://dmcritchie.mvps.org/excel/colors.htm
https://msdn.microsoft.com/en-us/vba/excel-vba/articles/colorindex-property

In NPOI, the color index are from 0x8 to 0x40

[diogoan]

Sorry for asking this here (I don't know if this is the proper place to ask questions), but there's no way to set a custom RGB color into an XSSFColor object? We are restricted to the 56 colors of default Excel palette?

[Grandizer]

Understood. Thank you.

[esreeves]

This seems to be more of a limitation of the library. You are able to set custom colors within excel why are you not able to do it with this library. Maybe this should be reopened and tagged as a feature request?