Font colour in cell table

Ce sujet contient 21 réponses, 2 participants et a été mis à jour pour la dernière fois par HerveM1234, le il y a 11 années et 7 mois.

Voir les messages de 15 - 1 à 15 (sur un total de 22)

1 2 →

Auteur

Messages
22.10.2013 à 14:03 #35140

HerveM1234
Participant

Hi,

Is it possible to modify the font colour in a cell table depending of the value to display ?
For example, values calculated above 100 in red and below 100 in green.
Thanks for your help.

22.10.2013 à 14:03 #35161

HerveM1234
Participant

Hi,

Is it possible to modify the font colour in a cell table depending of the value to display ?
For example, values calculated above 100 in red and below 100 in green.
Thanks for your help.

24.10.2013 à 08:50 #35141

Bernhard Kantz
Participant

The only way to modify the font color of a cell table is to use VBA (in FlexPro Professional). You can check if the value is out of limit and then change the color. Here is an example how to change the font properties of cell nr 3:

[code]Dim myTable As CellTable
Set myTable = ActiveDatabase.ActiveFolder.Object(“CellTable”, fpObjectTypeCellTable)
Dim myCell As CellTableCell
Set myCell = myTable.Cells(3)
With myCell.Text.Font
.Italic = False
.Name = “Arial”
.Size = 12
.Color = &H8000000F
End With[/code]

25.10.2013 à 11:23 #35152

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35142

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35156

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35155

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35154

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35153

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35143

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35151

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35150

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35149

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35148

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

25.10.2013 à 11:23 #35147

HerveM1234
Participant

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again
Auteur

Messages

Voir les messages de 15 - 1 à 15 (sur un total de 22)

1 2 →

Vous devez être connecté pour répondre à ce sujet.