Conditional formatting the negative % value using the custom component tfileexcelsheetoutput.

[Ganshyam]

Hello,

I want to conditional format the -ve % value from input file to output file template.Here the values less then zero are conditionally formatted.

The conditional format is getting reflected in the output template file but the data it writes it is in text format.

But When i double click the data the text format is removed and the conditional format is reflected for that values.Here I have used the custom components from Talend Exchange.

Input file :

Talend job:

tfileexcelsheetoutput component configuration.

Output File:

Here in output file the data format is in % as highlighted but the data written in text format, if you remove the text by double clicking them the conditional formatting is reflected.

Please help me how to get rid of this text format in the output file so that conditional format is reflected.

Regards

[Anonymous]

@Jan Lolling​ , can you help?

Regards

Shong

[Ganshyam]

@Jan Lolling​ 

Thank you so much for your help.

It solved my problem.