[Solved] RGB Function odd results

BratcheGeige · Post by **BratcheGeige** » Sat Oct 12, 2019 12:07 pm

The RGB(R, B, G) function should be very simple just returning R * 256 * 256 + G *256 + B. But on three of my documents (originally excel files but now saved as .ods) RGB(R, G, B) returns a reversed result as if I had written RGB(B, G, R). Can anyone explain this odd behaviour? I tried redefining it myself in my My Macros & Dialogs Library hoping my new definition would be referenced. No luck. Can someone tell me how to force the use of my new definition?

Post by **Zizi64** » Sat Oct 12, 2019 1:17 pm

Can you upload your sample file here?

BratcheGeige · Post by **BratcheGeige** » Sat Oct 12, 2019 2:03 pm

I have cut out most of my data (over 2000 lines) and cut out all my buttons and code and just left the RGB test. It still doesn't work. See the attachment.

musikai · Post by **musikai** » Sat Oct 12, 2019 2:31 pm

Option VBASupport 1

seems to corrupt it

Post by **Zizi64** » Sat Oct 12, 2019 2:48 pm

My LibreOffice 6.1.6 gives me different result too...

musikai · Post by **musikai** » Sat Oct 12, 2019 7:56 pm

BratcheGeige wrote:Can someone tell me how to force the use of my new definition?

Give it another name

BratcheGeige · Post by **BratcheGeige** » Tue Oct 15, 2019 12:08 pm

Thank you musikai!
When I erased
Option VBASupport 1
RGB() works correctly.

[Solved] RGB Function odd results

[Solved] RGB Function odd results

Re: RGB Function odd results

Re: RGB Function odd results

Re: RGB Function odd results

Re: RGB Function odd results

Re: RGB Function odd results

Re: RGB Function odd results