Implement the $book->set_custom_color() function from the Perl library in the C library about libxlsxwriter HOT 2 CLOSED

I'll have a look at it soon.

from libxlsxwriter.

I finally got around to looking at this feature request and unfortunately it isn't feasible in the C version of the library.

A long time time ago, I implemented the set_custom_color() method in Excel::Writer::XLSX version to account for similar functionality in the my older XLS writing Spreadsheet::WriteExcel library. It was necessary in the older version because Excel had a limited color palette of ~ 64 colors and that was the only way to change them.

However in the XLSX format Excel supported 16 million RGB colors so that form of custom color functionality was no longer required. As a result I didn't port it to any of the subsequent Python, C or Rust libraries. And at this point in time it doesn't make sense to retrofit it. Sorry about that.

As a workaround you could possibly use named variables for each color you need and modify the RGB value based on the customer.

Closing as won't fix

from libxlsxwriter.