[Solved] RGB Function odd results

Issues installing under the Mac OSX - X11 - Aqua

[Solved] RGB Function odd results

Postby 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?
Last edited by Hagar Delest on Tue Oct 15, 2019 9:58 pm, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.7
MacOS 10.15 Catalina
User avatar
BratcheGeige
 
Posts: 11
Joined: Thu Oct 10, 2019 6:02 pm

Re: RGB Function odd results

Postby Zizi64 » Sat Oct 12, 2019 1:17 pm

Can you upload your sample file here?
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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.
User avatar
Zizi64
Volunteer
 
Posts: 9580
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: RGB Function odd results

Postby 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.
Attachments
BooksForOpenOffice.ods
(33.84 KiB) Downloaded 42 times
OpenOffice 4.1.7
MacOS 10.15 Catalina
User avatar
BratcheGeige
 
Posts: 11
Joined: Thu Oct 10, 2019 6:02 pm

Re: RGB Function odd results

Postby musikai » Sat Oct 12, 2019 2:31 pm

Option VBASupport 1

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/libreofficesongbookarchitect.html
musikai
Volunteer
 
Posts: 282
Joined: Wed Nov 11, 2015 12:19 am

Re: RGB Function odd results

Postby Zizi64 » Sat Oct 12, 2019 2:48 pm

My LibreOffice 6.1.6 gives me different result too...
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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.
User avatar
Zizi64
Volunteer
 
Posts: 9580
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: RGB Function odd results

Postby 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
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/libreofficesongbookarchitect.html
musikai
Volunteer
 
Posts: 282
Joined: Wed Nov 11, 2015 12:19 am

Re: RGB Function odd results

Postby BratcheGeige » Tue Oct 15, 2019 12:08 pm

Thank you musikai!
When I erased
Option VBASupport 1
RGB() works correctly.
OpenOffice 4.1.7
MacOS 10.15 Catalina
User avatar
BratcheGeige
 
Posts: 11
Joined: Thu Oct 10, 2019 6:02 pm


Return to Mac OSX

Who is online

Users browsing this forum: No registered users and 3 guests