I'm trying to create some custom colors to use in my formatting objects for a
spreadsheet I'm developing with cfspreadsheet. According to to POI docs, you
can do something like this to achieve a custom color:
<cfscript>
excel = spreadsheetnew("My Worksheet",false);
palette = excel.getworkbook().getcustompalette();
palette.setcoloratindex(41,218,218,218);
</cfscript>
http://poi.apache.org/spreadsheet/quick-guide.html#CustomColors
When I try this, I get an out-of-bounds error for the bytes I'm trying to pass
into the method:
"The cause of this exception was that:
coldfusion.runtime.Cast$OutOfBoundsException: Cannot convert the value 218.0 to
byte because it cannot fit inside a byte."
Same results when I simply try to do a straight javacast() to byte on the value
218.
This error, of course, is not unexpected, since the Java docs clearly state
that the max size of a byte is 127.
So my question is, how do I achieve a custom color with RGB values above 127?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338461
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
