Submitted by WayneK on 2015/10/12 15:56
Hello everyone.  I don't know whether this is a bug or user ignorance.  I'm trying to change the font color of a text column.  I've tried the following:
 
1) Field Properties>  (No font settings here)
2) Column>  (No font settings here)
3) Right click column>Font color on toolbar.
 
I thought the last one had to be it but after changing the color, my text in the column remained black.  Oddly, if I double click the text to edit, THEN it changes to the selected color, but as soon as I leave the cell, it reverts to black.
 
I also tried refreshing the grid and restarting IQ but the font still won't change color.
 
Thanks,
Wayne

Comments

Hi Wayne,
 
There is currently no setting for Field font and backcolor, neither is there one for columns. It is not a bad idea though and can certainly be implemented should users request it.
 
There is a setting for the grid as a whole and a per item setting. The item font/color is shown in grids following a grid setting (Grid properties > Options > Item Font / Color applies to fields: List of fields or leave blank to have the setting applied to the whole line)
 
 
-----------

In InfoQube, outline formatting is structured as a hierarchy. In increasing order of precedence, these are:

  1. Overall default font: set in Tools>Options>General>View: Grid font and Grid font size settings
  2. Grid specific font: set in Grid>Properties>Options: Default Font
  3. Item font: Applies to the whole item or to specific columns, as defined in Grid>Properties>Options: Item Font applies to field
  4. In-cell format: Applied to text selections inside cells only
  5. Conditional formats are discussed here: 3.2.30 Item Coloring and Formatting (node 219)
-----------

WayneK

2015/10/12 16:41

Permalink

Thanks, Pierre.  Maybe someone else will think it's a good idea.  Here's how I'm using it.
 
I have a column for original text copied from my source.  To the right of that, I have a text column for my comments on the original text.  It really helps keep the material separate if you can make the fonts different colors.  I wouldn't even mind doing it manually for each cell.
 
Wayne
 
 
 
 
Wayne
Win 7, 64 bit Cyberpower Model 1, C Series (2011) 16 GB RAM
27" Samsung S27A350H, 24" ASUS VW242H  1920x1080

Pierre_Admin

2015/10/12 16:54

Permalink

You could use conditional formatting to format your column (in waiting for a column or field setting)
 

WayneK

2015/10/12 16:58

Permalink

Yes, I was just going to come back and ask if conditional formatting could be used to accomplish what I want.  Let me see what I can figure out and I'll come back if I get stuck.  Thanks.
 
 
Wayne
Win 7, 64 bit Cyberpower Model 1, C Series (2011) 16 GB RAM
27" Samsung S27A350H, 24" ASUS VW242H  1920x1080

WayneK

2015/10/12 23:58

Permalink

Really don't know what the purpose of the font color tool is now.  Earlier, I thought I'd learned that if you select a column, then select a different font color (eg blue), then whenever you enter edit mode, the text of that cell turns to the selected color (blue).  I confirmed that repeatedly earlier and was sure that was how it worked.
 
So just now I went to set it again only this time it doesn't work like it did before.  It does not change the cell text blue when you enter edit mode.  The color remains black.  Instead, the color of all the text in the adjacent column turns permanently blue, which is what I was trying to accomplish earlier, except not for this particular column.
 
Really discouraged right now.  It just takes so long to figure out how to do the simplest things then when you think you finally have it, you're thrown back to square one.  It shouldn't be this hard to change font colors.
 
Wayne
Win 7, 64 bit Cyberpower Model 1, C Series (2011) 16 GB RAM
27" Samsung S27A350H, 24" ASUS VW242H  1920x1080

Tom

2015/10/13 11:36

Permalink

[quote=WayneK]So just now I went to set it again only this time it doesn't work like it did before.  It does not change the cell text blue when you enter edit mode.  The color remains black.  Instead, the color of all the text in the adjacent column turns permanently blue, which is what I was trying to accomplish earlier, except not for this particular column.[/quote]
 
you seem to have discovered a bug there Wayne
I'm able to reproduce something similar -- but not (yet) in the Sample Database:
 
When I change the Text Forecolour in a cell in the item field, the whole row get the same colour.
 
EDIT// as Pierre says, this (whole row getting colour) is default behaviour --
oddly it didnt happen in the attempt I made in the Sample Database -- will check that out when I get a chance.

Pierre_Admin

2015/10/13 09:18

Permalink

[quote=WayneK]
 Earlier, I thought I'd learned that if you select a column, then select a different font color (eg blue), then whenever you enter edit mode, the text of that cell turns to the selected color (blue).  I confirmed that repeatedly earlier and was sure that was how it worked.
 
So just now I went to set it again only this time it doesn't work like it did before.  It does not change the cell text blue when you enter edit mode.  The color remains black.  Instead, the color of all the text in the adjacent column turns permanently blue
[/quote]
 
Hi Wayne,
 
Like I said earlier, there is no command to color a column and there are also no command to color just some cells in a grid.
The "font color" command you're referring to is under the "Item" menu and it specifies the font / color of items. When you select a column, notice how all the items in the grid become selected. So when applying the font / color, you're actually doing this on all items. A font / color command for columns is a good idea, I'll put it on the list of things to do. 
 
As described in Item Formatting, how item font / colors are applied depends on the view type (grid, calendar, mapview, etc). In grids, you specify which column(s) show the font / color in Grid>Properties>Options
 
---------------------

 In InfoQube grids, outline formatting is structured as a hierarchy. In increasing order of precedence, these are:

  1. Overall default font: set in Tools>Options>General>View: Grid font and Grid font size settings
  2. Grid specific font: set in Grid>Properties>Options: Default Font
  3. Item font: Applies to the whole item or to specific columns, as defined in Grid>Properties>Options: Item Font applies to field
  4. In-cell format: Applied to text selections inside tcells only
  5. Conditional formats
---------------------

Pierre_Admin

2015/10/13 19:03

Permalink

To change the back color of a column, you can use conditional formatting:
  1. Right-click on the column and select Field Properties
  2. In the Conditional Formats section, double-click to add an item
  3. Click the check box under "Use ?"
  4. Leave the Criteria cell empty (unless you want to actually use conditional formats)
  5. In the Formats cell, enter "backcolor=xxx", where xxx can be a named color or hex code of the color
  6. Click on the Close button
HTH !
 
Pierre_Admin