visio colors to RGB

perry59 · October 03, 2019, 02:05:48 AM

I am trying to implement a color combo box like the one in visio's layer dialog.

Rather than using RGB like everyone else does visio is associating colors with just one number, i.e. "0" is black (RGB 0,0,0) and it seems you are limited to 256 colors (0-255).

When I put color swatches in the dialog box I'm using RGB values but when a user picks one I need to translate that to just one number which will be put into a layers color cell.

How do I go about doing that? some colors are obvious but others are not. Say for example a user pics "crimson" from the dialog box which is RGB 220,20,60 what visio color number does that represent?

Has anyone made a nifty color chart with visio's color numbers and their corresponding RGB values?

Also, this implies that only 256 colors are available to visio, what happens if a user picks a color from a color picker that is beyond that?

Thanks

Surrogate · October 03, 2019, 04:54:20 AM

May be this workbook by John Marshall can be helpful?

wapperdude · October 03, 2019, 02:34:33 PM

Visio takes RGB colors, always has.

Selecting color on a layer, colors the outline, but forces the fill to be white. If you want to have the fill match the outline, possible, but requires extra steps. See video by Surrogate, https://www.youtube.com/watch?v=VrLEUiokFAE

perry59 · October 04, 2019, 12:35:13 PM

Quote from: Surrogate on October 03, 2019, 04:54:20 AM
May be this workbook by John Marshall can be helpful?

interesting spreadsheet, he put a lot of work into that

perry59 · October 04, 2019, 12:38:22 PM

Quote from: wapperdude on October 03, 2019, 02:34:33 PM
Visio takes RGB colors, always has.

Selecting color on a layer, colors the outline, but forces the fill to be white. If you want to have the fill match the outline, possible, but requires extra steps. See video by Surrogate, https://www.youtube.com/watch?v=VrLEUiokFAE

If I go into a shapesheet, the layers section, and put an RGB value into a color cell, I get an error. If I surround that value with quotes, I get black. Apparently my visio does not take RGB colors.

Surrogate · October 04, 2019, 12:57:34 PM

Quote from: perry59 on October 04, 2019, 12:38:22 PM
Apparently my visio does not take RGB colors.

Which version of Visio do you use ? English or non-English language pack ?

Paul Herber · October 04, 2019, 01:38:53 PM

=RGB(255,0,0) works fine here.

perry59 · October 04, 2019, 03:39:01 PM

Quote from: Paul Herber on October 04, 2019, 01:38:53 PM
=RGB(255,0,0) works fine here.

THAT worked!
Thank you, it will greatly simplify things!
(I did not precede the value with "RGB")