InfoQube IM - Community

Submitted by reesd on 2011/04/22 20:02

Hi all, I finally got sick enough of VB Hex Codes to do something about it.

I wrote an excel spreadsheet that generates IQ NamedColors (in the wacky reversed VB hex code format) for the HTML/CSS/X11 Color Set. That gives us 142 pretty colors to play with! It's at Web Named Colors.

And while I was posting, I decided to refactor the two pages on item and conditional formatting into one. See Item Formatting for the combined result (-- link to nonexistent node ID 1169 -- is now just a link to it). The formatting probably needs work, but the original conditional formatting article was formatted weird (native HTML?) and I just couldn't take the pain of try to fix it any further.

Comments

Darn, I missed overlapping another color-related page (Embedded Formatting).

Well, I spent too much time on this color thing so I don't have time to adjust that one. Maybe someone else or I will look at it in the future.

For now I will just add some links between them for now.

[quote=reesd]

Darn, I missed overlapping another color-related page (Embedded Formatting).

Well, I spent too much time on this color thing so I don't have time to adjust that one. Maybe someone else or I will look at it in the future.

For now I will just add some links between them for now.

[/quote]

I'm not sure what you mean by overlapping (link?) but I see you did edit it (thanks!) so that's probably done.

I did edit it myself - but only to make minor formatting changes.

[quote=Tom]

[quote=reesd]

Darn, I missed overlapping another color-related page (Embedded Formatting).

Well, I spent too much time on this color thing so I don't have time to adjust that one. Maybe someone else or I will look at it in the future.

For now I will just add some links between them for now.

[/quote]

I'm not sure what you mean by overlapping (link?) but I see you did edit it (thanks!) so that's probably done.

I did edit it myself - but only to make minor formatting changes.

[/quote]

I just meant there was some duplicated/related content between them. I brought them all into one page to eliminate that content, though longer term it might make sense to make them subsections.

[quote=reesd]I wrote an excel spreadsheet that generates IQ NamedColors (in the wacky reversed VB hex code format) for the HTML/CSS/X11 Color Set. That gives us 142 pretty colors to play with! It's at Web Named Colors.[/quote]

I was unable to open the file (in GoogleDocs or Softmaker 2010) but just copied and pasted your list of colours - they show nicely in the context menu.

Today, I wanted to use one of the colours (the bright yellow &H00FFFF) as the "Selected item's background colour" (Options 1.2.3) but it doesnt work there.

Does anyone know if this is a bug or do I need a different format again for that colour?

Entered manually in options.ini, &H00FFFF works. Using the options dialog, you can select from the supplied list. You'll notice that there is an extra 00, to support system colors...

[quote=Pierre_Admin]

Entered manually in options.ini, &H00FFFF works. Using the options dialog, you can select from the supplied list. You'll notice that there is an extra 00, to support system colors...[/quote]

thanks Pierre,

I'm not having a good day - I missed out on the drop-down arrow - the yellow I wanted was in there all along.

(I'm running out of colours so I wanted to use a gaudy one for selection.)

OK, I hate to be so dense.

I read all the referenced pages here, including wikipedia

I d/l the zipped HTMLcolors file

I see user can insert daves' ready made line somewhere so the new color defunitions can be used

but

I don't know where the zipped file goes

I don't understand where the ready made line to get it ll to work goes

Can someone take this poor boy by the hand & lead him down the path of understanding?

Thank you.

Jan,you don't need the zip file, other than to extract it's contents

Just:

1) unzip the file

2) double click the unzipped htmlColors.xlsm to see a worksheet with instructions.

3) from that excel worksheet, copy cell G2 (the orange line)

4) in InfoQube: tools>options>General (2.1.4), and paste (the orange line on the clipboard)

[quote=KeithB]

Jan,you don't need the zip file, other than to extract it's contents

...

4) in InfoQube: tools>options>General (2.1.4), and paste (the orange line on the clipboard)

[/quote]

In fact you don't even need the zip file at all. I have the actual line you need to copy right in Web Named Colors. Just copy the long line starting with "IndianRed" and then follow KeithB's step 4.

here's the ones I found helpful (I'm not using all of these) - others were either too dark or too light (or I missed them...)

Thanks for sharing, Tom ! I'll definitely use those.

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz