Sign in to follow this  
Followers 0
ray306

_ExcelCom_UDF for LocoDarwin (possible bug)

1 post in this topic

#1 ·  Posted (edited)

Hi:

It would appear that I am having a problem with getting the _ExcelCellColorSet function to set the proper RGB hex value colors in the spreadsheet. The following code should set the cell color to blue as the hex value for blue is 0x0000ff. What happens instead is that it sets the cell color to red whose hex value is 0xff0000.?????

CODE
Case $DataArray[$innerCounter][$temp]=1

_ExcelCellColorSet($oExcel, $x, 1, $x, 1, 256, 0x0000ff)

As you can see I set the $iColorIndex value to 256 to force it to use the hex values. I quickly figured out that the value needed to get the reqired colors entailed reversing the hex values from RGB to BRG. Is it supposed to work this way? I was under the impression the RGB was the standard.

Thanks so much for _ExcelCom_UDF it has been invaluable to me, great library of functions.

Thanks

Ray

Edited by ray306

Share this post


Link to post
Share on other sites



Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0