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

Ganshyam — Sat, 16 Nov 2024 01:31:43 GMT

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

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

Anonymous — Mon, 07 Sep 2020 02:52:10 GMT

@Jan Lolling , can you help?

Regards

Shong

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

Ganshyam — Tue, 29 Sep 2020 07:11:08 GMT

@Jan Lolling

Thank you so much for your help.

It solved my problem.

topic Conditional formatting the negative % value using the custom component tfileexcelsheetoutput. in Talend Studio

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

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

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