Creating reports and dashboards | Stimulsoft community forum

Hi,
Now I use stimulsoft to show Amount with the Text Format property , but it did not supply the format I needed .
eg:
$(2.00) //when the amount is negative
$100.00 // when the amount is positive
$- // whe the amount is zero

the format is same as in Microsoft Excel the cell format set to "Accounting"
Does anyone has the solution ? Thanks

Hello.

There is no such text format type. But you could do all of it with expressions.

Thank you.

Aleksey Andreyanov wrote:Hello.

There is no such text format type. But you could do all of it with expressions.

Thank you.

Yeah , I could do all of it with expression . But when the value is zeor and should have showed as " - " , when I exported as excel ,in the cell it is " - " not zero , I will do some calculation depend on it , May the way of doing it with expression is not a correct way .
Any way else ?

Hello.

You could use Excel Value property of the text component to set zero value.

Thank you.