Jump to content
Sign in to follow this  

_ExcelCom_UDF for LocoDarwin (possible bug)

Recommended Posts


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.?????

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.



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  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...