[Solved] RGB Function odd results
- BratcheGeige
- Posts: 11
- Joined: Thu Oct 10, 2019 6:02 pm
[Solved] RGB Function odd results
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?
Last edited by Hagar Delest on Tue Oct 15, 2019 9:58 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
OpenOffice 4.1.7
MacOS 10.15 Catalina
MacOS 10.15 Catalina
Re: RGB Function odd results
Can you upload your sample file here?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
- BratcheGeige
- Posts: 11
- Joined: Thu Oct 10, 2019 6:02 pm
Re: RGB Function odd results
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.
- Attachments
-
- BooksForOpenOffice.ods
- (33.84 KiB) Downloaded 173 times
OpenOffice 4.1.7
MacOS 10.15 Catalina
MacOS 10.15 Catalina
Re: RGB Function odd results
Option VBASupport 1
seems to corrupt it
seems to corrupt it
Win7 Pro, Lubuntu 15.10, LO 4.4.7, OO 4.1.3
Free Project: LibreOffice Songbook Architect (LOSA)
http://struckkai.blogspot.de/2015/04/li ... itect.html
Free Project: LibreOffice Songbook Architect (LOSA)
http://struckkai.blogspot.de/2015/04/li ... itect.html
Re: RGB Function odd results
My LibreOffice 6.1.6 gives me different result too...
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: RGB Function odd results
Give it another nameBratcheGeige wrote:Can someone tell me how to force the use of my new definition?
Win7 Pro, Lubuntu 15.10, LO 4.4.7, OO 4.1.3
Free Project: LibreOffice Songbook Architect (LOSA)
http://struckkai.blogspot.de/2015/04/li ... itect.html
Free Project: LibreOffice Songbook Architect (LOSA)
http://struckkai.blogspot.de/2015/04/li ... itect.html
- BratcheGeige
- Posts: 11
- Joined: Thu Oct 10, 2019 6:02 pm
Re: RGB Function odd results
Thank you musikai!
When I erased
Option VBASupport 1
RGB() works correctly.
When I erased
Option VBASupport 1
RGB() works correctly.
OpenOffice 4.1.7
MacOS 10.15 Catalina
MacOS 10.15 Catalina